第 1章.txt

oracle操作基础基础基础基础基础基础基础基础基础基础基础基础

例1.1 
CONNECT scott/tiger@oradb
SET pagesize 5
SPOOL c:\test.txt
SELECT * FROM  emp;
PROMPT "now 200 char width"
SET linesize 200
SET pagesize 20
SELECT * FROM  emp;
SPOOL OFF

例1.2
SQL> CONN system/system@oradb AS SYSDBA
SQL> SHUTDOWN
SQL> STARTUP NOMOUNT
SQL> ALTER DATABASE MOUNT;
SQL> ALTER DATABASE OPEN;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> CONN scott/tiger@oradb
SQL> CONN system/system@oradb AS SYSDBA
SQL> ALTER SYSTEM DISABLE RESTRICTED SESSION;
SQL> CONN scott/tiger@oradb
SQL> SELECT * FROM dept;