Oracle --- control the SQL * Plus environment and Data Dictionary

Control the SQL * Plus environment and Data Dictionary

1. Control the SQL * Plus Environment

A) SET environment variable value

B) SHOW environment variable | ALL

 

SQL> show all

Appinfo is OFF and set to "SQL * Plus"

Arraysize 15

Autocommit OFF

Autoprint OFF

Autorecovery OFF

Autotrace OFF

Blockterminator "." (hex 2e)

Btitle OFF is the first few characters of the next SELECT statement.

Eclipsep OFF

Colsep ""

Compatibility version NATIVE

Concat "." (hex 2e)

Copycommit 0

COPYTYPECHECK is ON

Define "&" (hex 26)

Describe DEPTH 1 LINENUM OFF INDENT ON

Echo OFF

Editfile "afiedt. buf"

Embedded OFF

Escape OFF

Used for feedback on 6 or more rows

Flagger OFF

Flush ON

Heading ON

Headsep "|" (hex 7c)

Instance "local"

Linesize 80

Lno 8

Loboffset 1

Logsource ""

Long 80

Longchunksize 80

Markup html off head "<style type = 'text/css '> body {fo

Newpage 1

Null ""

Numformat ""

Numwidth 10

Pagesize 14

PAUSE is OFF

Pno 2

Recsep WRAP

Recsepchar "" (hex 20)

VPC: release 1002000100

Repfooter OFF is NULL

Repheader OFF is NULL

Serveroutput OFF

Shiftinout INVISIBLE

Showmode OFF

Spool OFF

Sqlblanklines OFF

Sqlcase MIXED

Sqlcode 0

Sqlcontinue ">"

Sqlnumber ON

Sqlpluscompatibility 10.2.0

Sqlprefix "#" (hex 23)

Sqlprompt "SQL>"

Sqlterminator ";" (hex 3b)

Suffix "SQL"

Tab ON

Termout ON

Timing OFF

Trimout ON

Trimspool OFF

Ttitle OFF is the first few characters of the next SELECT statement.

Underline "-" (hex 2d)

The USER is SCOTT"

Verify ON

Wrap: change to the next line

2. SQL * Plus environment variable ECHO

When ECHO is set to ON, not only the running result is returned when the script is run, but also the command is returned.

SQL> show echo

Echo OFF

SQL> set echo on

SQL> show echo

Echo ON

SQL> select * from dept;

 

DEPTNO DNAME LOC

-------------------------------------

10 ACCOUNTING NEW YORK

20 RESEARCH DALLAS

30 SALES CHICAGO

40 OPERATIONS BOSTON

SQL> save "D: \ s ";

File D: \ s. SQL has been created.

SQL> @ D: \ s. SQL

SQL> select * from dept

2/

 

DEPTNODNAME LOC

-------------------------------------

10 ACCOUNTING NEW YORK

20 RESEARCH DALLAS

30 SALES CHICAGO

40 OPERATIONS BOSTON

3. set feedback n indicates that the number of returned records is displayed when at least six records are selected for the query. However, if the number of records selected for the query is less than six, the number of returned records is not displayed.

4. The statement starting with REM is used as a comment.

5. USER _ * ALL _ * DBA _*