Shulou(Shulou.com)06/01 Report--

Sqlplus environment variables and shortcut actions:

Time class:

Set time on

Set timing on

Format class:

Set linesize 180

Set pagesize 999

Operation indication:

Set sqlprompt "_ USER@ _ CONNECT_IDENTIFIER >"

/ = run runs the last sql statement in the buffer

List = l look at the last sql statement in the buffer; l m n displays the m ~ n lines in the buffer

The last sql statement in the ed edit buffer

Sav 1.sql saves the last sql statement in the buffer to the script file 1.sql

Sav 1.sql REPLACE replace script file

C modify and replace

An append

Spool 1.txt append takes the content displayed on the screen offline to the 1.txt file

Spool off

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.