2009/06/24 11:56
[공인] Oracle Database 10g: Program with PL/SQL
2009/06/24 11:56 in Information Technology/Database
1. DBMS_OUTPUT SETTING
- SET SERVEROUTPUT ON
2. STORED PROCEDURE, FUNCTION... COMPILE
SQL> @file_name
3. STORED PROCEDURE, FUNCTION... EXECUTION
SQL> exec[ute] file_name(param);
4. VIEW OBJECT STATUS
SELECT OBJECT_NAME, STATUS
FROM USER_OBJECTS
WHERE OBJECT_NAME = 'SELECT_JOB';
5. VIEW SOURCE CODE
SET PAGESIZE 500;
SELECT TEXT
FROM USER_SOURCE
WHERE NAME = 'SELECT_JOB'
ORDER BY LINE;
2. [Documentation] click
3. [Database] click
4. [View library] click
5. [Books] tab click
6. find by keyword
1. Oracle startup
1.1 root@blah> sqlplus / as sysdba
1.2 SQL> startup
2. SQLPlus editor setting
2.1 SQL> define_editor=gedit
or
SQL> define_editor=vi
2.2 SQL>ed file_name
2.3 write script
2.4 SQL> @file_name
Prev
Rss Feed