gwoo09-blog
gwoo09-blog
HELLO, ...
3 posts
Don't wanna be here? Send us removal request.
gwoo09-blog · 8 years ago
Text
Warning: Procedure created with compilation errors.
sqlplus에서 procedure를 생성할 때, Warning: Procedure created with compilation errors. 이와 같은 오류가 발생되면 ‘show error’로 에러를 파악할 수 있다.
SQL> SHOW ERROR Errors for PROCEDURE SAMPLE01:
LINE/COL ERROR -------- ----------------------------------------------------------------- 14/3     PL/SQL: SQL Statement ignored 14/17    PLS-00201: identifier 'V_DETP.DEPTNO' must be declared
0 notes
gwoo09-blog · 8 years ago
Text
SQL SETTING (LINESIZE, PAGESIZE)
◎ SQLPLUS COMMAND >> SQL>SET LINESIZE number >> SQL>SET PAGESIZE number
◎ PIX SETTING >> oracle\product\server\sqlplus\admin\glogin.sql SET LINESIZE number SET PAGESIZE number 
◎ SHOW SETTING >> SQL>SHOW LINESIZE OR  SHOW LINESI >> SQL>SHOW PAGESIZE OR  SHOW PAGESI
0 notes
gwoo09-blog · 8 years ago
Text
“hello, world”
first text
0 notes