


                                  22

                         


   ⮩  ᬠਢ ࠭祭 楫⭮, ਭ  SQL*Forms.
    ।⠢ ᫥騥 ⥬:
       -   ࠭祭 楫⭮  ꥪ
       -   ࠭祭 楫⭮  
       -   ࠭祭 楫⭮  16-⮢ ।

  砭:  ࠭祭   楫⭮       㠫 
   設   ᬠਢ   㪮⢥.  ⮡  
  ଠ  ࠭祭  楫⭮    ,   
  ⠫樨 ORACLE  㪮 짮⥫.

  ࠭祭 楫⭮  ꥪ

       ।⠢  ࠭祭 楫⭮,
  ਬ塞    ꥪ⮢  SQL*Forms     㣨
  ⮢, ⭮  ⨬ ꥪ⠬.


          ࠭祭 楫⭮/砭
  
  뫮       255 뫮
           ࠭祭 楫⭮ ⭮ 
           뫪 ᫮ 痢  ।
   ଥ        ६     SQL.

            255 
             ࠭祭  楫⭮  ⭮
                 ⮫쪮  SQL*Forms (஥)  SQL*Forms (८ࠧ).

  ஫       8190 ஢ப
  ࠭          ࠭祭 ⭮   
   ଥ          ଥ,         । ⨬
                 ஫   .

  ਭ         255 ᨬ
               ࠭祭 ⭮    , ஬  
                  ⨯    LONG.      LONG    
                  65,536  ᨬ.

           255 
   ଥ          ࠭祭  楫⭮  ⭮ ⮫쪮  SQL*Forms
                 (஥)  SQL*Forms (८ࠧ).

  ਣ஢      4095 ਣ஢
   ଥ

  蠣          8190 蠣 ਣ
  ਣ
   ଥ

  ࠭        8190 ࠭



                                   -- 224 --



  ਭ         255 ᨬ
  ࠭

  ਭ         255 ᨬ
  쭮
  ६

  ᫮          10922 ப
  ப  ଥ


  ࠭祭 楫⭮ 

     -  , ᢠ ORACLE RDBMS SQL .  
  ᯮ    SQL ,   묨    ⭮襭 
  । ଠ樨       ⭮襭  SQL , 
    묨  ਣ.  SQL*Forms  ஫ ᢮  
        SQL   ਣ V2.

   ᫥饩 ⠡ ।⠢ ࠭祭 楫⭮  ஢ 
  .

          ࠭祭 楫⭮/砭
  
         稭 ࠬ OPEN_CURSORS  
            䠩 INT.ORA
  (ᨬ)

         - 5  ORACLE
          - 4    (1  SELECT, 2  UPDATE,
  ()        1  INSERT  1  DELETE).    ࠭祭 ᯮ-
                      ᫮,     ஢,
                      Set Options   ४⥫
                    ப.

                 - 1  0  蠣 ਣ (1    SQL).
                     ࠭祭   ᯮ      ᫮,
                         ஢,       Set
                   Options         ४⥫  ப.

  :       ࠪ⨪  蠣  ਣ  New Cursor Area
                 o-४⥫, SQL*Forms ( ଠ ᮢ 
                   ⥪饩 樨 SQL ᮢ   ਣ
                 ⥪饩 樨 SQL t-४⥫, SQL*Forms ( ଠ

  ࠭祭 楫⭮  16-⮢ ।

   16-⮢ । 65,535 ⮢ -  ।쭮 ᫮ ப , 
   訬 ⢮ , ஥     뤥.  
    室 ᫥饥:
        -  
        -   蠣 ਣ
        - ᯮ⥫ ᮮ饭
        - ᮮ饭  訡 ਣ
        -  
        -  ⠡     ⮫殢    
        - 稭, ᯮ㥬  㬮砭
        - ﭭ ⥪

                                   -- 225 --




             5                         

          23                       


    ⮩  ᬠਢ , ⠢騥 SQL*Forms. 
   ᫥騥 :
         - SQL*Forms (८ࠧ)
         - SQL*Forms (஥஢)
         - SQL*Forms (஢)
         - SQL*Forms ( ଠ)

     ⢥  ,      ᥣ  ᯮ SQL*Forms
   (஥஢),   ன   砥   㣨  ⠬.
   ,   뢠 㤮 ᪠ 㣨  אַ 
    ப.

    ⮩  ⠪ ।⠢ ਧ ⮬᪮ 室 ORACLE.
   ਧ ⠭樮 室   ४⥫ SQL*Forms.
   :       ଠ  

⮬᪨ 室

  ਧ  ⮬᪮  室     室  த ORACLE
      짮⥫   ஫.      室  ⠪
  ࠧ,  ORACLE ᯮ OPS$ ID, ⮡ 易   짮⥫ 
  ORACLE  襩 樮 ⥬ User ID.

    ᯮ짮  ਧ  ⮬᪮  室   ᥬ  SQL*Forms
  ⠬.    ORACLE Database  Administrator's  Guide  
  ଠ樥   ᯮ짮 ⮣ ਧ.

⠭樮 室

        SQL*Net          ᯥ஢ ⠭樮  
  , 室      SQL*Forms.   ᯮ ਧ
  ⠭樮 室,   㤠         "஧筠"     -
  SQL*Forms    ᥡ  室  ࠧ,   頥  㧫 १
    頥    襩 쭮 設.

  ⮡  ।  㤠       ப, ⠢
  ᫥ ஫  ࠩ   㧫, ᯮ ᫥騩 ᨭ⠪:

  : node_name

     :
  driver_name    뢠    ࠩ,    ஬     
                 㤠  .  ⠭  ਭ 祭 
                 㬮砭     ⭮  ⥬.

  node_name      뢠  㤠 㧥  ᮤঠ騩 楫 
                 .        㬮砭   㧫.

  ਬ,     ।  ᫥    믮 
  ORDER_ENTRY     㬮砭  㧫 LONDON:

  RUNFORM ORDER_ENTRY SCOTT/TIGER@D:LONDON

                                   -- 226 --



  ᫨      । 㤠     室 ࠭
  SQL*Forms,  室 ⠢  ࠩ   㧫 ᫥ 襣
   짮⥫.  (ਬ, SCOTT@D:LONDON).

   ଠ樥  SQL*Net   SQL*Net User's Guide.

  砭:  ⮡  믮  ⠭樮 室,  室 뢠
   㤠 ୮ 㧫,  室 楫  .

SQL*Forms (஥஢)

  SQL*Forms (८ࠧ) ᮧ INP 䠩    ଠ  
   ᮧ    ଠ     INP 䠩. ᫥ ८ࠧ
      (ᬮ  ,   ᯥ஢
  d-४⥫, 㭨⮦騩    ).

  ᯮ   SQL*Forms   (८ࠧ)   ᫥騬 ࠧ:

   -      ଠ      INP 䠩,  
     ஢    㣮 ᨨ SQL*Forms.

    -   INP  䠩       ଠ  .

    -  INP 䠩  ᨨ ଠ 3.0  INP 䠩   ଠ
      2.0  2.3.

  :       ଠ  


INP             ᮧ   ଠ     INP
८-      䠩  ᯮᮡ:

            -   ப, ᯮ  CONVERT,
            । i-४⥫,  INP 䠩   .  ਬ,
            ⮡ ᮧ  SAMPLE2   䠩   SAMPLE1.INP,   
            ᫥ :

  CONVERT - 1 SAMPLE 1 SAMPLE 2 [username/password]

          -   SQL*Forms  (஥),  롥   Load   Action 
            । INP 䠩,     ८ࠧ  
               Load Form. ⥬ ࠭    
            ।⢮ 樨 Save   Action.


      ᮧ INP 䠩    ଠ 
 ८-      ᯮᮡ:
 INP
  -      ப,  ᯮ   CONVERT, ।  INP
    䠩   .  ਬ, ⮡ ᮧ 䠩 SAMPLE3.INP  
    SAMPLE2,  ᫥ :

     CONVERT SAMPLE3 SAMPLE2 [username/password]

  -  SQL*Forms (஥), 롥  Generate   Action  ।
    ,    ८ࠧ    Generate Form.
    ,      楤 ⠪  ᮧ  FRM  䠩,  
    ࢨ.

                                   -- 227 --



INP  INP       ᮧ INP 䠩  ᨨ ଠ 3.0  INP
८-      䠩 ᨨ ଠ 2.0  2.3.   ப,
      ᯮ   CONVERT,  । v-४⥫   INP
              䠩. ਬ, ⮡ ᮧ   3.0 INP 䠩  -
              ᨨ 2.3 INP 䠩, 뢠 OLD.INP,  ᫥ :

              CONVERT - v23 OLD [username/password]


        CONVERT 뢠 SQL*Forms (८ࠧ) 
८-        ப.  ⮡  ᯮ짮    ,
         ⥬  ᫥騩 :

              CONVERT [option option...] inp_filename formname
              [username/password]

         :
      option         ।  ४⥫  ப, 
                       ⨢஢         ᥠ
                     SQL*Forms (८ࠧ).
                      SQL*Forms (८ࠧ) 室 ᯮ짮
                     ᫥騥   ४⥫   ப:   -c,  -d,
                     -i,  -s   -v-४⥫.

      inp_filename   ।   INP 䠩,    ᮧ
                      ८ࠧ  䨪 .INP.


      formname       ।  ,    ८ࠧ 
                     ᮧ.

      username/      ।   짮⥫  ORACLE
      password        ஫.

      ᫨    ।   짮⥫  ஫  ⥬
      ,  SQL*Forms  ᯮ  ⮬᪮ 室 OPS$ ID.  ᫨
      SQL*Forms    OPS$ ID,   ᮮ饭  訡.

            CONVERT ?     樮 ⥬, ⮡
       .

      :      ४⥫  ப, SQL*Forms (८ࠧ)


SQL*Forms (஥஢)

  SQL*Forms (஥஢) ᮧ      .
  SQL*Forms (஥஢)  ᭮ ⮩
  SQL*Forms,   뢠   ⠫    SQL*Forms.

  :       ଠ  

        SQLFORMS 뢠 SQL*Forms (஥஢) 
SQLFORMS         ப.  ⮡  ᯮ짮    ,
               ᫥騩   ⥬ :

   SQLFORMS [option option...] [formname] [username/ password]


                                   -- 228 --



         :
   option         ।  ४⥫  ப,  
                   ⨢஢         ᥠ     SQL*Forms
                  (८ࠧ).

                   SQL*Forms (८ࠧ) 室 ᯮ짮
                  ᫥騥   ४⥫   ப: -c, -e, -i, -l,
                  r-, s-  -w-४⥫.

   formname       ।  ,    ८ࠧ 
                  ᮧ.

   username/      ।   짮⥫  ORACLE
   password        ஫.

   ᫨    ।   짮⥫  ஫  ⥬
   ,    SQL*Forms    ᯮ    ⮬᪮ 室 OPS$ ID.
   ᫨ SQL*Forms    OPS$ ID,   ᮮ饭  訡.

      CONVERT ?    樮 ⥬, ⮡ 
   .

   :       ४⥫  ப, SQL*Forms (८ࠧ)


SQL*Forms (஢)

  SQL*Forms (஢) ᮧ FRM 䠩.  ⠪   ᮧ  
  ஢  INP  䠩,   ᨬ    ⮣,      
  㦥   ।塞  樨  ப:

    ᮧ FRM 䠩  ᯮᮡ:

     -       ப,  ᯮ   GENERATE, । 
       INP 䠩,    ८ࠧ (  ᮧ  ࠭,
       ᪮     ).  ਬ, ⮡  ᮧ FRM 䠩 
       䠩  SAMPLE.INP, 室  ᫥ :

       GENERATE SAMPLE1 [username/password]

     -  SQL*Forms  (஥஢), ࠢ   GENERATE   Action 
       । INP 䠩      Generate Form.    INP 䠩
         䠩,  ண   ஢ ஢ 
       䠩,    ᮧ, ᫨    .

  :       ଠ  


        GENERATE 뢠 SQL*Forms (஢) 
-       ப.  ⮡  ᯮ짮    ,
         室     ᫥騩      ⥬ :

              GENERATE [option option...] inp_filename [username/ password]

          :
   option         ।  ४⥫  ப,  
                   ⨢஢         ᥠ     SQL*Forms


                                   -- 229 --



                  (८ࠧ).   SQL*Forms (஥஢) 室
                  ᯮ짮    ᫥騥   ४⥫   ப:
                  -b,  -n,  -o,  -s   -t-४⥫.

   inp_filename   ।   INP 䠩,    ᮧ 
                  ८ࠧ  c䨪 .INP.
   username/      ।   짮⥫  ORACLE
   password         ஫.   ,          । 
                  짮⥫   ஫   ப.

         CONVERT ?     樮 ⥬, ⮡
    .

   :       ४⥫  ப, SQL*Forms (஢)


SQL*Forms ( ଠ)

  SQL*Forms ( ଠ) 뢠 FRM 䠩  믮
  .    ਬ  ஢ન  
  ஢,   ᯮ㥬    믮  ਪ
  ணࠬ.

    믮   ᯮᮡ:

     -     ப,  ᯮ   RUNFORM, ।  
       ,      믮. ਬ,  ⮡  믮 
       SAMPLE.4  室   ᫥ :

       RUNFORM SAMPLE4 [username/password]

     -  SQL*Forms  (஥஢), ࠢ   EXECUTE   Action 
       ।  ,    믮   
       Execute Form.

  :       ଠ  

         RUNFORM  뢠  SQL*Forms ( ଠ)
RUNFORM         ப. ⮡  ᯮ짮    ,
         室     ᫥騩      ⥬ :

              RUNFORM [option option...] inp_filename [username/ password]

              :

   option         ।  ४⥫  ப,  
                   ⨢஢         ᥠ     SQL*Forms
                  (८ࠧ).
                  室     ᯮ짮    ᫥騥 ४⥫
                    ப: -a,-b, -c, -d, -e, -i, -l, -m, -n, -o,
                  -q, -r, -s, -t,  -w-४⥫.

   formname       ।      ,      믮.

   username/      ।   짮⥫  ORACLE
   password        ஫.



                                   -- 230 --



   ᫨    ।   짮⥫  ஫  ⥬ ,
   SQL*Forms  ᯮ  ⮬᪮ 室 OPS$ ID.  ᫨ SQL*Forms 
     OPS$ ID,   ।   짮⥫  ஫.

         RUNFORM ?      樮 ⥬, ⮡
    .
   :       ४⥫  ப, SQL*Forms (஢)

   ४⥫ ப

  ४⥫    ப -  樨,   ᯮ  
  믮  SQL*Forms  ᥠ    ப.   ४⥫
  ᯮ ᫥騩 ᨭ⠪:

  -switch_designator argument

  :

  -switch_designator   ।,  ४⥫ 室
                       ᯮ짮.  ,   ४⥫ 
                       㭨쭮 祭.

  argument             । ॡ㥬 㬥  ⭮
                       ४⥫.   ४⥫  㬥.


-      設⢮  ४⥫      ᯮ짮
஢        樨    㣨  ४⥫ﬨ.  
४-      樨 ⨬   맢 訡.
⥫
     ⮡ ᯮ짮 ᪮쪮 ४⥫ ६,
ப        室 ।    浪. ᫨  
              ᯮ짮  ६ ᪮쪮 ४⥫,  ॡ-
               । 㬥⮢,   ᨭ⠪᪨ -
               ४⥫, ᯮ  "-" । 樥  
              ⠢ ஡  祭ﬨ ४⥫.
              ਬ,  -t   -o-४⥫  룫拉
              ᫥騬 ࠧ:  -to.

४⥫  SQL*Forms (८ࠧ)

    ।⠢ ᯨ᮪  ४⥫  ப    SQL*Forms
   (८ࠧ)    ⪮  ᠭ 祭   ४⥫.
     ᠭ     ᫥ ࠭.

   ४⥫      ᠭ
   
   -                 ॢ ᪨ ਧ.
   -d                      .
   -i                 ८ࠧ INP 䠩.
   -s                   ணࠬ.
   -v                   INP 䠩  ଠ ᨨ 3.0.

   :   CONVERT

-c ४-   ४⥫  -c   ॢ   ᪨   ਧ,
⥫     ।  INP 䠩 (ᮧ ਮ  ᨨ
SQL*Forms     2.3  ᨨ SQL*Forms)  ᨬ  FRM 䠩, 

                                   -- 231 --



(८-       ⮡ࠦ 楫 ன⢮.
)
                ᨨ  3.0  SQL*Forms       㯮ॡ -
              ४⥫ ⨢ ⮫쪮  -v ४⥫  ६
              ८ࠧ INP 䠩.

              ⠪:   -c crt

               crt -     䠩 ।  CRT,  
              ᮡࠥ ᯮ짮   ᥠ SQL*Forms.

              砭:  Oracle*Terminal   ६頥  CRT  ⨫
               ᨨ 3.0 SQL*Forms.

-d ४-   ४⥫ -d  㤠  ।    
⥫      .     ᯮ  -d  ४⥫,
SQL*Forms     SQL*Forms   ⠫ ४⥫.
(८-
)      ⠪:   -d

-i ४-   ४⥫   -i    ।,         SQL*Forms
⥫     (८ࠧ)  ८ࠧ  INP  䠩   ଠ 
SQL*Forms     . ᫨     ᯮ  -i  ४⥫, 
(८-     SQL*Forms  (८ࠧ)    㬮砭  ८ࠧ
)        INP 䠩  ଠ  .

              ⠪:   -i

-s ४-   ४⥫  -s         ணࠬ
⥫      ᮮ饭  Reading...   Writing...
SQL*Forms
(८-     ⠪:   -s
)

-v ४-   ४⥫ -v  ᮧ INP 䠩  ଠ ᨨ 3.0
⥫      INP 䠩 ண ଠ.
SQL*Forms
(८-     ⠪:   -v {version_number} inp_file_name
)
              :
    version_number     ।   ᨨ  INP 䠩,   
                         ८ࠧ.  ᫨    ८ࠧ뢠 INP
                       䠩, ᮧ         SQL*Forms ᨨ  2.3,
                             室 ।  23  
                       version_number.  ᫨   ८ࠧ뢠  INP 䠩,
                       ᮧ  ।饩 (⭮⥫쭮 ᨨ 2.3)
                       ᨨ, । 20.

                       砭:   -v  ஬ ᨨ  ஡
                       (ਬ, -v23).

    inp_file_name      ।  INP 䠩,   
                       ८ࠧ      ଠ ᨨ 3.0.

    砭:  ᯮ  -s  ४⥫  ⨢  -v
    ४⥫,      ८ࠧ INP 䠩, ᮧ     ᨨ
    2.3    ᮤঠ騩  ᪨ ਧ.


                                   -- 232 --



    :  ଠ INP 䠩

४⥫  SQL*Forms (஥஢)

   ।⠢ ᯨ᮪  ४⥫  ப    SQL*Forms
  (८ࠧ)    ⪮  ᠭ 祭   ४⥫.

  ४⥫      ᠭ
  
  -                 ।  .
  -e                  祢 䠩 業.
  -i                 頥 室   ନ.
  -l                 ࠭稢  .
  -n                 室   室   ࠭  (..   室).
  -r                 C뢠 祢 業਩ 䠩.
  -s                   ப.
  -w                 頥 室  ⮫쪮  䠩.


  :    SQLFORMS


-c ફ-    ४⥫ -c । ⮡ࠦ (, 祬 
⥫     ।    㬮砭)    ⥪饣  ன⢠ 
SQL*Forms     த.
(஥-
஢)      ⠪:   - mapping

               mapping -     ⮡ࠦ, ஥  
              ᯮ짮   ᥠ SQL*Forms.
                DBA  । ⮡ࠦ   Oracle*Terminal.

              :   Oracle*Terminal


-e ४-   ४⥫  -e  頥    䠩  ⨥  ,
⥫     ⢮  ᥠ SQL*Forms (஥஢).
SQL*Forms
(஥-     祢 䠩 業 砥  ᥡ ⨥ ,
஢)      ⢮      ࠢ    䥩
              ஥஢,  뢠  㭪樨   믮   ,
              ⢮  SQL*Forms (஥஢)

              ⠪:  -e filename

         : filename -  室 䠩  祢 業਩ 䠩.

              :   ।  .


-i ४-   ४⥫   -i  墠뢠 室  ନ  
⥫      ᥠ  SQL*Forms.    ४⥫   ⠪
SQL*Forms     ।,  SQL*Forms ⮡ࠦ 室 ନ
(஥-      ࠭.
஢)
              ⠪:  -e filename

              : filename -  室 䠩  祢 業਩ 䠩.

                                   -- 233 --



              :  ஢ ।  


-l ४-   ४⥫ -l ࠭稢    ࠭
⥫     ⮫쪮    樨  (ᠬ ᫥).  㬮砭
SQL*Forms               ࠭祭.  -l  ફ⥫
(஥-     ᮡ  㤮     ⥬,       ண
஢)      ஢ .

              ᫨    ᯮ짮   ਧ,  ६
              Limit Indo Buffer  ஥⨢  1.

              ⠪:  -l


              :  Limit Undo Bufer

-n ४-       SQL*Forms,   ।   ᨨ  3.0,
⥫     -n  ४⥫   室  室   ࠭  SQL*Forms
SQL*Forms     (஥஢).       ᢮⢮     
(஥-     뢠    SQL*Forms  (஥஢),    室
஢)        .    뢠 SQL*Forms ⠪ ࠧ, 
              :
              -  ஢, ᮧ  ஢ 
              - 믮   ६ ᥠ, ᫨   㯭 
                
              -   ࠭    
              -     ᯮ짮    㭪樨   , ⠪
                 ᮧ   㬮砭  ᯨ᮪ 㯭 

              ᫨  ।   짮⥫/஫, 
              SQL*Forms  .
              ४⥫ -n    ᨨ 3.0 SQL*Forms.
               㭪樮 ⮫쪮  砥 ᮢ⨬ ᭨ .

              ⠪:   -n


-r ४-   ४⥫ -r   뢠 祢 䠩
⥫     業,  室  SQL*Forms (஥஢).
SQL*Forms     祢 䠩 業 稭, 믮  蠥
(஥-     ᥠ SQL*Forms (஥஢).
஢)
              SQL*Forms 믮  ⢨   ࠭  ନ, ᬮ
                ,       뢮    ࠭  
              -w  ४⥫.

    ⠪:   -r filename
                 filename -   室  䠩    祢 䠩 業.

              :  ஢ ।  


-s ४-   ४⥫ -s   ப.
⥫ 
SQL*Forms     ⠪:   -s
(஥஢)


                                   -- 234 --



-w ४-   ४⥫   -w  墠뢠 室  ନ  
⥫      ᥠ  SQL*Forms.    ४⥫   ⠪
SQL*Forms     ।,   SQL*Forms ⮡ࠦ 室 ନ
(஥-      ࠭.
஢)
              ⠪:  -r filename1 -w filename2

          :
              filename1      䠩  祢 䠩 業.

              filename2     室 䠩  ᯫ 䠩 ॣ樨.

              :  ஢ ।     29-1

४⥫  SQL*Forms (஢)

    ।⠢ ᯨ᮪  ४⥫  ப    SQL*Forms
   (८ࠧ)    ⪮  ᠭ 祭   ४⥫.

   ४⥫      ᠭ
   
   -b                    ᮮ饭.

   -n                 室  짮⥫  ஫ (..  室).

   -o                  ᮧ  INP 䠩.   ४⥫
                       ॢ訬  ᨨ 3.0 SQL*Forms.

   -s                   .  ४⥫
                        ॢ訬  ᨨ 3.0 SQL*Forms.
   -t                    ᮮ饭.

   :    GENERATE


-b ४-     ᨨ  3.0  SQL*Forms  -b  ४⥫  
⥫       ᮮ饭 SQL*Forms (஢).
SQL*Forms
(-      ᨨ  SQL*Forms,  ।饩   ᨨ  3.0, -b
)        ४⥫  뢠  " ०"    ᥠ SQL*Forms
              (஢).   ⭮ ० SQL*Forms (८ࠧ)
                 뤠      ।  ।०, ᫨
              ⠫  訡.  㣨 ०   SQL*Forms
              (஢)  뤠  ᮮ饭  訡  ⠭
              믮 権.  ᨨ 3.0      㭪樮쭠
              ᨬ    ॢ襩.

              ⠪:   -b


-n ४-   ४⥫ -n  易⥫ । 
⥫     짮⥫    ஫.    ᢮⢮    
SQL*Forms     뢠 c SQL*Forms (஢),  室  
(-    .   뢠 SQL*Forms ⠪ ࠧ, 
)         ஢    ,  ᮧ   ᨨ
              SQL*Forms, ।饩 ᨨ 3.0.   ⠪
              ஢    ,  ᮧ    ᨨ  3.0
              SQL*Forms,    ᮤঠ饩       ᫥ 㭪⮢:

                                   -- 235 --



                    - V ਣ, ᮤঠ騥 ஢ SQL
                    - cc뫪  ꥪ ᫥⥫쭮 㬥樨
                    - , , ਣ  楤 ଠ-஢,
                         뫪
                    -       祭묨   ࠪ⨪ Column Set

              ᫨  ।   짮⥫/஫, 
              SQL*Forms  .

              ⠪:  -n


-o ४-         SQL*Forms,  ।  ᨨ   3.0,
⥫     ४⥫ -o   SQL*Forms ᮧ 
SQL*Forms     INP 䠩  ,   ᮧ FRM 䠩.
(-
)        ४⥫ -o    ᨨ 3.0 SQL*Forms.  
              㭪樮 ⮫쪮  砥 ᮢ⨬ ᭨ .

              ⠪:  -o


-s ४-         SQL*Forms,   ।  ᨨ   3.0,
⥫     ४⥫ -s     
SQL*Forms     INP 䠩, 뢠  ⮫쪮 ⢥.      
(-    㭪樮쭮  INP  䠩.  ,    ⢥
)        㬥蠥 ࠧ 䠩,    , ᫨ 
              ࠭ᯮ 䠩   樮 ⥬.

              ४⥫ -s    ᨨ 3.0 SQL*Forms.  
              㭪樮 ⮫쪮  砥 ᮢ⨬ ᭨ .

              ⠪:  -s


-t ४-     ᨨ  3.0  SQL*Forms  -t  ४⥫  
⥫       ᮮ饭 SQL*Forms (஢).
SQL*Forms           SQL*Forms,   ।  ᨨ   3.0,
(-    ४⥫ -t    SQL*Forms ⮡ࠧ 
)        ࠭  ,    ண INP 䠩  ᮧ.  
              ᨨ 3.0  㭪樮쭠 ᨬ  ॢ襩.

              ⠪:  -t


४⥫  SQL*Forms ( ଠ)

               ।⠢ ᯨ᮪  ४⥫  ப 
              SQL*Forms  (८ࠧ)    ⪮  ᠭ 祭
               ४⥫.

              ४⥫      ᠭ
              
              -a                  믮 ᨢ.
              -b                 ⠭    .
              -c                 ।  .
              -d                 ⨢ ० ⫠.
              -e                  祢 䠩 業.

                                   -- 236 --



              -i                 墠뢠 室 ନ.
              -l                  ⮬᪨ 室.
              -m                 ⮡ࠦ    室.
              -o                 ꥤ   SQL ਣ V2.
              -q                 ⨢  (quiet) ०.
              -r                 C뢠 祢 䠩 業  .
              -s                 ⮡ࠦ  ⠭   
                                 ࠧ஢뢠     ।⢠ ஢.
              -t                 ꥤ    SQL.
              -w                 墠뢠 室 ନ ⮫쪮  䠩.

              :   RUNFORM

-a ४-   ४⥫ -a  믮 ᨢ  ६
⥫     c SQL*Forms ( ଠ).   
SQL*Forms     믮  ᨢ,  SQL*Forms  롨ࠥ   
(       ⢥  .
ଠ)
                믮  ᨢ 筮 ਢ  ⮬, 
              ࢠ  ࠭  ⮡ࠦ ॥, 祬 ᫨ 
              롥          믮 ᨢ.  
              饥  ६, 稢  롮   ⮡ࠦ  ᥩ
                믮 ᨢ - 㤥 .

              ᫨  ᪠     SQL*Forms  ( ଠ) 
              ᯮ짮       ᢮⢮,   ⨢ 믮
              樨  Disable  Array  Processing.

              ⠪:  -a
              :  믮 樨 Disable Array Processing 26-3


-b ४-   ४⥫ -b ⠭  ᨬ쭮  ⢮
⥫     ஢  ᥩ    : ᫮  ⮡ࠦ
SQL*Forms     冷   ⠭ (  ). 
(      ⠭  ࠢ    筮  ⮣  ࠢ  3,  
ଠ)           ᯮ㥬  樮 ⥬. ᫨ 
              롨ࠥ  襥 ᫮  ᥩ    ,  SQL*Forms
                   ⥫     ६ (ࠡ祬)
              䠩 ᪠.

              ᫨  ᪠    SQL*Forms  (஥஢) 
                ᯮ짮    ᢮⢮, ⨢ 믮
              樨 Buffer Record.

              ⠪:  -b

              :   믮 樨 Buffer Record       26-2
                         ࠪ⨪  Buffered Records 11-15

- ४-   ४⥫  -c  ।  ⮡ࠦ  ⫨ 
⥫     ࠦ     㬮砭    ⥪饣  ன⢠ 
SQL*Forms     த ࠧ.
(
ଠ)        ⠪:  - mapping
              
              mapping -   ⮡ࠦ, ஥   ᯮ짮-
                           ᥠ SQL*Forms.

                                   -- 237 --



              砭:    DBA  । ⮡ࠦ
                            Oracle*Terminal.

              :  Oracle*Terminal


-d ४-   ४⥫ -d  ⨢ ० ⫠  ᥠ
⥫     SQL*Forms ( ଠ).  ० ⫠ ⮡ࠦ
SQL*Forms     ⥪騥  ᮮ饭    믮  ਣ    㣨
(      ﭨ ⥪饩   ६ 믮  樨.
ଠ)         ⫠ ⨢ 믮 뢠, ᫨   
                 ਣ஢    楤 BREAK.

              ᫨  ᪠   SQL*Forms  (஥஢)   
                ᯮ짮  ᢮⢮,      ⨢஢
              믮 樨 Debug Mode.

              C⠪:  -d
              :  C।⢠ ⫠
                        믮 樨 Debug Mode

-e ४-   ४⥫ -e 墠뢠  祢 䠩 業
⥫     ⨥ , ࠡ  ६  ᥠ  SQL*Forms
SQL*Forms     ( ଠ). 祢 䠩 業 砥  ᥡ
(      ⨥ , ⢮    ࠢ  
ଠ)        , ⨢ 㭪樨  믮 ࠭樨.

              ⠪:  -e filename

           filename -   室 䠩  祢 䠩 業.
              :  ஢ ।  


-i ४-   ४⥫   -i  墠뢠 室  ନ  
⥫      ᥠ  SQL*Forms.    ४⥫   ⠪
SQL*Forms     ।,  SQL*Forms ⮡ࠦ 室 ନ
(       ࠭.
ଠ)
              ⠪:  -e filename

              : filename -  室 䠩  祢 業਩ 䠩.

              :  ஢ ।  


-l ४-   ४⥫ -l   ⮬᪨ 室 ORACLE
⥫        ⮡ࠦ    室  ࠭.   
SQL*Forms      ४⥫ -l,   㦭 ।
(       짮⥫  ஫.
ଠ)
              ᯮ -l ४⥫, :
            -      SQL*Forms c , ⫨  ,
              ⠭ OPS$ ID
  
            -       । ஫     ப

              ⠪:  -l


                                   -- 238 --



              :  ⮬᪨ 室

-m ४-   ४⥫ -m ⠢ SQL*Forms 뤠  
⥫       ࠭  (᫥ ࠭ 室),   ⮣, ⮡
SQL*Forms     뤠  ࠭  .  ᯮ  ᢮⢮ 
(        ਪ  ணࠬ,    ᪮쪮
ଠ)        ⮢ 祪.

              ᫨  ᪠     SQL*Forms  (஥஢) 
                 ᯮ짮    ᢮⢮,  ⨢ 믮
              樨 Display Block Menu.

              :  믮 樨 Display Block Menu   26-3
                        Block Menu                            11-13

-o ४-    㬮砭 SQL*Forms  ⠭  ⤥ 
⥫            SQL,   ଠ
SQL*Forms     믫      V2   ਣ.     㭪樮஢
(      蠥 ஢, ᪮    
ଠ)            ஠஢  ⮫쪮  ࢮ
              믮  ᥠ  SQL*Forms ( ଠ),    
              .

         ।  -o  ४⥫,  SQL*Forms ⠭  
         SQL  ஢  ਣ  V2.   
   ᮢ⭮ ᯮ,  ⭮ ᯮ ⠪ , 
   ࠭ ,   ஢, .. SQL  
   ஢   믮.

           ᯮᮡ        ⠪ 㭪樮஢
          ࠪ⨪   蠣 ਣ  New Cursor Area. ᫨ 蠣
   ਣ, ᮤঠ騩    SQL,    祭  ࠪ⨪,
    SQL*Forms   ᢠ   ⤥ ,  ਢ  
   ⮬,   -o  ४⥫  ⢥࣠   .

   ᫨  ᪠   SQL*Forms (஥஢)    ᯮ짮
    ᢮⢮,  믮 樨 Share Cursor for Trigger SQL.

   砭:४⥫ -o  뢠 ﭨ    ਣ V3.

   ⠪:   -o

   :   ,                    22-3
              ࠪ⨪  蠣  ਣ  New  Cursor Area
              Share Cursors  믮 樨 Trigger SQL
              -t  ४⥫    SQL*Forms ( ଠ)


-q ४-   ४⥫ -q ⨢  ०  ᥠ
⥫     SQL*Forms ( ଠ).   ० c饭
SQL*Forms      뤠 㪮 ᨣ. ,   
(      㪮 ᨣ    ਣ    ⭮  楤
ଠ)        BELL.

              ᫨  ᪠     SQL*Forms  (஥஢)
                    ᯮ짮    ᢮⢮,  ⨢
              믮 樨 Quiet Mode.


                                   -- 239 --



              ⠪:  -q
              :   믮 樨 Quiet Mode          26-3


-r ४-   ४⥫ -r   뢠 祢 䠩
⥫     業,  室  SQL*Forms (஥஢).
SQL*Forms     祢 䠩 業 稭, 믮  蠥
(஥-     ᥠ SQL*Forms (஥஢).
஢)
              SQL*Forms 믮  ⢨   ࠭  ନ, ᬮ
                ,       뢮    ࠭  
              -w  ४⥫.

              ⠪:   -r filename

                filename -   室  䠩    祢 䠩 業.

              :  ஢ ।     29-1


-s ४-   ४⥫ -s ⮡ࠦ  ᮮ饭     ᥠ
⥫     SQL*Forms ( ଠ), ⠭饥 ᨬ쭮
SQL*Forms     ⢮ ६  ஢,  뫨
(      ᯮ짮    ६  ᥠ.  SQL*Forms    
ଠ)        ᮮ饭  ࠭ ନ,    ப ᮮ饭.

              ४⥫ -s ⠪ 뤠 ᫥    :

              ALTER SESSION SET SQL_TRACE TRUE

                ࠧ஢뢠  ।⢠  ஢  ⥪饣
              ᥠ  SQL*Forms  ( ଠ). ᫨   㦭 ⥫-
               ଠ      ।⢠,    ORACLE RDBNS
              Performance Tuning Guide.
              ⠪:  -s

              :  믮 樨 Statistics.


-t ४-    㬮砭 SQL*Forms  ⠭  ⤥ 
⥫            SQL,   ଠ
SQL*Forms     믫 ,  ।   . 
(      㭪樮஢  蠥  ஢,  ᪮
ଠ)              ஠஢
              ⮫쪮  ࢮ 믮 ᥠ  SQL*Forms (
              ଠ),        믮.

                    ।  -t  ४⥫,  SQL*Forms ⮫쪮
              ⠭  ⤥        
               SELECT.    ᮢ⭮ ᯮ,  
              ⭮ ᯮ ⠪ ,  ࠭ , 
               ஢, ..    INSERT,  UPDATE,
              DELETE  SELECT FOR UPDATE  ஢  
              믮.

              ᫨  ᪠     SQL*Forms  (஥஢) 
               ᯮ짮  ᢮⢮,   믮 Share
              Cursor  믮  樨 SQL.

                                   -- 240 --



              砭:  ४⥫  -t    뢠    ﭨ,
              ᫨   ⠭⭮ ஢ SQL*Forms 
              On-Insert, On-Update, On-Delete ਣ, ᪮  ਣ
                뤠 ஢  INSERT, UPDATE  DELETE.

              ⠪:  -t

              :   ,                    22-3
                         Share Cursors  믮 樨 Trigger SQL
                         -o  ४⥫    SQL*Forms ( ଠ)


-w ४-   ४⥫   -w  墠뢠 室  ନ  
⥫      ᥠ  SQL*Forms.    ४⥫   ⠪
SQL*Forms     ।,  SQL*Forms ⮡ࠦ 室 ନ
(஥-      ࠭.
஢)
              ⠪:  -r filename1 -w filename2
              :
              filename1       䠩  祢 䠩 業.

              filename2      室 䠩  ᯫ 䠩 p樨.

              :  ஢ ।     29-1
         24                             

      ।⠢ ଠ  ⮬,  SQL*Forms 
   .   祭 ᫥騥 ⥬:
      - ଠ  
      - 쭮  ⥬
      -  ⠡ SQL*Forms (஥஢)
      - ଠ INP 䠩

 ଠ  

  SQL*Forms     ଠ:
     - ଠ  
     - FRM ଠ
     - INP ଠ

      ८ࠧ뢠        ଠ  㣮  
  ࠧ ⮢ SQL*Forms.
  :  

ଠ  
   ଠ  ଠ   ⮨  । , 饭 
       ࠧ  ⠡       ORACLE.   ଠ
      ଠ⮬    .  SQL*Forms ᮧ
   ।⠢     ,      믮   
   ᫥ ⢨:

      - ࠭ ।   SQL*Forms (஥஢)
        ।⢮  樨  Save    Action.

      - ८ࠧ INP 䠩   ப ।⢮  CONVERT
         -i ४⥫  ப



                                   -- 241 --



   SQL*Forms ᯮ ।⠢   ଠ  ,  
   뢠 ,   CONVERT  -d ४⥫ 
   ப.

   砭:   SQL*Forms, । ᨨ 1.0,  
                 ,  ᯮ INP ଠ  ⢥ .

   :    CONVERT                      23-4
              -d ४⥫, SQL*Forms (८ࠧ)
              -i ४⥫, SQL*Forms (८ࠧ)


FRM ଠ
   ଠ    FRM  ଠ  ⮨    ।  , 饭 
       筮 䠩. SQL*Forms ᮧ FRM 䠩  , 
        SQL*Forms (஥஢) ।⢮ 樨
   Generate   Action    ப, ᯮ  GENERATE.
   SQL*Forms ᯮ FRM 䠩,   믮 .

   砭:  ଠ FRM 䠩   ७ᨬ  ⥬.

   :    GENERATE                     23-6


 ⠡ SQL*Forms (஥஢)

     ⮬  ࠧ  ।⠢  ⠡    , ᯮ짮 
   ᨨ 3.0 SQL*Forms (஥஢), ࠭騥   ᮧ 
   㥬  ଥ.  ⠡ 室   
   짮⥫ SYSTEM.
        - FORM_APP
        - FORM_BLK
        - FORM_COMMENT
        - FORM_FLD
        - FORM_MAP
        - FORM_PAGE
        - FORM_PROCEDURE
        - FORM_SQLTXT
        - FORM_TRG
        - FORM_TRIGGER
        - FORM_USER
   ଠ      ᠭ  ⠡.   뢠
   ᮮ饭, ᭮  ⮩ ଠ樨   ᮤঠ  ⠡  
     SQL*Forms.   ஢  権  ⨬ ⠡栬
   ।⢮ SQL*Plus.

   砭:  ௮ Oracle  ࠭  ᮡ ࠢ   
                    ⠡    ६  ।०.


        FORM_APP ᮤন  ଠ    䨪樨
FORM_APP      .   ᫥饩  ⠡  ।⠢  ଠ 
              ⮫ ⠡.

              ⮫       ᠭ                    
              
              APPOWNER             NOT NULL    CHAR(30)


                                   -- 242 --



              APPNAMER                  NOT NULL    CHAR(30)

              APPTITLE                        CHAR(80)

              APPVAUNIT     ஢筮                     CHAR(6)
                            ன⢮
              APPMOUSE      । ࠢ               CHAR(6)
                            
              APPMNUAPL     ਪ ணࠬ            CHAR(30)
                              㬮砭

              APPMNUNAM                       CHAR(30)

              APPMNUGRP                      CHAR(30)
                            㯯

        FORM_BLK ᮤন  ଠ    䨪樨
FORM_BLK       ࠪ⨪ .  ᫥饩 ⠡ ।⠢
              ଠ  ⮫ ⠡.

              ⮫       ᠭ                      
              
              BLKAPOWNER             NOT NULL    CHAR(30)
              BLKAPNAME                   NOT NULL    CHAR(30)
              BLKNAME                     NOT NULL    CHAR(30)
              BLKDESC       ᠭ                   CHAR(60)
              BLKHD         ᫨ ᠭ                   CHAR(1)
                               
              BLKSEQ        ᫥⥫                NAMBER
                             
              BLKUNQKEY     ᫨ 㭨                 CHAR(1)
                             室  
              BLKCTRL       ᫨                   CHAR(1)
                             ⠡
              BLKCOLSEC     ᫨ 室                 CHAR(1)
                            ࠭祭 楫⭮  
              BLKTOWNER      ⠡                CHAR(30)
              BLKTNAME       ⠡                     CHAR(30)
              BLKNOREC      ᫮ ⮡ࠦ              NUMBER
                            ப
              BLKNOBUF      ⢮ ਧ㥬         NUMBER
                            ᥩ
              BLKBLIN        ப                  NUMBER
              BLKLNRC       ᫮ ப              NUMBER
              BLKRSIZ       ࠧ ᨢ          NAMBER
              BLKOBYSQL     㪠⥫ ⠡               NUMBER
                            FORM_SQLTXT
                            (SQLTNO ⮫) 
                              㬮砭
                            WHERE/ORDER BY ࠧ  


        FORM_COMMENT ᮤন ਩  ⥪.

              ⮫       ᠭ                      
              
              CMTAPOWNER             NOT NULL    CHAR(30)
              MTAPNAME                   NOT NULL    CHAR(30)

                                   -- 243 --



              CMTPROC        楤                   CHAR(30)
              CMTBLK                                    CHAR(30)
              MTFLD                                    CHAR(30)
              MTTRGTYP     ਣ                         CHAR(30)
              CMTTRGSEQ     蠣 ਣ                    NUMBER
              MTLINE        ப                    NUMBER
              MTTEXT       ਩ ⥪              CHAR(80)

        FORM_FLD ᮤন  ଠ   䨪樨
FORM_FLD       ࠪ⨪ .  ᫥饩 ⠡ ।⠢
              ଠ  ⮫ ⠡.

              ⮫       ᠭ                      
              
              FLDAPOWNER             NOT NULL    CHAR(30)
              FLDAPNAME                   NOT NULL    CHAR(30)
              FLDBLK        , 騩      NOT NULL    CHAR(30)
                            楬 
              FLDNAME                      NOT NULL    CHAR(30)
              FLDSEQ                                   NUMBER
                            ᫥⥫쭮
              FLDTYPE       ⨯                       CHAR(8)
              FLDLEN                               NUMBER
              FLDDLEN        ⮡ࠦ              NUMBER
              FLDQLEN                           NUMBER
              FLDBTAB       ᫨                CHAR(1)
                              ⠡
              FLDKEY        ᫨                HAR(1)
                             ࢨ筮 
              FLDCKBLK      ,  ண        CHAR(30)
                            祭 
              FLDCKFLD      ,  ண        CHAR(30)
                            祭 

              FLDDFLT       稭  㬮砭             CHAR(80)
              FLDDISP       ᫨  ⮡ࠦ            CHAR(1)
              FLDPAGE       ᯮ ࠭              NUMBER
              FLDLINE       ᯮ ப                NUMBER
              FLDCOL        ᯮ ப                NUMBER
              FLDPROMPT     ।                       CHAR(80)
              FLDPRABOV     ᫨ ।               CHAR(1)
                            
              FLDPRRPT      ᫨ ।                CHAR(1)
                            
              FLDENTER      ᫨               CHAR(1)
              FLDQUERY      ᫨   訢       CHAR(1)
              FLDUPDATE     ᫨             CHAR(1)
              FLDUPDNUL     ᫨             CHAR(1)
                             NULL
              FLDMAND       ᫨  易⥫쭮             CHAR(1)
              FLDFIXED      ᫨   䨪஢     CHAR(1)
                            
              FLDSKIP       ᫨   ⮬᪨    CHAR(1)
                            ய
              FLDHIDE       ᫨                  CHAR(1)
              FLDAUTOHLP    ᫨   ⮬    CHAR(1)
                            ᪠
              FLDUPPER      ᫨  ८ࠧ ᨬ     CHAR(1)

                                   -- 244 --



                             
              FLDOVTIT        ᯨ᪠ 祭      CHAR(60)
              FLDLOVSQL     㪠  ⠡ FORM_SQLTXT    NUMBER
                              ᯨ᪠ 祭
                             SQL
              FLDLOVX       X न  ᯨ᪠ 祭   NUMBER
              FLDLOVY       Y न  ᯨ᪠ 祭   NUMBER
              FLDLOW        襥 祭                   CHAR(30)
              FLDHI         襥 祭                   CHAR(30)
              FLDVALPATN    ஢ ࠧ                CHAR(80)
              FLDDISMASK    ᪠ ᯫ                     CHAR(80)
              FLDHELP       ⥪ ᪠                   CHAR(80)
              FLDEDTX       X न  ।        NUMBER
                            䠩
              FLDEDTY       Y न  ।        NUMBER
                            䠩
              FLDEDITWRP    室 ᫮  ।       CHAR(1)
                            䠩

        FORM_MAP ᮤন ଠ  ﭭ ⥪
FORM_MAP        䨪.  ᫥饩 ⠡ ।⠢  ଠ
               ⮫ ⠡.

              ⮫       ᠭ                      
              
              MAPAPOWNER             NOT NULL    CHAR(30)
              MAPAPNAME                   NOT NULL    CHAR(30)
              MAPPAGE       ࠭              NOT NULL    NUMBER
              MAPLINE       ப                            NUMBER
              MAPGRPH       ᫨ 祭                CHAR(1)
                             ஢  ᪨ 
              MAPTEXT       ﭭ ⥪                  CHAR(255)


        FORM_PAGE ᮤন  ଠ  c࠭  
FORM_PAGE     ࠪ⨪.     ᫥饩   ⠡   ।⠢
              ଠ  ⮫ ⠡.

              ⮫       ᠭ                      
              
              PAGEAPOWNER            NOT NULL    CHAR(30)
              PAGEAPNAME                  NOT NULL    CHAR(30)
              PAGNUM         ࠭        NOT NULL    NUMBER
              PAGTITLE       ࠭                 CHAR(255)
              PAGXSIZ       ਭ ࠭                   NUMBER
              PAGYSIZ        ࠭                   NUMBER
              PAGVWXS       ਭ ।⠢              NUMBER
              PAGVWYS        ।⠢              NUMBER
              PAGVWPXO      X न             NUMBER
                             ࠭
              PAGVWPYO      Y न             NUMBER
                             ࠭
              PAGGROPUP     ᫨ ࠭             CHAR(1)
                            孥 ࠭楩
              PAGBORDER     ᫨ ।⠢           CHAR(1)
                            ࠭
              PAGDISLV      ᫨ ࠭ 㫨        CHAR(1)


                                   -- 245 --



                             室
              PAGVSCRL      ᫨ ।⠢           CHAR(1)
                             ⨪쭮 ப⪨


         FORM_PROCEDURE  ᮤন  ଠ   PL/SQL
FORM_PROCE-   楤.  ᫥饩  ⠡ ।⠢ ଠ
DURE           ⮫ ⠡.

              ⮫       ᠭ                      
              
              PROCAPOWNER            NOT NULL    CHAR(30)
              PROCAPNAME                  NOT NULL    CHAR(30)
              PROCNAME       楤         NOT NULL    CHAR(30)
              PROCTEXT      㪠⥫ ⠡                 NUMBER
                            FORM_SQLTXT
                            (SQLTNO ⮫)   ⥪ 楤

         FORM_REFERENCE  ᮤন  ଠ  
FORM_REFE-    c뫪      ꥪ  SQL*Forms.  ᫥饩  ⠡
RENCE         ।⠢  ଠ    ⮫  ⠡.

              ⮫       ᠭ                      
              
              REFAPOWNER             NOT NULL    CHAR(30)
              REFAPNAME                   NOT NULL    CHAR(30)
              REFBLK        ,                   CHAR(30)
                             뫪
              REFFLD        , ஥                  CHAR(30)
                             뫪
              REFTGTYP      ਣ,                CHAR(30)
                             뫪
              REFPROC       楤,              CHAR(30)
                             뫪
              REFFOWNER      ꥪ,     NOT NULL    CHAR(30)
                               뫪
              REFFAPP        ,        NOT NULL    CHAR(30)
                            ᮤঠ饩 ꥪ,    뫪

              REFFBLK       ,                    CHAR(30)
                             뫪
              REFFFLD       ,  ஥                  CHAR(30)
                             뫪
              REFFTGTYP     ਣ,                 CHAR(30)
                             뫪
              REFFPROC      楤,               CHAR(30)
                             뫪

        FORM_SQLTXT ᮤন ⥪  ஢ SQL
FORM_SQLTXT   cঠ   ଠ,  ࠧ WHERE/ORDER
              BY.    ᫥饩  ⠡  ।⠢  ଠ 
              ⮫  ⠡.

              ⮫       ᠭ                      
              
              SQTAPOWNER             NOT NULL    CHAR(30)
              SQTAPNAME                   NOT NULL    CHAR(30)
              SQTNO         䨪樮     NOT NULL    NUMBER

                                   -- 246 --



                              ⥪ SQL
              SQTLINE       ப ⥪         NOT NULL    NUMBER
              SQTTEXT       SQL ⥪                         CHAR(80)


        FORM_TRG  ᮤন  ଠ  ᯮ 
FORM_TRG      ࠪ⨪  蠣  ਣ.   ᫥饩  ⠡
              ।⠢  ଠ    ⮫  ⠡.

              ⮫       ᠭ                      
              
              TRGEAPOWNER            NOT NULL    CHAR(30)
              TRGEAPNAME                  NOT NULL    CHAR(30)
              TRGBLK        ,                     CHAR(30)
                            樨஢ ਣ
              TRGFLD        ,                     CHAR(30)
                            樨஢ ਣ
              TRGTYPE       ⨯ ਣ          NOT NULL    CHAR(30)
              TRGSEQ         ᫥⥫쭮          NUMBER
              TRGLABEL      ⪠ 蠣 ਣ               CHAR(30)
              TRGSQL         SQL ⥪, 蠣             NUMBER
                            易 ( ᠭ  ⠡ FORM_SQLTXT)

              TRGCURS       ᫨ 蠣 ਣ            HAR(1)
                            ⤥ 
              TRGMVE        ᫨ ਣ 㤥           CHAR(1)
                            ਩ 襭  믮 蠣

              TRGINV        ᫨   蠣            CHAR(1)
                            ਣ 㤥 
              TRGROLL       ᫨ ਣ 㤥                CHAR(1)
                            ᯥ稢   ਩ 襭
                            ਣ
              TRGLAB        ?????????                          CHAR(30)
              TRGFLAB        ⪠ ᡮ                        HAR(30)
              TRGMSG         ப ᮮ饭  ᡮ           CHAR(80)


        FORM_TRIGGER ᮤন ଠ  ᯮ
FORM_TRGGER    ࠪ⨪  蠣  ਣ.  ᫥饩  ⠡
              ।⠢  ଠ    ⮫  ⠡.

              ⮫       ᠭ                      
              
              TRIGEAPOWNER            NOT NULL    CHAR(30)
              TRIGEAPNAME                  NOT NULL    CHAR(30)
              TRIGBLK                                      CHAR(30)
              TRIGFLD                                      CHAR(30)
              TRIGTYPE       ⨯ ਣ          NOT NULL    CHAR(30)
              TRIGDESC       ᠭ                          CHAR(20)
              TRIGHIDE       ᫨ ᠭ 㤥               CHAR(1)
                             祭  ࠭ Show Keys (⮫쪮 祢
                             ਣ஢)
             TRIGPLSQL       ᫨ ਣ              CHAR(1)
                             V3 ਣ஬




                                   -- 247 --



        FORM_USER  ᮤন  ଠ    ਢ
FORM_USER     짮⥫.      ᫥饩    ⠡   ।⠢
              ଠ    ⮫  ⠡.

              ⮫       ᠭ                      
              
              USRAPOWNER             NOT NULL    CHAR(30)
              USRAPNAME                   NOT NULL    CHAR(30)
              USRUSER       ࠧ襭            NOT NULL    CHAR(30)


ଠ INP 䠩
****************
   ᠭ ᨭ⠪ INP 䠩   ᫥ ࠭. 
  ਠ  ⠫ ଠ樥.     ,
  । INP 䠩,   ਢ  쥧 ० 
  ਪ ணࠬ.

  砭:  ஢ INP 䠩  ࠧ襭 Oracle Corporation.

  C  奬  㭪樮      ஢,   孥  
  .   ନ,  騩  㣫     ᪮     (ਬ,
  <form_definition>) ।    ஢ 奬.

  copyright notice
  SQL*Forms_VERSION = forms_version
  <form_definition>

   <form_definition>  ᫥騩 ᨭ⠪:

  DEFINE FORM
       application-level_comments
       NAME = form_name
       TITLE = form_title
       DEFAULT_MENY_APPLICATION = default_meny_application
       ROOT_MENU = starting_menu_name
       GROUP_NAME = menu_security_group_name
       MOUSE_NAVIGATORY_LIMIT = mouse navigation_limit
       VALIDATION_UNIT = {-1nothing-0  FIELD  RECORD 
        BLOCK  FORM )
       for each procedure in form
               <procedure_definition>
       for each form-level trigger in form
               <trigger_definition>
       for each block in form
               <block_definition>
       <screen_definition>
  ENDDEFINE FORM

   <procedure_definition>  ᫥騩 ᨭ⠪:

  <non-referenced_procedure_definition> 
  <referenced_procedure_definition>

   <non-referenced_procedure_definition>  ᫥騩 ᨭ⠪:




                                   -- 248 --



  DEFINE PROCEDURE
         procedure-level_comments
         NAME = procedure_name
         DEFINITION = procedure_text
  ENDDEFINE PROCEDURE

   <referenced_procedure_definition>  ᫥騩 ᨭ⠪:

  DEFINE PROCEDURE
         NAME = procedure_name
         <reference_definition>
  ENDDEFINE PROCEDURE

   <trigger_definition>  ᫥騩 ᨭ⠪:

  <non-referenced_trigger_definition> 
  <referenced_trigger_definition>

   non-referenced_trigger_definition>  ᫥騩 ᨭ⠪:

  DEFINE TRIGGER
         trigger-level_comments
         NAME = trigger_name
         TRIGGER_TYPE = V2
         SHOW_KEY = {ON  OFF}
         DESCRIPTION = trigger_description
         for each step in trigger
               <step_definition>
  ENDDEFINE TRIGGER

   <step_definition>  ᫥騩 ᨭ⠪:

  DEFINE STEP
         step-level_comments
         LABEL = step_label
         TEXT = step_text
         SUCCESS_STEP = success_label
         FAILURE_STEP = failure_label
         FAIL_MESSAGE = failure_message
         ABORT = {ON  OFF}
         REVERSE = {ON  OFF}
         NEW_CURSOR = {ON  OFF}
         IGNORE = {ON  OFF}
  ENDDEFINE

   <V3_style_trigger_definition>  ᫥騩 ᨭ⠪:

  DEFINE TRIGGER
         trigger-level_comments
         NAME = trigger_name
         TRIGGER_TYPE = V3
         SHOW_KEY = {ON  OFF}
         DESCRIPTION =trigger_description
         TEXT = V3_style_trigger_text
  ENDDEFINE TRIGGER

   <referenced_trigger_definition>  ᫥騩 ᨭ⠪:


                                   -- 249 --



  DEFINE TRIGGER
         NAME = trigger_name
         <reference_definition>
  ENDDEFINE TRIGGER

   <block definition>  ᫥騩 ᨭ⠪:

  <non-referenced_block_definition> 
  <referenced_block_definition>

   <non-referenced_block_definition>  ᫥騩 ᨭ⠪:

  DEFINE BLOCK
         block-level_comments
         NAME = block_name
         DESCRIPTION = block_description
         TABLE = user.base_table
         UNIQUE_KEY = {ON  OFF}
         UPDATE_KEY = {ON  OFF}
         IN_MENU = {ON  OFF}
         ROWS_DISPLAYED = num_rows_displayed
         ROWS_BUFFERED  = num_rows_buffered
         BASE_LINE = base_line
         LINES_PER_ROW = num_lines_per_row
         ARRAY_SIZE = array_size
         COLUMN_SECURITY = {ON  OFF}
         ORDERING = default_where_orderby_clause
         for each block-level trigger in block
                 <trigger_definition>
         for each field in block
                 <field_definition>
  ENDDEFINE BLOCK

   <field_description>  ᫥騩 ᨭ⠪:

  <non-referenced_field_definition> 
  <referenced_field_definition>

   <non-referenced_field_definition>  ᫥騩
  ᨭ⠪:

  DEFINE FIELD
         field-level_comments
         NAME = field_name
         DATATYPE = data_type
         LENGTH = field_length
         DISPLAY_LENGTH = display_length
         QUERY_LENGTH = quey_length
         BASE_TABLE = {ON  OFF}
         PRIMARY_KEY = {ON  OFF}
         MANDATORY = {ON  OFF}
         DISPLAYED  =  {ON  OFF}
         PAGE = page_number
         LINE = line_number
         COLUMN = column_number
         HELP = help_message
         LOW_VALUE = field_range_low_value
         HIGH_VALUE = field_range_high_value

                                   -- 250 --



         LOV_TEXT = list_of_values_select_statement 
                  [user}.table.column
         LOV_TITLE = list_of_values_title
         LOV_X = x coord_for_lov
         LOV_Y = y coord_for_lov
         INPUT_MASK = input_mask
         OUTPUT_MASK = output_mask
         EDIT_X = location_x_coordinate
         EDIT_Y = location_y_coordinate
         EDIT_WORD_WRAP = {ON  OFF}
         DEFAULT = default_value
         ENFORCE_KEY_FORM =
         = source_block.field_of_primary key_copy
         ECHO = {ON  OFF}
         INPUT = {ON  OFF}
         UPDATE = {ON  OFF}
         UPDATE_NULL = {ON  OFF}
         QUERY = {ON  OFF}
         FIXED_LENGTH = {ON  OFF}
         AUTOSKIP = {ON  OFF}
         AUTOHELP = {ON  OFF}
         UPPERCASE = {ON  OFF}
         for each field-level trigger in field
                 <trigger_definition>
         ENDDEFINE FIELD

   <page_definition>  ᫥騩 ᨭ⠪:

  DEFINE PAGE
         PAGE = page_number
         POPUP = {ON  OFF}
         BORDER = {ON  OFF}
         HORIZONTAL_SCROLL_BAR = {ON  OFF}
         VERTICAL_SCROLL_BAR = {ON  OFF}
         DISSOLVE = {ON  OFF}
         TITLE = page_title
         PAGE_XS = page_x_size
         PAGE_YS = page_y_size
         PAGE_PXO = x_coord_of_view_on_page
         PAGE_PYO = y_coord_of_view_on_page
         PAGE_PXS = x_size_of_view_on_page
         PAGE_PYS = y_size_of_view_on_page
         PAGE_SXO = x_coord_of_view_on_page
         PAGE_SYO = y_coord_of_view_on_page
         MODE = TEXT
         LINE = line_number_a
         BOILER = <<<
         constant text at line_number
         constant text at line_number + 1
         ...
         >>>
         LINE = line_number_b
         BOILER = <<<
         ...
         >>>
         ...
  ENDDEFINE PAGE


                                   -- 251 --



  砭:  SQL*Forms   ਭ      
              KEYWORD = VALUE    ᫥ ଠ⮢:

  1. KEYWORD = VALUE
  2. KEYWORD =   <<<
                 VALUE
                 >>>

  設⢮   ஢   KEYWORD = VALUE      ଠ 1.
  ᪫祭ﬨ (   ଠ 2)  ,  ।騥
  ᫥騥  :
       - ᯨ᮪ 祭 ⥪
       - । 楤
       - ⥪ ਣ
       - ⥪ 蠣
       - ࠧ WHERE/ORDER BY  㬮砭











































                                   -- 252 --
