Oracle Learning Notes (i)

1. Common Sqlplus Commands
(1) View the currently logged in User: Show user;
(2) Switch the current login User: Conn username/password (switch system user +as SYSDBA);
(3) Disconnect the currently logged-in User: disc;
(4) Exit Sqlplus:exit;
(5) Modify user password: PASSW (modify other user password to + user name);
(6) Interactive command:&
Sql> SELECT * from emp where job= ' &job ';
(7) Edit script: Edit
Sql> edit D:\aa.sql prompts to create the file and edit it
(8) Screen display record, save to file: Spool
Sql>spool on; open
Sql>spool d:/sql.sql; Save file path
Sql>sql statement;
Sql>spool off; end

(9) Set the width of the display line: set linesize characters; (default 80)

Sql>show linesize;

Sql>set Linesize 90;

(10) Set the number of rows per page: pagesize number of rows; (default 14)

Sql>show pagesize;

Sql>set pagesize 90;

PS: This article for Bo Master original, reprint please indicate source: http://www.cnblogs.com/Y-zhiwei/.

Oracle Learning Notes (i)