






            SQL*Forms                          

            (SQL*Forms Operator's Guide)      3.0





      ORACLE
      
      樮 ⨢ ⥬  












































                                    -- 1 --



㪮⢮   SQL*Forms    3.0
 N3301-V3.0 0789

:Susan K.Jackson,Kathleen Gomoll
:Chris Schock

᪮ ࠢ:Oracle ௮ 1986,1989
 ࠢ १ࢨ. ⠥  
 ࠭祭 ࠢ
ᯮ짮, ஢  ᥪ稢   ७ 
襬 ࠪ  Oracle ௮樥.

ᯮ짮, ஢  ᥪ稢 ࠢ⥫⢮  
७    ᪮  ணࠬ  ᯥ祭    
࠭祭묨  ࠢ    ணࠬ  ᯥ祭    ᮮ⢥⢨ 
ࠫ .

ଠ  ⮬ 㬥     ।०. ᫨ 
  -   㬥樨, ,   
  ⮬.  Oracle  ௮    ࠭  ⢨  訡   ⮬
㬥.

ORACLE  SQL*Forms ॣ஢ ࣮묨  Oracle ௮樨.


                     

     㪮⢮      ࠡ     ஥묨
   ਫﬨ, ᯮ  SQL*Forms. ᫥  ⥭  ⮣
   㪮⢠  㤥   믮 c騥 :
      - 믮 
      - ᯮ짮      ⮣,  ⮡    ।஢
         
      -           ORACLE, ᯮ ਩ ᪠
      - , ஢  㤠 
      -  ࠭樨    ORACLE

      㪮⢮        ࠧࠡ뢠   ஢ . 
    SQL*Forms Designer's Reference  SQL*Forms Disainer's Tutorial.

᮪  㬥    SQL*Forms    ᨨ  3.0  ⮨  㬥⮢
ᯮ⥫쭮  ⥬      ᫥    SQL*Forms  㬥⮢:
       - SQL*Forms Operator's Guide,  3.0, Oracle N3301-V3.0 0789
       - SQL*Forms Designer's Tutorial,  3.0, Oracle N3302-V3.0 0789
       - SQL*Forms Designer's Reference,  3.0, Oracle N3304-V3.0 0789
      - SQL*Forms Operator's Quick Reference,  3.0, Oracle N3704-V3.0 0789
      - SQL*Forms Designer's Quick Reference,  3.0, Oracle N3708-V3.0 0789

      ⠡  ⪮  ।⠢    㬥, ।祭
         ⥫  । ⢮  㬥⠬.

                                          ।⥫쭮
    㬥             ⥫           ⥭ 㬥⮢
    
    Operator's Guide    箪-  
    Designer's Tutorial 箪-  Operator's Guide



                                    -- 2 --



    Designer's Help     箪-  Designer's Tutorial
    System

    Designer's          .   Designer's Tutorial
    Reference

    Operator's Quick    .   Operator's Guide
    Reference

    Designer's Quick    .  Designer's Tutorial
    Reference

            㪮⢮      SQL*Forms  窨 ७
࣠  . ᫥    饭    ࠦ  
㪮⢮   ਬ砭ﬨ,     ᭮  楤,
              室  믮 ஥ ਫ, ᯮ
              SQL*Forms.

     ।⠢ ᫥騥 ᭮ ࠧ ⮩ :

     1     ।⠢  SQL*Forms.
     2         祭    ᭮  楤 믮
              , ⠪    蠣  믮
              樮 , ᯮ㥬   ⮬ 㪮⢥.
     3     뢠,  ᯮ짮   祭
              ଠ樨    ORACLE.
     4     뢠,  ६   .
     5         믮   ᮢ,
              㤮⢮ । ,  ᫮ ᮢ,
              ⢥ ᪮쪨 ᫮.
     6      䨪      .
     7     ᮤন ଠ  ᯮᮡ ࠭権 SQL*Forms.
    祭 ⠪  ࠢ ਫ, ᫮   ⠫
    뫮.

            㪮⢮ ஥ ⠪, ⮡   ࠡ 
짮  ਫﬨ  SQL*Forms.   祭 祭 祭
㪮⢮  ࠦ, 騥    樮 ଥ. 
                ஬  㪮⢮, ।    ࠡ 
              ࠦﬨ  㢨 १  ࠭.

      ⮡ १⨢ ࠡ  ࠦﬨ  ,  
      믮     ᥠ.  ⨢ 砥,   㢨 
      १⮢.

襭,    SQL*Forms Operator's Guide ਭ ᫥騥 ᮣ襭:
ᯮ㥬
 㪮⢥
     -   㭪樮      ᪮,
       ਬ: [饥 ].  ᬮ   奬  ᯮ⥫쭮
       , ⮡ 㢨,  㭪樮  ᮮ⢥
       蠬  襬 ନ.

     - ,  ⮡ࠦ  ࠭,  ⥪,    
           襬  ନ,  뤥 ᯥ樠 ⮬:




                                    -- 3 --



 ࠤ       Oracle Corporation   業  襩 㬥樨. 
訬          ᯮᮡ ᮢ襭⢮    த⮢  
    祭 ⭮ 裡  㬥.

     ,  ᮮ     ਨ,  ᫨  ,   ⮬
     㪮    㣮  㬥⮢  SQL*Forms. ᯮ
     ⥫   ਥ,     ⮩  ,    
       ⥫.  415-598-8000 㪮⥫ த SQL*Forms.



















































                                    -- 4 --




                       

 1        .................................................. 1-1
              ॡ  ⠭ ................................. 1-2
                 ⠭ 樮   .............. 1-2
               ⠪ ଠ? ....................................... 1-3
                  ORACLE ............................. 1-4
                   ..................................... 1-5
              ࠭ ଠ ........................................ 1-5
                  ᮮ饭 ..................................... 1-6
                  ﭨ ..................................... 1-6
              奬  ....................................... 1-6
                 ᯮ짮   SQL*Forms ...................... 1-7
              ⢥ত ⮢ ............................... 1-7
              ࠢ筠 ଠ .................................. 1-8
                 ⥫쭠  ............................... 1-8

 2       믮  ....................................... 2-1
              믮  ....................................... 2-2
                樮 ଥ ........................ 2-3
               樮 ଥ ............................... 2-4
              襭 ᥠ ।஢ ....................... 2-4

 3       믮  ..................................... 3-1
                    ...................... 3-2
              롮ઠ  ᥩ ................................... 3-3
 4       ६饭  ଥ .................................... 4-1

              ६饭     ........................... 4-2
              ६饭     ......................... 4-2
              ६饭     ............................. 4-5
                 ६饭  ।  ......................... 4-6

 5       祭 ࠭ ᥩ ........................... 5-1
              ࠢ  祭 .............................. 5-2
                 ᯮ짮 ࠢ  ࠧ殬 .................. 5-5
               ⢠ ᫮ ............................. 5-5
              ᯮ짮 SQL-ࠧ WHERE  ᯥ ᮢ .... 5-7
                 ।  祭 ........................ 5-7
                 ᯮ짮 ࠧ WHERE ⥫묨 ᯮᮡ  5-10
                 ᯮ짮 ᫮  ᪠ ............. 5-10
                  ᥩ  ............................ 5-11
                 ᯮ짮 ࠧ WHERE  ᫮묨 ᫮ﬨ .... 5-12
 6       䨪     ....................... 6-1
              ⠢,   㤠 ᨬ .................... 6-2
              ⠢  㤠  .............................. 6-2
               ଠ樨    ..................... 6-6
                ᥩ ................................. 6-8
                  ORDERS  ............................. 6-8
                 㣨 ⮤  ᥩ ................... 6-10
                  ITEMS  ............................. 6-11
                   CLIENT DATA ....................... 6-12
                 ⥫ ਨ   CLIENT DATA ..... 6-14

 7        SQL*Forms ....................................... 7-1
              襭 ࠭樨 .................................. 7-2
                 ⮢ .......................................... 7-2

                                    -- 5 --



                 ஢ઠ ࠢ쭮  ........................ 7-3
              ⨥ ࠭樨  ................................ 7-4
              ᯮ짮 ⮬᪮   ............. 7-4

ਫ   㭪樮  ................................. -1
ਫ   樮 ⠡ ............................... -1
ਫ   饭 .............................................. -1
              
              ⠫
              ଠ  ਥ ⥫

















































                                    -- 6 --



     1                  

    ᫥騥 ⥬:
       - ॡ  ⠭
       - । 
       -     ORACLE
       - ࠭ ଠ
       - 㭪樮 
       - ⢥ত ⮢
       - 祭 ࠢ

ॡ   ⠭

  ०, 祬    ᬮ 믮  SQL*Forms,    襬  
   ⠫஢ ࠢ ⥬ 樮      ORACLE
  (RDBMS).  (  ORACLE Installation and User's Guide  襩  ⥬,
  ᫨ RDBMS  SQL*Forms  ⠫஢.)

   室  짮⥫  ஫.  짮⥫  
   ⭮ 짮⥫ ORACLE,  ஫ ⢥ত,    -
   ᮡ⢥ ᢮ 짮⥫᪮ .  ᫨  
  ୠ ⥬ ᯮ ᮢ⭮   㣨 짮⥫ﬨ,
       ஫      (DBA).


⠭      ⠭ 樮       室
.   믮  䠩 DEMOBLD.  믮 ⮣ 䠩
     demobld  襩 樮 ⥬ .

  ਬ砭:  ᫨  樮       ⠭ 
  demobld, ,    䠩 DEMOBLD ᯮ  㣮
  ४ਨ.   DBA,  ᯮ  䠩 DEMOBLD. ३
    㦭 ४   demobld.

    DEMOBLD  ।⠢      롨,  
  㭨⮦  樮  .  ࠧ,   㤥
  ࠧ襭  롨, ஢  㭨⮦ ଠ 
  樮  .

  樮 ଠ SAMPLE,   ࠧ饭  ORACLE ४ਨ 
   襬 ORACLE ᪥.

  ਬ砭:     ஥     
  㭪権,        ᮤঠ - ᮡ,
  ⫨騥     樮  ⮣ 㪮⢠.  祭
  ଠ樨   -  ᮡ 襩    DBA.













                                    -- 7 --



 ⠪
ଠ?        ଠ  -    ᠭ        蠡  襬
              ୮ ࠭,    , 
                訢 ଠ     .    
              , ᥩ  .

㭮 1-1   Ŀ
.                                                           
ଠ                  
.1            O R D E R S                                           
                                                                       
                 Order ID           Order Date               
      Ĵ                                                        
                 ClientID      Client Name            
                                                                       
                                                                       
                       
                I T E M S                                             
                                                                        
                    OrderID It.No.  Code  Act.Pr. Quant. It.Total             
                    ͻ  ͻ  ͻ  ͻ  ͻ  ͻ                
    Ĵ                                               
                    ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                       
                 Count: 3                           <List><Replace>     
                                                                        
              

㭮 1-1   Ŀ
.             
ଠ             C L I E N T  D A T A                                  
.2      Ŀ                                          
             Client ID                                        
                                                                        
                      Name                
                                                                        
                   Address                
                                                                        
                      City                            
                                                                        
                     State   Zip                                
                                                                        
                     Phone                                     
                                                                        
                                                                        
                    Credit                                        
                                                                        
                   Comment                
                                                                        
                                                                        
                     
                 Count: 3                                  <Replace>    
              

          㯯 易  ଥ 
          ப ⠡      

                                    -- 8 --



            ࠭ (筮 ઠ),   ⮡ࠦ
              祭    ਭ   祭.  筮  
              ।⠢   ⠡  .

    ORACLE

        믮   SQL*Forms,        , ஢
   㤠     ORACLE.    ORACLE  ࣠
       ⠡  易 ଠ樨.    ⠡  ⠢  
  ப  .  (  ࠧ ⠡.)

      ଥ ᮮ⢥ ப  ⠡. ਬ,  ப
  ⠡ ITEM (.1-3) -  ࢠ    ITEMS (.1-4).

              Ŀ
.1-3        ORDID   ITEMID   PRODID   ACTUALPRICE   QTY   ITEMTOT    
            
ITEM             601        1   200376           2.4     1       2.4    
                 602        1   100870           2.8    20        56    
                 603        2   100860            56     4       224    
    ப > 604        1   100890            58     3       174    
                604        2   100861            42     2        84    
                604        3   100860            44    10       440    
                605        1   100861            45   100      4500    
                605        2   100870           2.8   500      1400    
                605        3   100890            58     5       290    
                605        4   101860            24    50      1200    
                605        5   101863             9   100       900    
                605        6   102130           3.4    10        34    
                                                                     
                                                     
             
             Ŀ
.1-4                                                                
 ITEM              
                 O R D E R S                                           
                                                                       
                 Order ID           Order Date               
                                                                       
                 ClientID      Client Name            
                                                                       
                                                                       
                       
                 I T E M S                                             
                                                                       
                   OrderID It.No.  Code  Act.Pr. Quant. It.Total       
                     ͻ  ͻ  ͻ  ͻ  ͻ  ͻ          
     >                                        
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                     
                 Count: 3                           <List><Replace>     
                                                                        
              




                                    -- 9 --



      롨ࠥ      (믮 ),   ,
    ⮡ࠦ, 室  ப ⠡.   ⮣,  ᫨  
  ,   㤠 ,    뢠  ᮮ⢥騥
  ⢨  ப ⠡. .1-5  뢠      
  ᮮ⢥⢨ ⠬ .

                
  
                         
  ப                        
                         

       SQL*Forms    ࠡ  ।⢥    ⠡栬 
       ;  ࠡ   ﬨ,  ࠭  ࠡ祩
              .      ᮢ襭 訡;  
              ᤥ   ࠡ祩 ,  ⥬ ⪠  .
              ᫨  ⪠  , ᠬ ⠡  㤥 襭.



࠭ ଠ
   ࠭ SQL*Forms ⮡ࠦ ᭨⥫ ⥪, ᪨ 
    ,  ᮤঠ 祭 .    ࠭ 室
   ᮮ饭   ﭨ.

              Ŀ
.1-5                                                                 
                   
ᮮ饭         O R D E R S                                           
                                                                  
ﭨ         Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                                                                        
                        
                  I T E M S                                             
                                                                        
                    OrderID It.No.  Code  Act.Pr. Quant. It.Total       
                      ͻ  ͻ  ͻ  ͻ  ͻ  ͻ          
                                                            
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
      >                                                        
   ᮮ饭         
      > Count:            ENTER QUERY            <Replace>     
   ﭨ                                                            
              

 ᮮ饭      ᮮ饭 ⮡ࠦ ᮮ饭 SQL*Forms.
 ﭨ      ﭨ  ᮤঠ (᫥ ࠢ):

   Count:        뢠   ⢮   ᥩ,   ࠭ ᮬ. 
                 ᫮ 㢥稢  ࠧ,   ⮡ࠦ ,
                 맢 ᮬ.        ᫥ ,
                 । ᫮  ᨬ (*).



                                    -- 10 --



   <             뢠,      砫   ⥪饣    䠩   
                  ஭ ࠭.     ⮡ࠧ  砫
                 䠩,  ६⨢  .

   >             뢠,         ⥪饣   䠩   ࠢ
                 ஭ ࠭.     ⮡ࠧ    䠩,
                 ६⨢  ࠢ.

   ^             뢠   稥  ᥩ  ।  ⥪饩   .

   v             뢠  稥  ᥩ  ᫥  ⥪饩   .

   ENTER QUERY   뢠,    [ENTER QUERY]    
                 [EXECUTE QUERY]  [EXIT/CANCEL].

   <LIST>     ,   ᯨ᮪ 祭, 易  ⥪騬 .

   <INSERT> or   ⮡ࠦ  ⥪騩  ०:  ⠢,  
   <Replace>     .


奬 

       믮  SQL*Forms,          ।
   ६饭 ,    ,    ࠭
  ଠ.    뢠 㭪樮묨 蠬,  ⠪    
  믮 㭪樨 SQL*Forms.

  .. SQL*Forms 믮   ࠧ , 㭪樨 (⠪
   [NEXT FIELD])        ࠧ   祭
  ࠧ묨  ᫥⥫쭮ﬨ 襩.    ࠧ襭  ⮩ ஡
  SQL*Forms 뢮 ᯨ᮪  㭪権  ᮮ⢥   
  奬 .

   ,    ⮡ࠧ  奬  ᯮ㥬   :

   1.   ⠭  奬      ORACLE Installation  User's
      Guide.
   2.   DBA  奬  (᫨  襣 ନ 
      ⫨砥  ⠭⭮ 奬).
   3. ⮡ࠧ  奬      ६  믮 SQL*Forms, 
      [Show Keys].

  奬    ᯮᮡ   楫   
  ࣠樨.  ⮬      室 ᬮ  㭪樮
   ࠭,  祬     ⮬ 㪮⢥.

   ਫ   SQL*Forms Operator's Quick Reference  ᠭ
  ⢨  㭪樮쭮 .

ᯮ짮   祪,   ᯮ짮 , 
         易⥫쭮 ᯮ짮 㭪樨  . SQL*Forms
SQL*Forms     ন    㭪樨  ࠢ  , ⠪  
                ப⪠. ਬ,     ᯮ짮
                롮  ⮢ , 饫  
               ப ।㥬 .



                                    -- 11 --




⢥ত  ⮢
   ⮢ SQL*Forms       ⨯ ᯫ뢠
   ,    筮  ४뢠  ⥪騩 ࠭.  ⮡  ⢥   
   ⮢   ࢮ   ⨯, ᯮ     
   ⢥ (Yes, No  Cancel)   [Select].    ⮢   ண
   ⨯,  ன ।ᬮ७ ⢥ ⢥ "OK",     
    [Select]   ⢥ত  ⥭ ᮮ饭.


祭 ࠢ
    믮 ,    ࠢ ଠ, 
  [Help], [Show Keys]  [List].

⥫쭠 
     ᯥ稢 ⥫   襬 .  
     ਭ        ࠭ ଠ樨,     
      ⮡ࠧ   ⨥ 㭪樮쭮       롮஬ .
   㬥, ᮯ஢  ,  ᪠   ,  㯭  
   ⥫쭠 ,      祭.
2-2 㪮⢮   SQL*Forms

                             2


      

     ᭮ 楤 믮 ,
    ⠪    ᯥ樠  蠣    믮
  樮 ,  ᯮ㥬    ⮬  㪮⢥.

믮 
   믮  室 த ᫥騥 ᭮ 蠣:

   1.  ᥠ  .
   2. 믮 ⥬ :
     .  RUNFORM   ஡.
     .   ,    믮.
     .  RETURN.

      SQL  뢥   ࠭.

   3.       짮⥫  ORACLE   RETURN.

   4.   ஫     ஫  ORACLE     RETURN. ⨬, 
        ஫    ࠭  ⠭ .   ࠭ 
      ,  ᯥ稢 SQL*Forms.

       SQL*Forms ⮡ࠦ   襬 ࠭.

  ᫨    뢮  ࠭,       
  짮⥫  ஫  ⥬ . ଠ  ᫥騩:

  RUNFORM [樨]   [ 짮⥫/஫]

  ਬ, ⮡ 믮    ORDERS,     :

  RUNFORM ORDERS SCOTT/TIGER

                                    -- 12 --



  ਬ砭:  楤 ࠡ⠥ ⮫쪮 ⮣,  ଠ
              室  ⥪饩 ४ਨ.


   樮  ଥ
ࠦ
   祭 㯠  ଥ, ᯮ㥬  ࠦ
  ⮣ 㪮⢠, த ᫥饥 ࠦ:

   1. 筨 ࠡ  樮 ⥬ 襣 .
   2. ⥬  :

      RUNFORM SAMPLE  짮⥫/஫

        DBA, ᫨ 樮 ଠ  ⠭.

   3.  RETURN.
   4. SQL*Forms ⮡ࠦ 樮   襬 ࠭.

   ਬ砭:   ⮬᪨ ⮡ࠦ   ORDER DATE.

㭮 2-1   Ŀ
-                                                            
 ଠ             
                  O R D E R S                                           
                  Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                                                                        
                        
                  I T E M S                                             
                    OrderID It.No.  Code  Act.Pr. Quant. It.Total             
                      ͻ  ͻ  ͻ  ͻ  ͻ  ͻ                
                                                                  
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                       
                 Count:                                  <Replace>      
                                                                        
              

 樮  ଥ
  樮  ଠ,   ᯮ㥬  ⮬ 㪮⢥,   
䨪⨢  The Summit Sporting Goods Company. ।,  The 
Summit Sporting Goods Company ᯮ 樮   ࠭ 
஢ थ஢, 砥    ࣮ ।⠢⥫. ࣮ 
।⠢⥫      थ  㪮᭮ .      
 थ ࠬ  ,   ଠ     
, ᯮ SQL*Forms.  㤥 ᯮ짮 樮  
⮣ 㪮⢠  ࠡ  ࠦﬨ.

 樮 ଠ, 뢠 SAMPLE, ⮨   : ORDERS, 
ITEMS  CLIENT DATA.   ORDERS,   ᭮ ଠ    
⥪饬 थ,   ⠡  ORD    樮    
.  ITEMS, ᭮  ⠡ ITEM,   ଠ  


                                    -- 13 --



 थ,    CLIENT DATA, ᭮    ⠡ CUSTOMER, 砥 
⠪ ଠ ,     ⥫䮭.  ᮮ饭   
ﭨ    ࠭    .

ࠦ,  祭      㪮⢮, ᭮  ⠡ ORD, ITEM  
  CUSTOMER  樮   ORACLE. ᫨    箪    
SQL*Forms,  訩 ᯮᮡ 祭 -    믮 ࠦ ⮩ .
(室 ᮤঠ ⠡ ORD, ITEM  CUSTOMER   ਫ .)

ਬ砭:  ᫨     -     ⠡ -
      樮  ,   ,   㢨  ࠭,  
      ⫨  ,   ࠭ ࠧ ⮣ 㪮⢠.


襭    ஢
  ࠡ⠫  ମ,     ࠭ 
        .    襭  ᥠ
।஢ 室 ᫥騥 蠣:

 1.  [Commit] ⮡        .

 2.  [Exit/Cancel]. SQL*Forms       ⥬ .





































                                    -- 14 --



                                     3

 

    ⮩   㤥  ᯮ짮   롮ન ଠ樨  
  ORACLE. 롮ઠ ଠ樨    뢠 믮 
. ⠩    ⮣, ⮡ 㧭,   訢    
       , 㯭  ᮡ .

 訢   
  Summit Sporting Goods,    ⮫쪮 
 थ     㯫,  ⠪ ஢
थ        ⢮. , ० 祬
஢ थ,  室     .
   롮ન ଠ樨 뢠 訢
 .

  訢    直  ࠧ    
室 ᬮ  ஢ 騥 .
ਬ, ᫨   ஢  थ  㧭
  ॣ஢,     
롮ન ᮮ⢥ ᥩ.

  ᤥ     ᯮᮡ.

 1.        ᨬ   ,   
    ᮤঠ.

 2.       ⮫쪮    ,   㤮⢮ 
    । . (ਬ,     ᬮ  
    , ਭ 1  1989 ,   , 饭 ⮬ 106.)


롮ઠ  ᥩ
⮡   , ࠭    ⠡, ⠭   , 
易  ⠡楩   [Execute Query].

 ⥪騩   SAMPLE ଥ  ⮡ࠦ ᥩ.    
 , ࠭  ⠡ ORDERS, 믮  ࠦ:

   ࠦ  1.  [Execute Query].    믮 , 
  室  ࢮ  .  믮    
⫨筮    ORDER ID,     [Next Field] ⮡ ३    
㣮  ⥪饣     ⥬    [Execute Query]    믮 
  ⮬ .

  ࠭  룫拉  㭮 3-1.

㭮 3-1   Ŀ
롮ઠ                                                             
ᥩ                 
                  O R D E R S                                           
                  Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                                                                        
                        

                                    -- 15 --



                  I T E M S                                             
                    OrderID It.No.  Code  Act.Pr. Quant. It.Total             
                      ͻ  ͻ  ͻ  ͻ  ͻ  ͻ                
                                                                  
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                       
                 Count:                                  <Replace>      
                                                                        
              

 ⨥ [Execute Query]    롨ࠥ    , ࠭  ⠡, 
SQL*Forms ⮡ࠦ ⮫쪮    ⥪騩 .  ந室 
⮬,     ORDERS    ⢥ ; ⮫쪮  
   ⮡ࠦ  ⥪騩 .    㣮 ஭,  ITEMS 
   ⢮ ᥩ;    ⮡ࠦ ࠧ   
ᥩ.   ப  ࠭ ,  ⮫쪮 ᪮쪮 
ᥩ ⮡ࠦ    ६.








































                                    -- 16 --



                                     4

   

    ࠡ⠥    ମ -  ᪠ 騥 ,  
   -  室 ६       
㣮.   ,  த ᫥騥 ६饭 :
   -    
   -    
   -    

६饭     
   ⮡  ६            㣮, ᯮ 
   [Next Block]  [Previous Block].

  ࠦ   1. ᫥ 樮஢   ORDERS,   ࠧ
                  [Next Block].  ITEMS ⠭ ⥪騬 .

   ⨬,     Order ID  祭 601.   㤮⢠    
   㢥७    ⮬,  थ  ࠢ쭮, 祭 Order ID ⠥ 
     ORDERS  ⮬᪨ ⮡ࠦ   ITEMS.

2.   ࠧ [Previous Block], ⮡ ३ ⭮   ORDERS.

3.   [Next Block].  ࠧ,  ⠭    
   [CLIENT DATA].

4.   ࠧ [Next Block]. ORDERS ᭮ ⠭ ⥪騬 .

       ६頥       ,    
   横᪨.  ਬ,     ࠫ    ᫥      
      [Next Block], SQL*Forms   ⭮  ࢮ 
   .   ࠧ,   ᫨   [Previous Block]  ᫥ 
         ,   ६頥  ᫥  
   .


६饭     

᫥ ⮣,       ,   ᯮ짮  
[Next Record]    [Previous Record],  ⮡ ᬮ  .  ᫨    
ᮤন  ⮫쪮  ,   ⮫쪮  . ᫨   
ᮤন ⢮ ᥩ,    㢨    祬  .   
        㣮    ᯮ짮   ६饭.  ⮡  
ᬮ ⠢訥    ORDERS,  [Next Record]  ࠧ 
 ᬮ  ᫥饩 .

   ࠦ  1.   ࠧ [Next Record]. SQL*Forms ⮡ࠦ
                   ࠭ Order ID 605.

               2.   ࠧ [Previous Record]. SQL*Forms ⮡ࠦ
                    ORDERS ଠ  Order ID 604. (.4-1.)

                  ⨬,       Order ID  ITEMS 
                  祭 601.  ஥஢  ⠪,   
                   [Next Block],   ID  㤥 ⮬᪨
                  ᪮஢   Order ID  ORDERS   Order ID
                   ITEMS.

                                    -- 17 --



㭮 4-1   Ŀ
६饭                                                             
               
            O R D E R S                                           
                  Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                                                                        
                        
                  I T E M S                                             
                    OrderID It.No.  Code  Act.Pr. Quant. It.Total             
                      ͻ  ͻ  ͻ  ͻ  ͻ  ͻ                
                                                                  
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                       
                 Count: 5                          <List><Replace>      
                                                                        
              

⮡ 㢨  [Next Record], [Previous Record], [Up]  [Down] ࠡ  
  ⢮ ᥩ, த ᫥饥 ࠦ.

  ࠦ
1.  [Next Block] ⮡ ३   ORDERS   ITEMS.

2.  [Execute Query].
    㪠 SQL*Forms     ⠡ ITEMS,    
   祭  604    Order ID. SQL*Forms ⮡ࠧ     
    㭪 4-2.


㭮 4-2   Ŀ
                                                                   
⢮              
ᥩ           O R D E R S                                           
                  Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                                                                        
                        
                  I T E M S                                             
                    OrderID It.No.  Code  Act.Pr. Quant. It.Total             
                      ͻ  ͻ  ͻ  ͻ  ͻ  ͻ                
                                                                  
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                       
                 Count: 3                          <List><Replace>      
                                                                        
              

3.  [Next Record], ⮡ ३  ᫥   ITEMS.


                                    -- 18 --



4.   ࠧ [Next Record].
   ਬ砭:    ⫨稥    ६饭   , ६饭  
   ﬨ   横᪨.    ⨣ ᫥ ,  
      ⭮   [Previous Record],  ⮡     
   ࢮ .

5.   ࠧ  [Previous Record].     ࢮ 
     ITEMS. SQL*Forms ⮡ࠧ ᮮ饭:

   FRM-40100: At first record.

6.  [Next Field].

7.  [Down].  ६頥    ,  ⠥  ⮬ 
    .

8.  [Up].  ६頥    ,  ⠥  ⮬ 
    .

   ਬ砭:    ᪮쪮 ᥩ   ,   
   ᯮ짮 [Up]  [Down]  [Next Record]  [Previous Record].


६饭     
                ६     㣮, 
              [Next Field]  [Previous Field].

  ࠦ
1.  [Previous Block] ⮡ ३   ORDERS.

2.   [Next Field].   ३   Client ID.

3.  ᭮ [Next Field].

    ६饭   Client Name,   ,  ६ 
   ⭮  Order ID.  ந室 ⮬,   Client Name 
   ஥஢ ஬   .

         祭  Client ID     ORDERS, SQL*Forms 롨 
      ⮬᪨ ⮡ࠦ       Client Name.    
   ⮬᪠  롮ઠ 蠥 ⭮ ࠡ.

4.  [Previous Field].  ६頥     Order ID ⭮  
    Client ID ( ய᪠  Client Name).

5.  ᭮ [Previous Field].     Order Date.

冷,  ஬  ६頥      㣮, । 
஬ .    ଥ SAMPLE   室   Order ID   
Order Date,  ⥬   Client ID. 㣨 , ᯮ騥 ⠪  
,        㣮 ᫥⥫쭮.  , 筮      
㦨,       ᯮ   ᫥⥫쭮 ᫥ ࠢ  
ᢥ .

᫨ 祭  ࠢ쭮,  SQL*Forms       
,      ⪮४ 祭. ਬ, ᫨  ॡ 
᫥ 祭  100  9999,    ,  祭 
ࠢ, ਬ, 99  10000.   ⭮  筮 ० ନ.

                                    -- 19 --



᫨    ਡ ⮬᪮ ய᪠,   
 ᫥  ᨬ  ᫥  .   ⮬᪮   
ய᪠   ᯮ    樨 ⮢    , 
 ॡ ⠭⭮ ⢮ ᨬ, ⠪     
⥫䮭.


६饭   ।  
  ࠡ⠥  ,  ६饭      
ᯮ [Left],   ६饭    ࠢ ᯮ 
[Right].

   , 祬 ᮮ⢥  ⠡.   ࠧ,  
      ,  祬 稭,   ᮤন.   
ந室,   㢨  ᮤঠ . , SQL*Forms   
 ६ 稭 ।    ।  ⠪,    ᬮ  
㢨  稭  楫.     뢠 ਧ⠫쭮 ப⪮. 
饥 ࠦ 뢠,  ᤥ ਧ⠫ ப, 
ᯮ  [Left]  [Right], ⠪  [Scroll Left]  [Scroll Right].

  ࠦ
1. ,    ⠭     ORDERS    [Enter 
   Query].

2.  613   Order ID   [Execute Query].

    ࠭  Order 613.

3.   [Next Block].

     室   CLIENT DATA  祭 613   Order ID.

4.  [Execute Query].

   ⨬,  ଠ   Name , 祬  ᯫ.  
   ﭨ ⮡ࠦ  "<",   砫 ⥪饣 祭    
   稢    ࠭,   ⮡ࠦ  ">",     ⥪饣  
   祭   稢  ࠭.

5.    [Next Field], ⮡ ⠭    Name.
6.  [Right],    ⨣   .

    ப稢      ᨬ   ⨥.

7.  [Left].

    ६頥   ᨬ .

8.  [Scroll Left]  ᬮ 砫 .

   ⮡ࠦ     ᤢ , ⮡ࠦ ᮤঠ , 
   室襥  .

9.  [Scroll Right]  ᬮ  .

   ⮡ࠦ     ᤢ ࠢ, ⮡ࠦ ᮤঠ , 
   室襥  .


                                    -- 20 --
