SELECT * FROM USER_TABLES;
SELECT * FROM USER_VIEWS;
SELECT * FROM V$INSTANCE;
set sqlprompt "_user>";
sqlplus as / sysdba
startup;
shutdown immediate;
--------------------------------------------
init 0
SELECT * FROM USER_VIEWS;
SELECT * FROM V$INSTANCE;
set sqlprompt "_user>";
sqlplus as / sysdba
startup;
shutdown immediate;
--------------------------------------------
init 0
'Database > Oracle' 카테고리의 다른 글
대량의 데이터 INSERT(HINT) (0) | 2010.02.01 |
---|---|
Oracle Function Reference (0) | 2009.12.30 |
to_char format (0) | 2009.12.30 |
Group Fucntion (0) | 2009.12.30 |
Join (0) | 2009.12.30 |