sqlplus

admin

set

1. SET APPI[NFO]{ON | OFF | text}
   
2. SET ARRAY[SIZE] {15 | n}
   
3. SET AUTO[COMMIT] {ON | OFF | IMM[EDIATE] | n}
   
4. SET AUTOP[RINT] {ON | OFF}
   
5. SET AUTORECOVERY {ON | OFF]
   
6. SET AUTOT[RACE] {ON | OFF | TRACE[ONLY]} [EXP[LAIN]] [STAT[ISTICS]]
   
7. SET BLO[CKTERMINATOR] {. | c | ON | OFF}
   
8. SET CMDS[EP] {; | c | ON | OFF}
   
9. SET COLINVI[SIBLE] {ON | OFF}
   
10. SET COLSEP {_ | text}
    
11. SET CON[CAT] {. | c | ON | OFF}
    
12. SET COPYC[OMMIT] {0 | n}
    
13. SET COPYTYPECHECK {ON | OFF}
    
14. SET DEF[INE] {& | c | ON | OFF}
    
15. SET DESCRIBE [DEPTH {1 | n | ALL}] [LINENUM {ON | OFF}] [INDENT {ON | OFF}]
    
16. SET ECHO {ON | OFF}
    
17. SET EDITF[ILE] file_name[.ext]
    
18. SET EMB[EDDED] {ON | OFF}
    
19. SET ERRORL[OGGING] {ON | OFF} [TABLE [schema.]tablename] [TRUNCATE] [IDENTIFIER identifier]
    
20. SET ESC[APE] {\ | c | ON | OFF}
    
21. SET ESCCHAR {@ | ? | % | $ | OFF}
    
22. SET EXITC[OMMIT] {ON | OFF}
    
23. SET FEED[BACK] {6 | n | ON | OFF | ONLY} [SQL_ID]
    
24. SET FLAGGER {OFF | ENTRY | INTERMED[IATE] | FULL}
    
25. SET FLU[SH] {ON | OFF}
    
26. SET HEA[DING] {ON | OFF}
    
27. SET HEADS[EP] { | | c | ON | OFF}
    
28. SET HIST[ORY] {ON | OFF | n}
    
29. SET INSTANCE [instance_path | LOCAL]
    
30. SET LIN[ESIZE] {80 | n | WINDOW}
    
31. SET LOBOF[FSET] {n | 1}
    
32. SET LOBPREF[ETCH] {0 | n}
    
33. SET LOGSOURCE [pathname]
    
34. SET LONG {80 | n}
    
35. SET LONGC[HUNKSIZE] {80 | n}
    
36. SET MARK[UP] CSV {ON|OFF} [DELIMI[TER] character] [QUOTE {ON|OFF}]
    
37. SET MARK[UP] HTML {ON|OFF} [HEAD text] [BODY text] [TABLE text] [ENTMAP {ON|OFF}] [SPOOL {ON|OFF}] [PRE[FORMAT] {ON|OFF}]
    
38. SET NEWP[AGE] {1 | n | NONE}
    
39. SET NULL text
    
40. SET NUMF[ORMAT] format
    
41. SET NUM[WIDTH] {10 | n}
    
42. SET PAGES[IZE] {14 | n}
    
43. SET PAU[SE] {ON | OFF | text}
    
44. SET RECSEP {WR[APPED] | EA[CH] | OFF}
    
45. SET RECSEPCHAR { | c}
    
46. SET ROWLIMIT {n | OFF}
    
47. SET ROWPREF[ETCH] {1 | n}
    
48. SET SECUREDCOL {ON | OFF} [UNAUTH[ORIZED] text][UNK[NOWN] text]
    
49. SET SERVEROUT[PUT] {ON | OFF} [SIZE {n | UNL[IMITED]}] [FOR[MAT] {WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED]}]
    
50. SET SHIFT[INOUT] {VIS[IBLE] | INV[ISIBLE]}
    
51. SET SHOW[MODE] {ON | OFF}
    
52. SET SQLBL[ANKLINES] {ON | OFF}
    
53. SET SQLC[ASE] {MIX[ED] | LO[WER] | UP[PER]}
    
54. SET SQLCO[NTINUE] {> | text}
    
55. SET SQLN[UMBER] {ON | OFF}
    
56. SET SQLPLUSCOMPAT[IBILITY] {x.y[.z]}
    
57. SET SQLPRE[FIX] {# | c}
    
58. SET SQLP[ROMPT] {SQL> | text}
    
59. SET SQLT[ERMINATOR] {; | c | ON | OFF}
    
60. SET STATEMENTC[ACHE] {0 | n}
    
61. SET SUF[FIX] {SQL | text}
    
62. SET TAB {ON | OFF}
    
63. SET TERM[OUT] {ON | OFF}
    
64. SET TI[ME] {ON | OFF}
    
65. SET TIMI[NG] {ON | OFF}
    
66. SET TRIM[OUT] {ON | OFF}
    
67. SET TRIMS[POOL] {ON | OFF}
    
68. SET UND[ERLINE] {- | c | ON | OFF}
    
69. SET VER[IFY] {ON | OFF}
    
70. SET WRA[P] {ON | OFF}
    
71. SET XMLOPT[IMIZATIONCHECK] [ON|OFF]
    
72. SET XQUERY BASEURI {text}
    
73. SET XQUERY ORDERING {UNORDERED | ORDERED | DEFAULT}
    
74. SET XQUERY NODE {BYVALUE | BYREFERENCE | DEFAULT}
    
75. SET XQUERY CONTEXT {text}
    
76. SHO[W] [option]
    
77. Shows the value of a SQL*Plus system variable, or the current SQL*Plus environment. Enter any system variable set by the SET command in place of system_variable. SHOW SGA requires a DBA privileged login. Use one of the following terms or clauses in place of option:
    
78. 
    
79. system_variable
    
80. ALL
    
81. CON_ID
    
82. CON_NAME
    
83. BTI[TLE]
    
84. EDITION
    
85. ERR[ORS] [ {ANALYTIC VIEW | ATTRIBUTE DIMENSION | HIERARCHY | FUNCTION | PROCEDURE | PACKAGE | PACKAGE BODY | TRIGGER | VIEW | TYPE | TYPE BODY | DIMENSION | JAVA CLASS} [schema.]name]
    
86. HIST[ORY]
    
87. LNO
    
88. LOBPREF[ETCH]
    
89. PARAMETER[S] [parameter_name]
    
90. PDBS
    
91. PNO
    
92. RECYC[LEBIN] [original_name]
    
93. REL[EASE]
    
94. REPF[OOTER]
    
95. REPH[EADER]
    
96. ROWPREF[ETCH]
    
97. SGA
    
98. SPOO[L]
    
99. SPPARAMETER[S] [parameter_name]
    
100. SQLCODE
     
101. STATEMENTC[ACHE]
     
102. TTI[TLE]
     
103. USER
     
104. XQUERY

复制代码