


          25
                                               

      ᬠਢ  裡  冷 த⮢   ORACLE
     ਪ  ணࠬ  SQL*Forms.  ।⠢ ᫥騥 ⥬:
        -   ORACLE RDBMS
        -   ਪ묨 ࠧࠡ⪠ ᯮ⥫ ணࠬ
        - ᯮ짮  ࠭権  ORACLE     SQL*Forms
        - ᯮ짮 뢠 
        - ᯮ짮 Oracle*Terminal

  ORACLE RDBMS

   SQL*Forms      ⥣஢    ᨥ  6.0 ORACLE RDBMS.   
         ਪ   ࠬ  SQL*Forms ᭮   ORACLE RDBMS. 
          室  ⠡   ᫮६ .

   SQL*Forms 頥  , 室騬   ,     
         諨.   㬮砭  SQL*Forms  室       襩
         設. ,    易  㤠     
         SQL*Net.

      ᮧ     㬮砭,  ᫮   ᯥ稢
   SQL*Forms 묨,  室묨   ᮧ   .  SQL*Forms
   믮    㬮砭 ᫥騥 ⢨:

       - 뢮     ⮫     ⠡    
         (..,  । ࠪ⨪  Field Name)

       - 뢮     ⮡ࠦ   室  ⨯  
         ORACLE    ਭ  ⮫ (.., । ࠪ⨪ 
         Field Length  Display Length)

       - ॢ  ⨯      ⨯  SQL*Forms
         (ਬ, ᯥ ࠪ⨪   Data  Type)

       - 砥   ,  ᮮ⢥騥   㫥 ⮫栬  
         ,  ॡ㥬  (.., ᢠ  ࠪ⨪ 
         Required)

   ⥫쭮,  SQL*Forms     믮  ᫥騥 ⢨:
   - ।  ⨬   祭       ⠡ 
       ࠭祭 楫⭮  ⮫ (.. 뢠 ਣ
     On-New-Record, On-Validate-Field  On-Validate-Record.
   - ॢ  ࠭祭  楫⭮  뫮   (饥)
     ⭮襭  
   :   室

        C  ᯮ⥫묨 ணࠬ ࠧ

   SQL*Forms  뢠  ᫥騬 ਪ묨 ᯮ⥫묨
ணࠬ:
          - SQL*Menu
          - SQL*Plus
          - SQL*ReportWriter




                                   -- 253 --



          SQL*Menu
--------
      ⨢஢   5.0  SQL*Menu  १ SQL*Forms  
ꥤ        ਪ ணࠬ SQL*Forms. SQL*Forms
  믮 ᫥騥 :

- ।  ᮮ⭮襭    㬮砭   ਪ묨 ணࠬ
  SQL*Forms  ਪ    SQL*Menu
- ,  묨  ६  १  楤
  SQL*Forms - ।        ⭮

   ஡  ଠ樥   ⠭   ࠡ ਪ  ணࠬ
SQL*Menu  頩  SQL*Menu User's Guide and Reference.

        䨪 ଠ樨   y砭
--------
     ᯥ஢ ᮮ⭮襭  㬮砭  ਪ묨
ணࠬ SQL*Forms  ਪ묨 ணࠬ  SQL*Forms  १  
Form  Definition.  騥 ࠪ⨪  । ᮮ⭮襭:

Default Menu         ਪ  ணࠬ
Application        ,  SQL*Forms ⨢  믮  .

Starting Menu      C , ஥ SQL*Forms Name ⮡ࠧ 
                   믮 .

Menu Security      ।    ਢ,  
Group              SQL*Forms  㤥   ᯮ짮   ਪ  ணࠬ
                   ,   । 樨 , ।祭 
                   ⮡ࠦ.

  ६   믮   ,  SQL*Menu   ⨢ ਪ ணࠬ
    㬮砭    ⮡ࠦ     孥   ࠭
(४뢠   ⮡ࠦ ),   㪠뢠    樨,  騥
ࠧ襭묨  ᯥ஢ 㯯 .
:  ࠪ⨪      Default Menu Application
          ࠪ⨪      Menu Security Group
          ࠪ⨪      Starting Menu Name

        ࠢ騥   楤
-------
   SQL*Forms ᯥ笢  믮 ᫥   楤,
  뢠,    ६    SQL*Menu  
ਪ  ணࠬ SQL*Forms.

HIDE_MENU            ⥪饥 .
SHOW_MENU          ⮡ࠦ ⥪饥 .
REPLACE_MENU       ६頥 ⥪饥          ᯮᮡ
                   ⮡ࠦ    㯯   ,   ᯮ㥬 SQL*Forms
                    । 樨 ,  室 ⮡ࠧ.

           楤   ஫஢ ⮡ࠦ
  ६ ᥠ SQL*Forms ( ଠ) १ ਣ  ।
஫ ࠬ १ । 㭪樮 .

ਬ  C騩 祢  ਣ  믮      ODERES 
         ⥬ ᪠  DETAIL:


                                   -- 254 --



         EXECUTE_QUERY;
         REPLACE_MENU ('DETAIL');
         GO_BLOCK ('ORDERS');
            ਣ   ᪠     DETAIL,     ⮡ࠦ
         権 㤥 ⠪: "Show Associated Item Records".   
         ᯥ  ᫥騩  ⥪ ਣ:

         GO_BLOCK ('ITEMS);
         EXECUTE_QUERY;
         ᫨  롨ࠥ "Show Associated Item Records", SQL*Menu
         ।  ⥪  ਣ  SQL*Foprms   믮. 
         믮      室 祢  ਣ,  
         ᪠  .   ।  ⥪   믮,   SQL*Forms
         த 믮 ⠫  祢 ਣ஢.   , 
         ᫥ ⮣   SQL*Forms  訢  ITEMS,   頥
          ⭮   ORDERS.
       :  ⭠ 楤 HIDE_MENU          16-17
                 ⭠  楤 REPLACE_MENU       16-24
                 ⭠ 楤 SHOW_MENU          16-27

।    ଠ       묨  ।⢮
        ⥬ ६.    
       ஢    ⥬  묨  ⥬묨
ମ      ६묨    ६  ᮢ⭮  ᥠ  SQL*Forms
       ( ଠ)  SQL*Menu.

ਪ  SQL*Forms  ᯥ稢   㭪樮஢  ਪ
ணࠬ   ணࠬ    㬮砭.   ਪ  ணࠬ
           믮  設⢮  㭪権
㬮砭   SQL*Forms ( ଠ)     㭪樮 .
            ᪮   ਪ ணࠬ    㬮砭 祭 
        SQL*Forms,   ᯮ짮      ᪠  SQL*Menu.

ᠭ ਪ ணࠬ:    ਪ ணࠬ
  , ᪠饩 . ᭮   ⮨ 
᫥ 権.

Action             ᪠ , ஥ 易 
                   묨 㭪樮묨 蠬:
                   Choise      Function Key
                   
                   Rollback    [Clear Form/Rollback]
                   Commit      [Commit]
                   reFresh     [Refresh]
                   Print       [Print]
                   Exit        [Exit/Cancel]

 ०   Commit  Exit  ᯮ.

Block          ᪠ ,  ᯥ稢饥 ୠ⨢,
               易  㭪樮묨 蠬 믮 :
                   Choice      Function Key
                   
                   Previous    [Previous Block]
                   Next        [Next Block]
                   Clear       [Clear Block]

        ०   Previous  Next   ᯮ.

                                   -- 255 --



  Reord              ⨢ , ᯥ稢饥 ୠ ,
                     易  㭪樮묨 蠬 樨
                     뢠.  ,   ୠ⨢ - First 
                     Last - 易  㭪ﬨ, ᮮ⢥騬 
                     ࠧ 㭪樮 蠬.

                     Choice      Function Key
                     
                     Previous    [Previous Record]
                     Next        [Next Record]
                     First       FIRST_RECORD
                     Last        LAST_RECORD
                     scroll Up   [Scroll Up]
                     Scroll down [Scroll Down]
                     Clear       [Clear Record]
                     Remove      [Delete Record]
                     Insert      [Insert Record]
                     Duplicate   [Duplicate Record]
                     Lock        [Lock Record]

  Field              ⨢ , ᯥ稢饥 ୠ⨢,
                     易   㭪樮묨 蠬 樨
                     뢠.
                     Choice      Function Key
                     
                     Previous    [Previous Field]
                     Next        [Next Field]
                     Clear       [Clear Field]
                     Duplicate   [Duplicate Field]

  Query             ⨢ , ᯥ稢饥 ୠ-
                    , 易  㭪樮묨 蠬 .
                     Choice      Function Key
                     
                     Enter       [Enter Query]
                     eXecute     [Execute Query]
                     Last        [Enter Query]
                     criteria

                     Cancel      [Exit/Cancel
                     count Hits  [Count Query Hits]
                     Fetch next  [Next Set of Records]
                     set

  ਩ Last  ୠ⨢ Cancel ⨬ ⮫쪮  ०  Enter Query.

  Help              ⨢ , ᯥ稢饥 ୠ⨢,
                    易  ࠢ묨 㭪樮묨 蠬.
                     Choice      Function Key
                     
                     Help        [Help]
                     Keys        [Show Keys]
                     List        [List]
                     Error       [Display Error]

    롨ࠥ  ୠ⨢       㬮砭, SQL*Forms
㭪樮 ⠪,  ᫨    ᮮ⢥ 㭪樮
.     㭪樮஢ 㤥   砥  祢 ਣ஢.

                                   -- 256 --



  ⨬,     㭪樮    SQL*Forms ( ଠ)
ᮮ⢥   ୠ⨢  .  設⢮     
 蠬 ࠢ .

  ᯮ짮 ਪ ணࠬ:   ᯮ짮   
㬮砭      ਪ  ணࠬ, ᯥ DEFAULT 
ࠪ⨪    Default Menu Application.  ⮡ࠦ 
㬮砭,   믮 .

  砭:   ᮧ , SQL*Forms ᯥ DEFAULT  ࠪ-
⨪  Default Menu Application    祭    㬮砭.

          맢  3.0 SQL*Forms १ SQL*Forms.
SQL*Plus      १ SQL*Plus  ⠪  ⨢஢ ਪ
              ணࠬ SQL*Forms.

맮         ⮡ ⨢஢ SQL*Plus १ SQL*Forms, 室
SQL*Plus      ᯮ짮 ᫥  楤 HOST:
१ SQL*Forms     HOST ('SQL*PLUS_command') ;

           SQL*PLUS_command ᯥ ⠭  室
              SQL*Plus.    ஡ ଠ樥 頩 
              SQL*Plus Reference Manual.

    ਬ:  1. C騩    ᪠  믮
                  業਩,  뢠 ORDERRPT:

                       HOST ('SQL*PLUS scott/trigger @ORDERRPT');

              2. 騩     SQL*Forms  । 
                 SQL*Plus   SQL*Plus  ࠬ஢ &1,&2.

                       HOST ('SQL*PLUS scott/trigger
                       @ORDERRPT' 10 20 ...');

              3.   ⨢஢ SQL*Plus,  ६.
                 騩  PL/SQL   । SQL*Forms ६,
                  뢠 my_var  ᯮ ६ 
                 ।  ᪨  ࠬ஢ 祭:
                       my_var : = 'SQL*PLUS scott/trigger
                       @ORDERRPT'  global. var_1 ''
                        global.var_2 ...;

                 ᪮  । my_var,  ਣ  뢠
                 SQL*Plus     ᫥饣 :

                       HOST (my_var);
          :   ⭠ 楤 HOST              16-18

맮       ⨢஢ SQL*Plus ( ଠ) १
SQL*Plus  SQL*Forms.    ,           믮
१     ਪ ணࠬ  SQL*Forms. ⮡      ᤥ,
SQL*Plus  ᯮ   RUNFORM.  ,      ᯮ짮
           ᢮⢮, ᫨ SQL*Forms  ⠭ । ࠧ  (
          ।⠢     SQL*Plus Reference Manual).




                                   -- 257 --



           ਬ  RUNFORM,  ᯮ ⠭  ᨭ⠪
         ,   㯮ॡ  짮⥫  ஫.   ⮩ 樨
        SQL*Forms ⮫쪮  ਭ  ⥪  室 ଠ.  
          짮 ⤥쭮 室 ORACLE,  ⨢
          㤥  믮  ॥  १ SQL*Plus, 祬   
        ப.   ஡ ଠ樥      ࠧ묨 室
        ORACLE, 頩    CONNECT   SQL*Plus  Reference Manual.
          :   RUNFORM                       23-7

          뢠 SQL*ReportWrighter  १ SQL*Forms.
SQL*Peport-    砥,       ஢  ᮮ饭
Wrighter      १ ਪ ணࠬ SQL*Forms   짮
              室  SQL*Forms.

           ⮡ ⨢஢ SQL*ReportWrighter १ SQL*Forms,
           ᯮ ᫥  楤 HOST:

           HOST ('(RUNREP_command  SQLREP_command)');
      :
           RUNREP_command     । ⠭  室 
                              SQL*ReportWriter ᯮ ⥬
           SQLREP_command     । ⠭  室
                               SQL*ReportWriter । ⥬.

         ,     ⨢஢   ᯮ, ⠪ 
       । ⥬. ᯮ ⥬  筮  ᪠ 
       SQL*Forms.   ஡ ଠ樥    RUNREP   SQLREP
       頩  SQL*Plus  Reference Manual.

ਬ: 1.騩  ᪠ SQL*ReportWrighter  ࠬ஢:

                        HOST ('RUNREP');
        2. 騩 ࠧ ᪠ SQL*ReportWrighter  । 祭
            ࠬ஢  RUNREP.

                        HOST ('RUNREP scott/tiger deptno = 10');
        3.   뢠 SQL*ReportWrighter,  ६.  ⮡
           믮  ⢨, 室 ᭠砫 । ६.

           騩    ।  ६ SQL*Forms, 
           뢠  my_var   ᯮ ६  । -
            ࠬ஢   祭:

              my_var : = 'RUNREP scott/trigger deptno = ' TO_CHAR (:deptno);

           ᪮  । my_var,  ਣ  뢠
           SQL*Plus    ᫥饣 :  HOST (my_var);
         :   ⭠ 楤 HOST              16-18

        ᯮ짮 । ORACLE  SQL*Forms
--------
    SQL*Forms      ।樮 ணࠬ,
ᮧ    ᨨ 1.3 ।  ORACLE    
  ᨩ.    ⨢஢  ணࠬ   ⭮
楤  USER_EXIT. ᨬ  ⥪ ணࠬ 祭 
।      室 짮⥫     SQL*Forms   ⭮.
    :  室 짮⥫                     19-1
              ⭠ 楤 USER_EXIT          16-28

                                   -- 258 --




        맮   ணࠬ
--------
      IAPCAL      뢠  ਪ ணࠬ  SQL*Forms
    ணࠬ  몠  , 易    SQL*Forms  ( ଠ).
⠪    IAPCAL          ᯥ஢ ⠭
 ப SQL*Forms ( ଠ).   ,   
믮   ணࠬ     権,   
ᯮ짮   ப.

    ⨯   ⠭      IAPCAL  室  䠩 iapcal.h
     ।, ᮤঠ饩  SQL*Forms .

    ⠪:  C騩 ᨭ⠪  ⨯  㭪樨 IAPCAL.

    int iapcal (command_line)
        text * command_line

     command_line ᯥ  ப SQL*Forms ( ଠ)
                 ᪫祭 祢 ᫮ RUNFORM.

     IPCAL 믮  ORDER_ENTRY   -a, -b  -d
४⥫  ப:

    int iapcal ("-abd order_entry");

࠭祭:  ᯮ짮 IAPCAL 室 뢠 ᫥騥 o࠭-:
  - IAPCAL  믮  室  ORACLE RDBMS    
    짮⥫  祢 ᫮  ᯥ஢    ப.  
     믮 室 .

  -  ᯮ 짮⥫᪨ 室.   ࠧ  
    .   ⮣ 室  ᯮ짮  楤 CALL.

        ᯮ짮 ORACLE*TERMINAL
--------
   Oracle*Terminal -  ⨫,   ᮧ   ஢
ନ  祢 । ᮮ⢥⢨.   ⨫ ᯮ 
 த ORACLE.  ᨨ 3.0   ⨫ CRT.

   SQL*Forms (஥஢)  SQL*Forms ( ଠ) ॡ ᮮ⢥⢨
(mappings)  । ᯮᮡ ⮡ࠦ  㭪樮஢  -
.        ᮮ⢥⢨   㬮砭 
।  ன,    ⠭.  ,   -c
४⥫   ப     ᯥ஢   ୠ⨢
ᮮ⢥⢨, ᮧ   訬 DBA    Oracle*Terminal.

     ஡ ଠ樥  ᯮ짮 ନ । 
 1! 頩  Oracle*Terminal User's Guide.

   :  -c   ४⥫      SQL*Forms (஥஢)
             -   ४⥫      SQL*Forms ( ଠ)


।   SQL*Forms      । 10  㭪樮
 F0        SQL*Forms  ( ଠ),     
१           樨. ⮡  뫮 ਬ


                                   -- 259 --



 F9             ਪ ணࠬ, ᯮ
              Oracle*Terminal  ࠦ    ᫥⥫쭮-
                  Fn 㭪樨 ( n - -      0  9).

              ⨬,  㭪樨 F0 १ F9  믮  ⢨.
               ᢠ      ᢮⢠  ⨬ 蠬, ᠢ
              ᮮ⢥騥  Key-Fn  ਣ.
              :  Key-Fn ਣ


              IV                   

            26                  

         ।⠢   樨   SQL*Forms.
ᬠਢ ᫥騥 ⥬:
   - 樨 SQL*Forms ( ଠ)
   - 樨 SQL*Forms (஥஢)
   - 짮⥫᪨ 䠩 २⢥ (preference) ࠢ


        樨 SQL*Forms ( ଠ)
--------
 SQL*Forms   樨, 騥  ⢮    ,
  믮    SQL*Forms (஥஢).     ⢥
᪫祭, ࠡ稥 樨   ४⥫   ப 
SQL*Forms ( ଠ).   ⮨  ⮬,   ᯮ ࠡ
   ஥⨢ 䥩, ४⥫  ப 
 ப.

    ⠭      Set Options.    ࠡ稥 樨
몫   㬮砭.  ᫨  稫  ࠡ  ,   ⠥
   몫祭  襭   ᥠ SQL*Forms (஥஢).
  祭,     믮塞   ,  
  , 뢠  ⮩  ମ,   믮. , 
ࠡ     뢠 ﭨ  । .

砭:   ⠪  ⠭ ࠡ   짮⥫᪮
䠩  २⢥ (preference) ࠢ.

        Buffer RECORD

  Buffer Record  ࠭     ६ ࠡ,  ਧ
쭮 ᫮ ᥩ - ࠧ           .   
    ஢.

᫨   믮      ப   ᯮ짮  
,  ᯮ -b ४⥫  SQL*Forms ( ଠ).

:  -b   ४⥫      SQL*Forms ( ଠ)


        Debug Mode
--------
    ⨢  ०  ⫠   ᥠ SQL*Forms (
ଠ).  ⫠:



                                   -- 260 --



  - ⮡ࠦ  ᮯ஢⥫ ᮮ饭  믮 ਣ  
    ଠ    ⥪饩  ଥ  ६ ࠡ
  - ⨢    뢠, ᫨    ਣ஢ 
    ⭠ 楤 BREAK

᫨   믮     ப   ᯮ짮  
,  ᯮ -d ४⥫  SQL*Forms ( ଠ).
:  -d   ४⥫      SQL*Forms ( ଠ)

Disable       ஢   ஢   (Disable Array
Array      Processing)     㭪樮஢  ᨢ.  
Processing 㬮砭,  SQL*Forms  ⠭ ࠧ ᨢ  ᨬ
             ⢠  ப, ⮡ࠦ   .   ᨨ 3.0
           SQL*Forms      ⠭ ࠧ ᨢ  
            ᠬ⥫쭮.    롨ࠥ   , ࠧ ᨢ
           ⠭   1          ᥠ.

           ᫨  믮     ப  
           ᯮ짮   ,  ᯮ -a ४⥫ 
           SQL*Forms ( ଠ).

           :  -a   ४⥫      SQL*Forms ( ଠ)
                     ࠪ⨪  Array Size

Display     Display Block Menu ⮬᪨ ⮡ࠦ 
Block Menu ,     믮  ,  ᯮ  
           Execute   Action.

           ᫨   믮     ப   ᯮ짮
            ,  ᯮ -m ४⥫  SQL*Forms (
           ଠ).

           :  -m   ४⥫      SQL*Forms
                     ( ଠ)                       23-18

Quiet Mode   Quiet  Mode  ⨢   (quiet) ०,  
           믮 , ᯮ   Execute    Action.   ⮬
           ० ᮮ饭  ᮯ஢ 㪮묨 ᨣ.   
           ⭮  楤 BELL     㪮 ᨣ.

           ᫨  믮    ப   ᯮ짮
            ,  ᯮ -q ४⥫  SQL*Forms (
           ଠ).

           :  -q   ४⥫      SQL*Forms
                     ( ଠ)                       23-19

Set Block   ⠭ ஢ન   㬮砭 (Set Block
Validation Validation as Default) ।  ,   ஢
as Default     ).

             㬮砭  ஢筠    ।,   SQL*Forms
           㯠    ஢થ    .   㬮砭 
            ⠪ ।  ᨬ ࠧ ꥪ,   
               ࠢ  ⮣.  SQL*Forms  㯠  
           ஢.



                                   -- 261 --



           롮 ⮩  樨        ᮧ
            ஢ .
           : ஢筠 

騥      SQL*Forms  㬮砭 ᢠ ⤥  
      SQL,  믮 ମ 
            ।     襭  .  
     ஢, ᪮   
SQL             ஢   ⮫쪮     ࢮ 믮
            ᥠ SQL*Forms ( ଠ),    .

             ᯥ Share Cursors  ࠡ祩 樨 Implicit
           SQL,    ᢠ ⤥   
             SELECT.   㣨    ꥤ 
           ᮢ⭮ ᯮ .   㭪樮஢  ࠭
           ,   ஢, ᪮  
           SELECT, UPDATE, DELETE  SELECT FOR UPDATE  ஢ 
            믮.

           砭: 騥   ࠡ祩 樨 Implicit SQL 
           뢠    ﭨ,  ᫨     ⠭⭮
           ஢   SQL*Forms   ਣࠬ On-Insert, On-Delete 
           On-Update, ᪮  ਣ     祭
           ஢  INSERT, UPDATE  DELETE.

           :  ,                     22-3
                     騥   ࠡ祩 樨 ਣ SQL
                     -t   ४⥫      SQL*Forms ( ଠ)


騥      SQL*Forms  㬮砭 ᢠ ⤥  
      SQL,  믮 ମ 
        ।⢮ ਣ V2.   ஢,
ਣ   ᪮      ஢
SQL        ⮫쪮    ࢮ  믮      ᥠ  SQL*Forms
           ( ଠ),    .

             ᯥ Share Cursors  ࠡ祩 樨 Trigger
           SQL,    ᢠ     
           SQL   ਣ V2.    ꥤ    ᮢ⭮
           ᯮ  .  㭪樮஢   ࠭   ,
              ஢,  ᪮   SQL   
            ஢    믮.

                 ᮢ襭⢮     㭪樮஢   
           ࠪ⨪  蠣  ਣ  New Cursor Area. ᫨  蠣
           ਣ, ᮤঠ饬   SQL,   ࠪ⨪  祭,
            SQL*Forms ᢠ ⤥     .

           ᫨  믮       ப  
           ᯮ짮   ,  ᯮ -o ४⥫ 
           SQL*Forms ( ଠ).

           砭:     ਣ V3 Share Cursor 
           ਣ SQL  뢠  ﭨ.




                                   -- 262 --



           :  ,                     22-3
                     ࠪ⨪ 蠣 ਣ New
                     Cursor Area                           F-6
                     -o ४⥫, SQL*Forms
                     ( ଠ)                       23-18
                     Share Cursor  ࠡ祩 樨
                     Implicit SQL                          24-6


Statistics      ⨪   (Statistics)   ⮡ࠦ ᮮ饭
               ᥠ  SQL*Forms  ( ଠ), ⠭饥
           ᨬ쭮 ⢮ ᠬ⥫ ஢,
           ᯮ짮   ६ ᥠ.  SQL*Forms 뢮  
           ᮮ饭    ࠭  ନ,      ப.

            Statistics ⠪ 뤠 ᫥饥 ᮮ饭   :

           ALTER SESSION SET SQL_TRACE TRUE

              ⠪  砥  ।⢠  ஢  ⥪饣
           ᥠ  SQL*Forms  ( ଠ).    ஡
           ଠ樥      ।⢠   ஢ - - 頩  ORACLE
           RDBMS Performance Turning Guide.

           ᫨  믮     ப   iᯮ짮
             , ᯮ  -s  ४⥫  ப 
           SQL*Forms ( ଠ).

           :  -s ४⥫      SQL*Forms ( ଠ)

        樨 SQL*Forms ( ଠ)
--------
 SQL*Forms    樨, 騥     SQL*Forms
(஥஢)   ६ ⥪饣 ᥠ ஥஢.

 ⠭   ஥஢    Set  Options.  
樨  ஥஢  ⪫   㬮砭.   ᫨  
஥஢  祭,   ⠥ -   -   
몫       ᥠ SQL*Forms (஥஢).
,   ஥஢  뢠  ﭨ 
। .

砭:   ⠪  ⠭   樨 ஥஢    
            짮⥫᪮ 䠩 २⢥   ࠢ.

Disable        ஢ ਣ ࠭樨 (Disable Trigger
Trigger       Compilation) 頥 SQL*Forms ࠭᫨஢ ਣ
Compilation   PL/SQL    楤  ଠ-஢    ⮣   
               .

Generate      ஥⨢  ஢    믮
Before        (Generate Before Executing Form) ⠢ SQL*Forms
Executing     ⮬᪨ ஢   ⮣   ⠭
Form           믮.   믮    ⮩
              樨, SQL*Forms 믮 ᫥騥 ⢨:




                                   -- 263 --



                 -         Generate  Form  
                   ⮬᪨ ᮧ INP 䠩  FRM 䠩  ⥬ 
                   ,   INP 䠩

                 -         Generate  Form  
                   ⮬᪨ 믮 ⥪騩 ⥪ 

Limit Undo      ࠭祭    ⬥   1  (Limit  Undo
Buffer to 1   Buffer  to 1)  ࠭稢  ࠡ    ⬥ 
              믮  ⮫쪮   樨  (ᠬ  ᫥).
               㬮砭       室 ࠭祭.

               ᢮⢮  ᮡ   ⥬, 
              ண  ॡ    .

              ᫨   ।    ᢮⢮    ப
              ᯮ  -s ४⥫   ப  SQL*Forms
              (஥஢).
              :  -l ४⥫      SQL*Forms
                        (஥஢)                       23-11

Show List     ஥⨢    Show List of Values  ᨣ
of Values     SQL*Forms  ⮬,    室  ⮡ࠧ  孥
                   ᯨ᪮   ᮮ⢥  祭,  
                 , 饥  ᯨ᮪ 祭.

Suppress      ஥⨢  Suppress Hints  ⮡ࠦ
Hints         ᪠ (hints)  ப ᮮ饭 SQL*Forms.

Use Formats   ஥⨢    Use Formats as Default  ந
as Default       㬮砭     ஭  ⠡  
              ᮯ殮  .    㬮砭,     롨ࠥ 
              , ⠪    Modify from the Block Menu,   
              ஭ ⠡ Block Definition.   ᯮ짮 ⮩
              ,     ଠ Block Definition.  [Change
              Display Type]    ⮡ࠧ  ᮮ⢥
              ஭ ⠡.


짮⥫᪨ 䠩 २⢥ ࠢ

    ᮧ 짮⥫᪨ 䠩 २⢥ ࠢ, 
⮬᪨ ⨢ 樨  SQL*Forms   ࠧ,    室 
SQL*Forms.  䠩  ᮤঠ 祢 ᫮  ⠭, 騥
樠஢   樨  SQL*Forms (஥஢)   SQL*Forms (
). ਬ, ⮡ 㡥  ⮬,   ଠ,   믮塞 
   SQL*Forms (஥஢) 믮  ⮬ ०,  
 ᫥ ப    짮⥫᪨ 䠩 २⢥ ࠢ:

QUIET_MODE = ON

 䠩 ⠪   樨஢ ᮮ⢥⢨  SQL*Forms
(஥஢).

 䠩 ⠪   樠஢ ᮮ⢥⢨  SQL*Forms
(஥஢).



                                   -- 264 --



⮡       ⢨    ६  ᥠ  SQL*Forms 짮⥫᪨
䠩  २⢥ ࠢ       ᫥騬  ࠧ:
SQLFORMS.CFG    ﭭ 室  ⥪饩 ४ਨ.

᫨  室   SQL*Forms (஥஢)   ४⥫ -
 ப, ᮮ⢥饣 樨 樠樨 ஥஢  ᮮ⢥-
,   ப 砥 ⬥ ⠭  짮⥫᪮  䠩
२⢥  ࠢ. ᫨     ப ᮤন  訡,  
SQL*Forms     ப,   뢠 䠩.

⠪     ⮡ 樠஢ 樨 SQL*Forms (஥஢)
 樠-      樨    SQL*Forms    ( ଠ),   
樨       ᮮ⢥饥   祢   ᫮      ⠭   
権         짮⥫᪮   䠩   २⢥    ࠢ,
              ᯮ  ᫥騩  ᨭ⠪:

              keyword = ON  OFF

                ᫥饩  ⠡  ।⠢  祢  ᫮  
                  ᯮ殮  権.  祢 ᫮
              ᮮ⢥  権.

               樨      祢 ᫮
              
              SQL*Forms      BUFFER_RECORD
              (       DEBUG_MODE
               ଠ)        DISABLE_ARRAY_PROCESSING
                             DISPLAY_BLOCK_MENU
                             QUIET_MODE
                             SET_BLOCK_VALIDATION_AS_DEFAULT
                             SHARE_CURSORS_FOR_IMPLICT_SQL
                             SHARE_CURSORS_FOR_TRIGGER_SQL
                             STATISTICS

              SQL*Forms      DISABLE_TRIGGER_COMPLIMENTATION
              (஥-      GENERATE_BEFORE_EXECUTING_FORM
               ஢)      LIMIT_UNDO_BUFFER_TO_1
                             SHOW_LIST_OF_VALUES
                             SUPPRESS_HINTS
                             USE_FORMS_AS_DEFAULT

                 । ⮫쪮 権, ᪮쪮     
              䠩,   浪. , ,   樨
              몫  㬮砭,   몫  .

⠪     ⮡     樠஢    ᮮ⢥⢨    SQL*Forms
 -    (஥஢),           ᮮ⢥⢨    
樨      짮⥫᪮     䠩    २⢥   ࠢ,
ᮮ⢥-      室 ᯮ짮 ᫥騩 ᨭ⠪:
⢨
              MAPPING = mapping


  27                       
                                




                                   -- 265 --



 ⮩  ᬠਢ ࠧ  ਪ 㬥樨, 
   ᮧ     ࠭  樮 ⥬.
।⠢ ᫥騥 ⥬:
   - ஡ 㬥
   - 㬥  
   - 㬥  ꥪ⠬ 뫮
   - 㬥  楤ࠬ
   - ⪠ 㬥
   - 㬥  ਣࠬ

ଠ  ⮬,  ᮧ    㬥    
।⠢.

砭:     ਪ  ଠ ⮫쪮    ,
    ⥪饩     ଠ  .
:   ਪ 㬥樨      2-5


        ஡ 㬥
--------
஡  㬥  ஡ ᠭ ꥪ⮢ ⥪饣  ⥪
.     㬥樨   ꥪ   ࠪ⨪   
᫥   ꥪ⮢ SQL*Forms:
  - ଠ
  -   
  -   
  -  ਣ 
  -  楤 ଠ-஢ 
  -  ࠭ 

ଠ: ஡ 㬥 稭  ᥪ権 , ।⠢
᫥ ଠ:

  - ࠪ⨪   ᯥ஢          짮⥫,
    ᮧ饣  (.. )
  - 楤ୠ  ᥪ, ।⠢  ࠪ⨪ 楤
    ଠ-஢, ਭ騥 ଥ
  - ᥪ ਣ,  ன ।⠢ ࠪ⨪   ਣ஢,
    祭  ଥ

 㬥樨 ⠪ ᮤঠ ᥪ樨 .   筮 ᥪ樨
 ᫥ ଠ:
  - ࠪ⨪ 
  - ᥪ ਣ,  ன ।⠢ ਣ ࠪ⨪ 
    ਣ஢, 祭  
  - ᥪ樨      

  ᥪ樨   ᫥ ଠ:
  - ࠪ⨪ 
  - ᥪ ਣ஢,  ன ।⠢ ଠ  ᥬ ਣࠬ,
    祭  ଥ

     ஡  㬥樨  ࠭筠  ᥪ,   ன
।⠢ ࠪ⨪ ࠭.

    ஡ 㬥樨 ।⠢    ,   浪,
।  ࠪ⨪  Sequence Number  ࠪ⨪ 
Sequence Number.

                                   -- 266 --



:  , ࠪ⨪                 11-6
          , ࠪ⨪                  12-4
          , ࠪ⨪                 9-3
          楤 ଠ-஢               15-3
          ࠭, ࠪ⨪              10-4
          ਣ,  ࠪ⨪             14-4

        㬥 
--------
  㬥樨      ।⠢  ࠪ⨪    
⥪饬 ⥪ .

ଠ:  㬥樨  㯯஢  ,    ਭ.

㬥   稭  ᥪ樨 ,  ன ।⠢   
ᯥ஢    짮⥫, ᮧ襣  (..  ).

⠢  㬥  ᮤন  ᥪ樨       .
  ᥪ樨  ।⠢ ᫥ ଠ:
  -  
  - ᥪ樨      

  ᥪ樨  ।⠢ ࠪ⨪ .

  㬥樨   ।⠢    ,   浪,
।  ࠪ⨪  Sequence Number  ࠪ⨪ 
Sequence Number.
:  , ࠪ⨪                 12-4

        㬥  ꥪ⠬ 뫮
--------
  㬥樨    ꥪ⠬   뫮   ।⠢  ࠢ筮
ଠ樨  । ꥪ  ⥪饬 ⥪ .

ଠ: 㬥   ꥪ⠬  뫮 稭  ᥪ権 ꥪ,
।⠢     ࠪ⨪ ।  ꥪ.

⠢  㬥  ⮨   ᥪ権      , 饩
뫪  ꥪ.   ᥪ樨  ।⠢ ᫥ ଠ:  -
     -  짮⥫, ᮧ襣  (.. ) -
     ࠧ ᤥ 뫪  ꥪ

  ଠ    ࠢ筮  㬥樨  ⠢  䠢⭮ 浪.

        㬥  ࠭栬
--------
 㬥樨  c࠭栬 ।⠢ ࠪ⨪   ࠭ 
⥪饬 ⥪ .

ଠ: 㬥   ࠭栬  稭  ᥪ権 , ।⠢
 ।    짮⥫, ᮧ襣  (..  )

⠢  㬥 ⮨   ᥪ権 ࠭    ࠭ 
ଥ.      ᥪ樨  ࠭ ।⠢  ࠪ⨪.

 ࠭  㬥樨  ࠭栬   浪, ।
ࠪ⨪ ࠭ Page Number.
:  C࠭, ࠪ⨪              10-4

                                   -- 267 --



        㬥  楤ࠬ
--------
 㬥樨  楤ࠬ ।⠢ ࠪ⨪  
楤  ଠ-஢  ⥪饬 ⥪ .

ଠ: 㬥  楤ࠬ  稭  ᥪ権 , ।⠢
  ।       짮⥫, ᮧ襣  (..
)

⠢  㬥 ⮨   ᥪ権,    ।⠢
ࠪ⨪  楤, ⭮  ଥ.

        ⪠ 㬥
--------
  ⪮  㬥樨  ।⠢  ᦠ⮥  ᠭ ꥪ⮢,
室      ⥪饬   ⥪  .  㬥  ⮨ 
᫥ ꥪ⮢  SQL*Forms:
  - ଠ
  -   
  -   
  -  ਣ 
  -  楤 ଠ-஢ 
  -  ࠭ 

ଠ: ⪠ 㬥 稭  ᥪ権 , ।⠢
        ᫥ ଠ:

  - ࠪ⨪   ᯥ஢          짮⥫,
    ᮧ襣    (.. )    ⥪,  易  
    ࠪ⨪   Comment

  -   ਣ, 祭  ଥ   ⥪, 易 
    ࠪ⨪ ਣ Comment

    ⪮  㬥樨   ᥪ         
ଥ.        ⠪   ᥪ樨 ।⠢ ᫥ ଠ:

  -  ,   ⠡  ன   ᭮     ⥪,
    騩   ࠪ⨪   Comment.

  -   ਣ஢, 祭      ⥪, 易 
    ࠪ⨪ ਣ Comment

  - c樨     

  ᥪ樨  ᫥ ଠ:

  -  ,  ஬  (    ) 祭 ࠪ⨪
    Base Table   ⥪, 騩  ࠪ⨪   Comment.

  -   ਣ஢, 祭      ⥪, 易 
    ࠪ⨪ ਣ Comment

⠢  㬥 ⮨   ᥪ権 ଠ樨  ࠭.

 ⪮ 㬥樨  ।⠢    ,   浪,
।  ࠪ⨪  Sequence Number  ࠪ⨪ 
Sequence Number.

                                   -- 268 --



        㬥  ਣࠬ
--------
 㬥樨  ਣࠬ   ଠ    ਣ  
⥪饬  ⥪ .

ଠ:   㬥樨 ਣ 㯯஢   ꥪ⠬    
           ਭ.

㬥   ਣࠬ  稭   ᥪ樨 ,  ன
।⠢  ᫥  ଠ:

  -   ᯥ஢        짮⥫, ᮧ襣  
    (.. )

  - ᥪ  ਣ,    ।⠢   ࠪ⨪   
    ਣ஢,  祭    ଥ

⠢  㬥  ⮨   ᥪ権      
ଥ.     ᥪ樨  ।⠢ ᫥ ଠ:
  -  
  - ᥪ ਣ஢,  ன ।⠢ ࠪ⨪  
     ਣ஢,  祭  
  - ᥪ樨      

  ᥪ樨   ᫥ ଠ:
  -  
  - ᥪ   ਣ஢,       ன    ।⠢ ࠪ⨪  
      ਣ஢,  祭  
:  ਣ, ࠪ⨪              14-4

                                  28

                        

।⢠  ⫠     믮  ਪ ணࠬ    ६
믮   .    ᯮ짮   ।⢠ 
 訡 ஢.

ᯮ짮  ।  ⫠ ᮡ  ⥫쭮  믮  樨
Debug Mode  ⭮ 楤 BREAK.

   - ᫨  ਪ  ணࠬ  믮   ० ⫠ 
     ᯮ짮 ⭮ 楤 BREAK,     த
     ஢   ப ᮮ饭  ⮡ࠦ ⠭ ᮮ饭.

   - ᫨  ਪ  ணࠬ  믮   ० ⫠ 
     ᯮ짮 ⭮ 楤 BREAK, ⠢   ਣ, 
     SQL*Forms 믮 ਪ ணࠬ  뢠.

砭: 㭪樮   BREAK V2 믮   ⢨   ਣ
           V2,    ⭠  楤 BREAK 믮  ਣ V3.

 ⮩  ।⠢ ᫥騥 ⥬:
  - ⫠ ᮮ饭
  -  뢠
:  ⭠ 楤 BREAK              16-6
          믮 樨 Debug Mode           26-2


                                   -- 269 --



        ⫠ ᮮ饭
--------
  믮 ਪ ணࠬ  ० ⫠, SQL*Forms
⮡ࠦ ⫠ ᮮ饭   ࠡ ਣ.     ᮮ饭
⮡ࠦ   ਣ,  ꥪ, 易  ਣ஬. ᫨ ⭮ 
⨯ V2,   ᮮ饭  ⠪  㪠뢠 浪   蠣 ਣ.

    ࠧ  ⫠筮  ᮮ饭    ਣ ⨯  V3.
Executing POST-FIELD trigger on field SHIPDATE.

         뢠
--------
  뢠        ஡ ଠ  
믮塞    ਪ  ணࠬ.  SQL*Forms 믮 뢠 
६ ࠡ ਪ ணࠬ    ०  ⫠,      
襥 ⢮  ਣ஢   ਪ   ணࠬ   ᮤঠ 
楤 BREAK.

 SQL*Forms c⠫  ⭮ 楤ன BREAK  ० ⫠, 
ਮ⠭  ࠡ  ⮡ࠦ      Debug  Mode  Option.  
⮬    ।⠢  ᫥騥  樨:
  - ontinue with Debug Messages
  - ontinue without Debug Messages
  - Display Global Variables
  - Display System Variables
  - Display Page O Fields
  -Exit SQL*Forms (Run Form)

    ,      権, ⮡  
   ஡  ଠ        ࠡ ०
 ⫠.  ६   ਪ  ணࠬ      ⮡ࠦ
 ⮫쪮 ⥣਩  ଠ樨,  ᪮쪮   .   ਪ ணࠬ
 㤥  室   ﭨ ⠭   ,    ॡ
 த   ४ ० ⫠.
 : ⭠ 楤 BREAK               16-6

Continue      ⫠筠  Continue with Debug Messages ४頥
with Debug    ⠭   த  믮  ਪ  ணࠬ
Messages       ०  ⫠.   ६  ஢  SQL*Forms
              ⮡ࠦ  ᮮ饭  ⫠.

Continue      ⫠筠      Continue  without  Debug  Messages
without       ४頥 ⠭   த  믮  ਪ
Debug         ணࠬ   ०  ⫠.   ६  ஢
Messages      SQL*Forms    ⮡ࠦ   ᮮ饭  ⫠.

Display       ⫠筠  Display Global Variables ⮡ࠦ 
Global        ⮫ ஭ ⠡,    ଠ
Variables        ⥪饩 稭  쭮 ६
              ⥪饩 .

Display       ⫠筠  Display System Variables ⮡ࠦ 
System        ⮫ ஭ ⠡,    ଠ
Variables        ⥪饩 稭   ⥬ ६
              ⥪饩 .




                                   -- 270 --



Display       ⫠筠    Display Page 0 Fields  ⮡ࠦ 
Page          ⮫ ஭ ⠡,    ଠ
0 Fields         ⥪饩 稭  , ᯮ
                㫥  ࠭  ⥪饩  .

Exit          ⫠筠      Exit   SQL*Forms   (  ଠ)
SQL*Forms     ४頥 ᥠ SQL*Forms ( ଠ):

                - ᫨  믮   SQL*Forms (஥஢),
                  SQL*Forms 頥    SQL*Forms (
                  ଠ).
                - ᫨    믮        ப,
                  SQL*Forms  頥      ப.

                                  29

                               

।⢠  ।஢  "⨥ "  (Keystroke)   
墠뢠  "⨥ "     ६ ࠡ
SQL*Forms  ஢   . (    ஢    樨
   SQL*Forms (஥஢) ⠪   SQL*Forms ( ଠ)).  ,
  ஢      ணࠬ   ᯥ祭      
। २⢥  ᯮ SQL*Forms ( ଠ).

   ᬠਢ ᫥騥 ⥬:
  - ᯮ짮 । " "
  - 祢 䠩 業

        ਬ ।஢
--------
ਬ ।  ।஢  뢠    ᯮ짮
ࠧ ४⥫  ப SQL*Forms  ⥪⮢  ।.
  ⮨   樨 ᫥ .
砭:   ࠧ㬥,   ᯮ ।⢠    SQL*Forms
           ( ଠ).

   - 墠  ᪮ " "   祢 䠩 業.
     ᯮ -e ४⥫  SQL*Forms ( ଠ).     ६
     ᥠ      ४⥫ ⠢  SQL*Forms    뢠
     ᪮ "⨥ "    祭   祢  䠩 業.

   - ஢   祢  䠩   業      
       ⢨.

     ᯮ  ⥪⮢ । 䠩  ।஢ 祢
     䠩   業.   ⢨     ਪ ணࠬ,
       ᯮ  祢 䠩  業,  .
   - ᯮ짮   祢   䠩   業,   .

     ᯮ -r ४⥫  SQL*Forms ( ଠ). 
     ४⥫  ⠢  SQL*Forms   ⢨, ।ᬮ७  
     祢  䠩 業.    ᯮ짮 -w  ४⥫
          -r  ४⥫      ࠢ १⮢ 
     室 䠩  ᯫ (  ࠭ ନ).

     砭:  ⮡ ଠ 믮﫠, 祢 䠩 業 
                 ᮤঠ 室 ᨬ (<x>).

                                   -- 271 --



   -  ନ 室   ॣ樮  䠩 ᯫ.

     ⮡ ॣ஢ 室    ᥠ,  믮
     SQL*Forms  -i ४⥫.  ⮡  ॣ஢  室  
     ᥠ 祢 業, 믮 SQL*Forms c -r  -w ४⥫ﬨ.

    ਬ -e ४⥫,   믮   ⨬ 䠩
    業, ᯮ -r  -i ४⥫.  ⥬        믮
    ᯥ樠 ணࠬ ⨢ ⥬, ࠢ騥 ⮡ࠦ
    ॣ樮  䠩, ⮡  㧭,        
    祭  ᨩ  ணࠬ    ।.

    :  -e ४⥫, SQL*Forms    (஥஢)
              -e ४⥫, SQL*Forms    ( ଠ)
              -i ४⥫, SQL*Forms    (஥஢)
              -i ४⥫, SQL*Forms    ( ଠ)
              -r ४⥫, SQL*Forms    (஥஢)
              -r ४⥫, SQL*Forms    ( ଠ)
              -r ४⥫, SQL*Forms    (஥஢)
              -r ४⥫, SQL*Forms    ( ଠ)

        祢 䠩 業

祢  䠩  業 -    " "   
    ६  ᥠ  SQL*Forms.  SQL*Forms ᮧ  祢  䠩
業,    믮  SQL*Forms  (஥஢)   SQL*Forms
( ଠ)   -e ४⥫   ப.

  ਬ ᮤন 祢 䠩 業.  ( ப  
      䠩;     ࠢ.)

1  ; Generated  by  SQL*Forms  Version  3.0  on  Jun 6
   10:23:13 1989
2  ;
3  s c o t t <Next Field>
4  t i g e r <Next Field>
5  <Enter Query>
6  1 0 0 <Execute Query>
7  <Commit Form>
8  <Exit/Cancel>
   ப 1  2  窠  ⮩ 㪠뢠  ப ਥ.
਩  ப 1 -  , ᣥ஢ SQL*Forms.

㭪樮 祢 , 饭  ᪮ (<>), 뢠, 
   㭪樮  .  뤥    ᮮ⢥
  㭪樮 祩  SQL*Forms (஥஢)   SQL*Forms
( ଠ).

 ᫥饩 ⠡ ,   SQL*Forms ⮡ࠦ ᯥ樠 ᨬ 
஫ ⨯  祢 䠩 業:
C             ⮡ࠦ

;                  \;
<or>               \<or\>
[or]               \[or\]
\                  \ \
blank character    \b


                                   -- 272 --



砭:  ᫨  ᯮ  ।஢,   祢  䠩
業  ⠭  ᪮쪮  .  ଠ  ᮡ⨨   
 ᪮.  ਬ:
                                [x 3 23 1 <Show Keys>]

-      ᯮ짮 祢 䠩 業  
          ६ ᥠ SQL*Forms (஥஢)  SQL*Forms
祢     ( ଠ).     ।஢  䠩, ⮡
䠩           ⢨, 뢠  . ਬ:
業      
                 1 1 5 <Next Record>
              
                 2 0 0 <Commit Form>
                 <Next Record>













































                                   -- 273 --
