









                            SQL*PLUS Version 3.0


                            Quick Reference



                      ⪨ ࠢ筨  SQL*PLUS












































                                    -- 1 --



   ࠢ筨 ਢ ᨭ⠪  ᥬ  SQL*PLUS.  
 ஡ ଠ樥    SQL*PLUS 頩  "㪮⢮ 
 ࠢ筨 짮⥫  SQL*PLUS".


 襭  祭. 

 騥  ⠡ 뢠 ᮣ襭,  ਭ  
 㬥  ᠭ ᨭ⠪ .

 , ନ  ࠧ.

 ਧ   ਬ ᭥
 
 孨 ॣ,  BTITLE  ⥪ ⠪,  ᠭ; 易⥫쭮
                          뤥  孥 ॣ.

  ॣ    祭 ࠧ; ⠢ ᮮ⢥饥
                              祭.

 樠쭮   c  ᨬ.

 ᫮   char CHAR-祭 -ࠫ   窠  ࠦ ⨯
                              CHAR.
                d  e   ࠦ ⨯ .
                expr ࠦ । ⨯.
                m  n ᫮  ࠦ ⨯ NUMBER (᫮).

                ⥪ 쭠 (CHAR) ⠭     祪.
                ६ ६ 짮⥫ (᫨  뫪  㣮
                ⨯ ६).

 㣨 ᫮  ⠬,   ᯮ.

 㭪
 ਧ   ਬ ᭥
 
 ⨪쭠   |  ୠ⨢ ᨭ⠪᪨
             

 ᪮    [OFF | ON]    易⥫ ࠬ஢.  ᫨ 
                               ࠧ |,    . 
                              ᫥  ᪮  ᨬ |.

 䨣 ᪮   {OFF | ON} ୠ⨢ 易⥫ ࠬ; 
                                㪠 ࠬ஢.  ᫥
                               ᪮  ᨬ |.

 ન   {OFF  | ON} 祭  㬮砭; ᫨  祣 
                              , SQL*PLUS ࠧ㬥  祭.

  窨   n,n,...  ।騩 ()   ᪮쪮
                      ࠧ.


   室  SQL*PLUS
 
 ᯮ ᫥騥   ॣ樨  室  SQL*PLUS.

                                    -- 2 --



 SQLPLUS [[-S[ILENT]] [logon] [start] | -?]

            SQL*PLUS  樮 ⥬.

 logon       ᫥饬 ଠ:
           _짮⥫[/஫][@ᯥ䨪_] | / | /NOLOG

 start       ᫥饬 ଠ:
           @_䠩[.ext] [1 2 ...]

 {EXIT | QUIT} [SUCCESS  | FAILURE | WARNING| n | ६]

           ந  ⫮ , 蠥 SQL*PLUS,
           頥 ࠢ 樮 ⥬.


   믮 

 ᯮ ᫥騥   믮  ᡮ ६ ⨪ 
  SQL  PL/SQL.

 /      ( )
      믮 ࠭  SQL   PL/SQL  ⥪饣
      SQL-.    뢮.

 R[UN]   뢮  믮 ࠭  SQL   PL/SQL 
         ⥪饣   SQL-.

 TIMI[NG] [START ⥪ | SHOW | STOP]

      뢠 ६   饬 ६ 믮, 뢠
       ⥪饩 ६      뢠 ᫮
      ⨢ ६ ⥩.

 ᯮ ᫥   믮  樮 ⥬.

 HO[ST] []

      믮  樮 ⥬  室  SQL*PLUS.
      砭:   樮 ⥬  ᯮ짮 "$" 
      㣮 ᨬ  host.  㪮⢮  ⠭ ORACLE 
      襩 樮 ⥬.


 ᯮ ᫥   ᪠  SQL*Forms  SQL*PLUS.

 RUNFORM [樨] _
                      뢠 ਫ SQL*Forms  SQL*PLUS.
                      ᯮ짮  SQL, SQL*PLUS, PL/SQL. 


 ᯮ ᫥騥   ।஢  SQL   PL/SQL.

 A[PPEND] ⥪
       㪠 ⥪   ⥪饩 ப .  ⠢
      ஡  ⥪⮬  ।騬 ᨬ,   ஡



                                    -- 3 --



       APPEND  ⥪⮬. ⮡  ⥪ 稢騩 窮 
      ⮩,    窠  ⮩ (SQL*PLUS
          ⮩  ਧ 砭 ).

 C[HANGE] ࠧ⥫ ஥ [ࠧ⥫ [ [ࠧ⥫]]]
       ⥪ ⥪饩 ப .   ᯮ짮 
      䠢⭮-஢ ᨬ ⠪  "/"  "!"  ⢥
      ࠧ⥫.  ᪠ ஡  CHANGE   ࠧ⥫.

 DEL     ⥪ ப .

 I[NPUT] [⥪]
          ப ⥪ ᫥ ⥪饩 ୮ ப.

 L[IST] [n |
      n m |
      n * |
      n LAST |
      * |
      * n |
      * LAST |
      LAST]
      뢮    ப  ("*" 砥 ⥪ ப).
       ᪠ ஡  LIST  n  *,    LIST  LAST.
      ⮡ 뢥  ࠭  ,  LIST  ࠬ஢.

 ᯮ ᫥騥   ᮧ  ࠢ  䠩.

 @ _䠩[.ext]      믮 㪠  䠩.

 EDIT [_䠩[.ext]]
      뢠 ⥪⮢ । 樮 ⥬  ४஢
      㪠 䠩  ᮤন ⥪饣 . ⮡
      ⪮४஢ ᮤন ,   䠩.

 GET _䠩[.ext] [LIS[T ] | NOL[IST]]
      㦠 䠩 樮 ⥬  .

 REM[ARK]
      稭 ਩   䠩.  REMARK 頥 
      砫 ப,  ਩ 稢 殬 ப (ப 
       ᮤঠ ६  ਩  ). SQL*PLUS 
       ਩  .

 SAV[E] _䠩[.ext] [CRE[ATE ] | REP[LACE] | APP[END]]
                 ࠭ ᮤন   䠩 樮 ⥬ 
                 ( 䠩).

 STA[RT] _䠩[.ext] [1 2 ...]

      믮 㪠  䠩.  㬥 ⠢
       &1, &2,  .., ⮫쪮   ᪠.


 WHENEVER SQLERROR {EXIT [SUCCESS  | FAILURE | WARNING | n | ६] |
      CONTINUE}

      室  SQL*PLUS, ᫨  SQL   PL/SQL  訡.

                                    -- 4 --




         ᯮ ᫥騥   ᠭ ࠪ⨢ .

 ACC[EPT] ६ [NUM[BER] | CHAR] [PROMPT ⥪ | NOPR[OMPT]] [HIDE]
          ⠥ ப  ன⢠      ६
          짮⥫.

 DEF[INE] [६] | [६ = ⥪]
           । ६ 짮⥫  ᢠ  CHAR-祭. 
           ,  뢮 祭  ⨯    ६.

 PAU[SE] [⥪]
      뢮  ப  ப  ⥪⮬, ⥬  
      짮⥫ [Return]. , 뢮   ப   ⪫
      짮⥫.

 PROMPT  ⥪
          뫠 㪠 ᮮ饭   ப  ࠭ 짮⥫.

 UNDEF[INE] ६
       ६ 짮⥫,   ।  (
      DEFINE)   (㬥⠬  START).


 ᯮ ᫥騥 ᨬ  ᮧ ⠭ ६ 
 ࠬ஢   䠩.

 &n    । ࠬ   䠩,   믮
       ᯮ  START. START ⠢ 祭,    
        ᫥   䠩: &1 , &2 ன    ..

 &६_짮⥫
                          뢠 ⠭ ६  

 &&६_짮⥫
                          SQL  SQL*PLUS. SQL*PLUS ⠢ 祭
                          㪠 ६ 짮⥫  
                          㦥  ⠭筮 ६. ᫨
                          ६ 짮⥫  ।, SQL*PLUS
                          ᥣ 㤥    祭 
                          ६ ⨯ "&",  ⮫쪮  ࠧ 
                          ६ ⨯ "&&".

 .(窠)       ᯮ  ࠧ  ⠭筮 ६
                 ᫥ ᨬ,   ਭ  
                த  .


                   ଠ஢ १⮢ ᮢ 

 ᯮ ᫥騥   ଠ஢, ࠭  
 १⮢  ᮢ.

 BRE[AK] [ON _ [⢨ [⢨]]] ...
            ।    ଠ஢ 㤥   (ਬ,
            ய ப  ᬥ 祭  ⮫).  BREAK 
            ࠬ஢, ⮡ 뢥 ⥪騥 BREAK-ᠭ.


                                    -- 5 --



_     ᫥饩 ଥ: { |ࠦ|ROW | REPORT}

⢨           ᫥饩 ଥ: [SKI[P] n | [SKI[P] PAGE]
                                             [NODUP[LICATES ] | DUP[LICATES]]

 BTI[TLE] [printspec [⥪ | ६] ...] | [OFF | ON ]
      頥  ଠ 㪠    ࠭ ,
       뢮 ⥪饥 ᠭ BTITLE. ᠭ ࠧ printspec ᬮ 
      TTITLE.

 CL[EAR] 
      뢠  頥 ⥪饥 祭  ⠭  㪠
      樨;  -    ᫥ ࠧ:
      BRE[AKS]
      BUFF[ER]
      COL[UMNS]
      COMP[UTES]
      SCR[EEN]
      SQL
      TIMI[NG]

 COL[UMN] [{ | ࠦ} [ ...]]
      । ਡ 뢮  㪠 , ⠪  ⥪
         ଠ 뢮 ᨬ  ᫮ ;  
          ᫥ ࠧ:
      ALI[AS] 
      CLE[AR] | DEF[AULT]
      COLOR {梥 | ६_梥}
      FOLD_A[FTER] n
      FOLD_B[EFORE] n
      FOR[MAT] ଠ
      HEA[DING] ⥪
      JUS[TIFY] {L[EFT] | C[ENTER] | C[ENTRE] | R[IGHT]}
      LIKE {ࠦ | }
      LINEAPP {LINE | MARK | BOTH}
      NEWL[INE]
      NEW_V[ALUE] ६
      NOPRI[NT] | PRI[NT]
      NUL[L] ᨬ
      OLD_V[ALUE] ६
      ON  | OFF
      PATTERN {pattern_number | pattern_variable}
      WRA[PPED]  | WOR[D_WRAPPED] | TRU[NCATED]

      ⮡ ᬮ ਡ 뢮   ࠦ,  
      COLUMN     ࠦ  ࠬ஢. ⮡ ᬮ
      ਡ 뢮  ,   COLUMN  ࠬ஢.
        ଠ 뢮 ,  FORMAT   ଠ.
      ⮡  ਭ CHAR  LONG   n ᨬ, ᯮ
      FORMAT An.

        ଠ 뢮 NUMBER-, ᯮ FORMAT  
       ᫥ ⮢ ⠡:

         ਬ    ᠭ
      
      9         9999       ਭ 뢮 ᫠


                                    -- 6 --



      0         0999      뢮 騥 㫨
                9990      뢮   ஡,  ᫮ ࠢ .

      $        $9999      । ᫮ 뢮  .
              9999      뢮 㫥 祭  ஡.
      MI      9999MI      뢮 "-" ᫥ ਤ⥫쭮 ᫠.
      PR      9999PR      뢮 ਤ⥫쭮 ᫮  㣫 ᪮.
        9,999      뢮   㪠 樨.
      窠    99.99      ⠢     樨.
      V       999V99       祭  10S nT,  n-  ⢮
                          "9" ᫥ "V".

       9.999      뢮  ᯮ樠쭮 ଠ (ଠ
                           ᮤঠ  "E").

      DATE     DATE       뢮 祭    ଠ MM/DD/YY;
                          ᯮ  ଠ஢ NUMBER-
                          ᮤঠ ᪨ .

 COMP[UTE] [㭪 ... OF {ࠦ |  | } ...
      ON {ࠦ |  |  | REPORT | ROW}]

        ⠥ ⮣ ப, ᯮ ⠭ ᫥
       ⢮ ࠭ ᥩ. , 뢮  ।
      COMPUTE.  ᫥饩 ⠡ ਢ ᯨ᮪ ⨬ 㭪権. 
      㭪樨  NUMBER,  ࠡ ⮫쪮  㫥묨 祭ﬨ.

      㭪    ᫥                    ⨯ 
      
      AVG        । 祭            NUMBER
      COU[NT]    稪 祭             ⨯
      MAX[IMUM]  ᨬ쭮 祭       NUMBER, CHAR
      MIN[IMUM]  쭮 祭        NUMBER, CHAR
      NUM[BER]    ப ( ப)   ⨯
      STD       ।筮 ⪫  NUMBER
      SUM        㬬 祭              NUMBER
      VAR[IANCE] ᯥ 祭          NUMBER

 SPO[OL] [_䠩[.ext] | OFF | OUT]

      ࠭ १ ᮢ  䠩 樮 ⥬, , 筮,
      뫠 䠩  ਭ. OFF ४頥 ਧ. OUT ४頥
      ਧ  뫠 䠩   ( 㬮砭) ਭ. ⮡
      뢥 ⥪饥 ﭨ ਧ樨,  SPOOL  ࠬ஢.


 TTI[TLE] [printspec [⥪ | ६] ...] | [OFF | ON]

      頥  ଠ 㪠    ࠭
      ,  뢮 ⥪饥 ᠭ TTITLE. ᯮ  ࠧ
      printspec ᫥騥 :

      COL n
      S[KIP] [n]
      TAB n
      LE[FT]
      CE[NTER]


                                    -- 7 --



      R[IGHT]
      BOLD
      FORMAT ᨬ

            

 ᯮ ᫥騥   㯠  ஢   ⠡栬
 ࠧ .

 CONN[ECT] [_짮⥫[/஫][@ᯥ䨪_] | /]

      砥 㪠 짮⥫  ORACLE. ᫨   ᯥ䨪-
      _,      㬮砭. ᫨    _짮-
      ⥫ / ஫,    .  CONNECT   ⮩ 
      (/),   ᯮ ॣ  㬮砭  (ops$).

 DISC[ONNECT]
      ஢  ⫮      ⪫砥 ⥪饣
      짮⥫  ORACLE,    SQL*PLUS.

 COPY [FROM _짮⥫[/஫][@ᯥ䨪_]]
      [TO _짮⥫[/஫][@ᯥ䨪_]]
      {APPEND | CREATE | INSERT | REPLACE}
      楫_⠡ [(,  ...)
      USING 

           ORACLE  ⠡ 㣮 . APPEND, CREATE,
      INSERT, REPLACE 㪠뢠,  ந ஢, ᫨ 楫
      ⠡ 㦥 . ᯮ짮  (USING) 
      ⠡-筨, । 㥬     ப.

 ⥫ 

 DESC[RIBE] [짮⥫.]ꥪ[@_裡__]

      뢮 ।   㪠 ⠡, 㠫쭮 ⠡
       ᨭ.

 SET ⥬_६ 祭

      ࠨ । SQL*PLUS  ⥪饣 ᥠ, ਬ: ⠭
      ਭ 뢮 ᫮   ⢮ ப  ࠭. 
      ਢ ⥬ ६   祭:
      ARRAY[SIZE] {20  | n}
      AUTO[COMMIT] {OFF  | ON | IMM[EDIATE]}
      BLO[CKTERMINATOR] {.  | c}
      CMDS[EP] {; | c | OFF  | ON}
      COM[PATIBILITY] {V5 | V6 }
      CON[CAT] {.  | c | OFF | ON }
      COPYC[OMMIT] {0  | n}
      CRT crt
      DEF[INE] {&  | c | OFF | ON }
      ECHO {OFF  | ON}
      EMBEDDED {OFF  | ON}
      ESC[APE] {\  | c | OFF  | ON}
      FEED[BACK] {6  | n | OFF | ON}
      FLU[SH] { OFF | ON }
      HEA[DING] {OFF | ON }

                                    -- 8 --



      HEADS[EP] {|  | c | OFF | ON }
      LIN[ESIZE] {80  | n}
      LONG {80  | n}
      MAXD[ATA] n
      NEWP[AGE] {1  | n}
      NULL ⥪
      NUMF[ORMAT] ଠ
      NUM[WIDTH] {10  | n}
      PAGES[IZE] {14  | n}
      PAU[SE] {OFF  | ON | ⥪}
      RECSEP {WR[APPED]  | EA[CH] | OFF}
      RECSEPCHAR {_ | c}
      SCAN {OFF | ON }
      SHOW[MODE] {OFF  | ON}
      SPA[CE] {1  | n}
      SQLC[ASE] {MIX[ED]  | LO[WER] | UP[PER]}
      SQLCO[NTINUE] {>  | ⥪}
      SQLN[UMBER] {OFF | ON }
      SQLPRE[FIX] {#  | c}
      SQLP[ROMPT] {SQL>  | ⥪}
      SQLT[ERMINATOR] {;  | c | OFF | ON }
      SUF[FIX] {SQL  | ⥪}
      TAB {OFF | ON}
      TERM[OUT] {OFF | ON }
      TI[ME] {OFF  | ON}
      TIMI[NG] {OFF  | ON}
      TRIM[OUT] {OFF | ON }
      UND[ERLINE] {-  | c | ON  | OFF}
      VER[IFY] {OFF | ON }
      WRA[P] {OFF | ON }

 SHO[W] []

      뢮 祭 ⥬ ६ SQL*PLUS-.  ⢥ 樨
      ᯮ   ᫥ ନ:
      ⥬_६
      ALL
      BTI[TLE]
      LNO
      PNO
      REL[EASE]
      SPOO[L]
      SQLCODE
      TTI[TLE]
      USER

        ⥬ ६, ⠭  SET 
      樨 "⥬_६".

 SQL*PLUS Quick Reference
 Version 3.0         Part No.3703-V3.0 April 1990








                                    -- 9 --
