SELECT * FROM USER_TABLES;
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

+ Recent posts