


                                      5


                                 

    ⮩  뢠 ᪮쪮 ᯮᮡ 롮ન ᥩ, 㤮⢮-
 ।  .  ᫥ 믮 ࠦ ⮩     
㤥    ⮫쪮  ,   믮    , 㤮⢮騥 
। ,     ᫮   ,  ⢥騥 ᪮쪨 
᫮.  ⮩  㦤 ᫥騥 ⥬:
     - ࠢ  祭
     -  ⢠ ᫮
     - ᯮ짮 SQL ࠧ WHERE  ᯥ ᮢ

ࠢ   稭

   ।,  稪 , ⮡  ஢ਫ 業  थ.  
,  थ  饭 7 ﭢ 1987 .  Order ID - 610.  SQL*Forms  
    ,  ᮤন ⮫쪮  稭.

    ਢ ᭮ 蠣,  室      롮ન ᥩ,  
 ॡ㥬 稭:

 1.  [Next Block]  [Previous Block],    ⠭  
     ४権.
 2.  [Enter Query].
 3. ⠩ 稭,    ࠢ,   ᮮ⢥ 
    .
 4.  [Enter Query].
 5.  [Next Record]  [Previous Record]  ᬮ ࠭ 
    ᥩ.


ࠦ  1. ⠭    ORDERS.
            2.  [Enter Query].

             뢠 ⮡ࠦ .  ࠭ ᥩ
             룫拉,  ᫥騩 㭮.
              Ŀ
.5-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>     
              

                                    -- 21 --



               3.  610   Order ID.
               4.  [Enter Query].
                  SQL*Forms ⮡ࠦ ᮮ饭

                  Working...

                     ࠭, ⮬ ⮡ࠦ ଠ 
                  थ  610   ORDERS. (.5-2)

              Ŀ
.5-2                                                                 
थ 610               
                  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: 1                                 <Replace>     
              

       Order ID, Client ID, Order Date  Client Name  थ 
610. ⮡  ⮣ ⮢       ⮢  ,  
  室    थ 610   ITEMS.

 ࠦ    1.  [Next Block].
                  ⨬,        ।⥫쭮   
                  ᮤঠ   ITEMS.

               2.  [Clear Block].
                  ।騥  襭,    ᥩ    ORDERS 
                   ⥪騩 Order ID. (.5-3.)


















                                    -- 22 --



              Ŀ
.5-3                                                                 
             
                  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:                             <List><Replace>     
              

               3.  [Execute Query].
                  SQL*Forms 室 ,   610  Order ID
                   ⮡ࠦ    ITEMS.

              Ŀ
.5-4                                                                 
 㬬             
                  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>     
              

    Cࠢ  ࠧ殬
    --------------------
      , ᯮ 稭        , 
६⨢       祭.  SQL*Forms    뢠   
⮫쪮    ,   㤮⢮  ᪠, ।  
 .  ਬ, ᫨   SALESMAN  , 뢠 "Job",  0 
 , 뢠 "Commission",  롥 ,   "Job" -  
SALESMAN  "Commission" - 0.  ⠪     ,  祭  
  室    । ࠧ. ⮡ ᤥ ,  
祭  ,  "_" ।⠢  ᨬ,  "%" ।⠢  
 ᨬ (  ⢨ ᨬ).


                                    -- 23 --



騩   ᯨ᮪   ।⠢   ਬ   ᮯ⠢ ࠧ:

ࠧ        ᮯ⠢

JON_S         JONES,JONAS,JONOS,JONQS,JON-S,

S_AR_         SMART,SNARE,SHARE,SHARD,SHARP,SHARK

ENTER%        ENTER,ENTERS,ENTERED,ENTERTAIN

_IN%S         BINS,FINES,WINNERS,WINEMAKERS


 ⢠ ᫮
--------------------------
    ࠪ筮     祭,       
ᤥ  롮 ᥩ. ਬ,     ᫥饥:
     -    饩 㬬  $100
     -    Order ID, ࠢ 10  
     -  , 饭  

     筮 祭        । 祭 
,     , ५樮 .  .5-1  뢠,   
     ᯮ짮   ५樮  .  (  
ᨨ  ५樮    ᬮ  SQL  Language  Reference 
Manual.)

.5-1         祭              ਬ
祭     
ਬ       =          ࠢ                 ='SMITH'
५樮   !=          ࠢ              !=19.5
஢    >           祬            >100.00
              >=           ࠢ      >=2000
              <           祬            <'DAVIS'
              <=           ࠢ      <=100.00
              BETWEEN      .     BETWEEN 100 AND 110

              ਬ砭:   ⠡ 5-1  ࠡ  
              ६.

   ਬ, ⮡  , 騥  㬬 , 祬 $100,  
  [Enter Query]   > 100    ITEM TOTAL.  ( ">"  -  
५樮  , 騩  祬,  100 - 祭,   
 ࠢ.)   ᫨ SQL*Forms ஢ 祭,  ஥  
ᨬ쭮 ப (⠪  'SMITH'),  ᨬ ">" 㤥 롨 ,  
  ᫥ ᨬ쭮 ப  浪 䠢 (ਬ, THOMAS  
WILLIAMS).

ਬ砭: , ᮤঠ騥 ᨬ쭮 祭  ,   
祭   窨.    ᯮ ५樮 ,  
 ᫮ ( BETWEEN),   ⠢ ।  "#".

ਬ砭:  ᯮ -⥫    ,   易   
.





                                    -- 24 --



ᯮ짮 SQL ࠧ WHERE  ᯥ ᮢ
---------------------------------------------------
      믮 쭮  ᫮ ,      
祭      ५樮 ,     믮  
    ᫮ .   믮 ᯥ    
SQL ࠧ WHERE.  ࠧ WHERE     ࠧ , ᭮  
᫮, ⫨  筮 ᮯ⠢.

    ᯮ짮  WHERE      ६       
. ६,  㦨  ⢥ ⪨,  ।⢮ 
稥 (:). ⨢ ६   ,    ᨣ,    
 ࠧ WHERE, ᯮ  祭    ⮬  .   ᨬ 
 ६   㪢, ᫥騬 ᨬ   㪢, 
  ᯥ樠 ᨬ "_", "$"  "#".


।   饥  ࠦ  뢠,    ᯮ짮   ࠧ
       WHERE,  ⮡        ,  饭   5  25
祭      ﭢ.


 ࠦ
    1.  [Previous Block]  ࠧ, ⮡ ३    ORDERS.
    2.  [Enter Query].
          ࠭,  頥     ⮡ࠦ ࠭ ᥩ.

    3.  [Next Field], ⮡ ३    Order Date.
    4.  :DATE   Order Date.
         筮 祭 ( 05-JAN-87)   ६.  
       稥 (:) 㪠뢠,    ६,     ⭮ 
       祭.  ६       㪠  
       ࠧ WHERE.

    5.  [Enter Query].
       SQL*Forms ⮡ࠦ ⮢ Query Where  ஬, ⠭ 
         .     ᫮,   
       㤮⢮ 롨ࠥ .    ࠭  룫拉,  
       .5-5.





















                                    -- 25 --



.5-5       Ŀ
                                                              
                    
Query Where       O R D E R S                                           
                                                                        
                  Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                 Ŀ     
                                   Query Where                        
                                                                      
                 Criteria       
                                
                                                                      
                      
                                                                        
                     
                 Count:             ENTER QUERY           <Replace>     
              

               6.  :DATE BETWEEN '05-JAN-87' AND '25-JAN-87'

                   㪠 SQL*Forms,    㢨  , 
                      Order Date   5-   25-  ﭢ.  
                  (.5-6.) ᫨   訡,     
                  ,   ᯮ짮 [Delete Character]  
                  㭨⮦   ᨬ      ஬.       
                  ᯮ짮 [Right]  [Left]  ६饭    
                  ਧ⠫쭮  ࠢ   ᨬ.   ⮬ 
                    ᨬ ᢥ ࠢ쭮.

.5-6       Ŀ
                                                                
᫮                 
                  O R D E R S                                           
                                                                        
                  Order ID           Order Date               
                                                                        
                  ClientID      Client Name            
                                                                        
                 Ŀ     
                                   Query Where                        
                                                                      
                 CriteriaĿ     
                         DATE BETWEEN '05-JAN-87' AND '25-JAN-87'           
                                                                    
                         ٳ     
                      
                                                                        
                     
                 Count:             ENTER QUERY           <Replace>     
              

               7.  [Accept].




                                    -- 26 --



                  SQL*Forms 롨  थ, 饭  5-  25-
                  ﭢ.  ⮡  ᬮ       㣮,
                   [Next Record]  [Previous Record].

    ⢠ ᫮  

      ᯮ짮 ࠧ WHERE 室 ᫥騥 蠣:

1.  [Next Block],     ⠭   ४஢.
2.  [Enter Query].
3.  祭     ६ (⠪  :ID  :DATE).
4.  [Execute Query].
5.    Query Where  ᫮, ஬  
   㤮⢮ ࠭ .
6.  [Accept].
7.   [Next Record]    [Previous Record],  ⮡ ᬮ 
   ࠭ .


ᯮ짮  ।饬  ਬ         ࠧ   WHERE, ⮡
ࠧ WHERE   ।    祭,        
㣨       ࠭  .  (祭    Order Date   뫮
ᯮᮡ           05-JAN-87      25-JAN-87.)     5-2
              ।⠢ ⥫ ᯮᮡ ᯮ짮  
              ࠧ WHERE.

 5-2                                  ਬ
ᯮ짮 
      , 騥 祭:
ࠧ WHERE
                  祬 (>)                  :CLIENTID > 106
                   ࠢ (>=)           :ITEMTOT >= 100
                  祬 (<)                  :ORDERID < 305
                   ࠢ (<=)           :ITEMTOT <= 100
                 ࠢ (=)                       :CLIENTID = 106
                  ࠢ (!=)                   :NAME != 'SHAPE UP'


              ⠢ , ஬         (:CODE = 100860 OR
              㤮⢮    ᫮  :CODE = 100861)


              ⠢    ᫮ﬨ (:ORDERDATE =
                                                  '14-JUL-86') AND
                                                 (:CLIENTID = 106)

ᯮ짮            ᫮묨  ﬨ
᫮      ᪠,  祬  ᠭ  . ਬ,   
      ,   Client ID  ᫥騥 祭:
᪠
                   -   ᪮쪨 祭

                   - 107  Order ID , 祬 615 ( 祭
                       Client  ID Order ID   ,
                         Client ID  ࠢ 107   Order ID ,
                     祬 615.)



                                    -- 27 --



                   - 107  Order ID , 祬 615,  Order Date - 7-
                     ﭢ


 ਢ ᭮ 楤,  ᯮ  ᫮ ਩ ᪠:

   1.  [Enter Query].
   2.     砥      ६ ( ࠡ 
      㪢  ⪮ ᫮). ਬ,  :ID   Order ID  :N   
       Client Name.

   3.  [Execute Query], ⮡ ⮡ࠧ   Query Where.

   4.  ࠦ, ஥ 뢠 ਩ ᪠, ᯮ ⪨, 
      ᠭ  .2.

  ਬ:
      ਩ ᪠                     祭
      
      Order ID , 祬 615        :ID > 615 OR
      Client Name - JUST TENNIS          :N = 'JUST TENNIS'

      Order ID   ࠢ 615   :ID <= 615 OR
      Client Name 稢        :N like '%TENNIS'
      'TENNIS'

   5.  [Accept].  SQL*Forms      ᪨ 
      ࠦ  믮 .


⭮  ⮡  ⥪饬  ୮ ᯮ짮 ਩ ᪠
ᯮ짮 ।饣 ,  [Enter Query] : ⨥
        ࠧ  樨    ,   ୮ ⨥
᪠        ⮡ࠦ  ।騩  ਩   ᪠.       
              ᯮ짮 ⮡ࠦ ਩  ஢ ,
              ० 祬  [Execute Query].

              ᫨  ⠢ ⪨  -      ⮬ 
               [Enter Query], SQL*Forms  ⮡ࠧ  ⪨ 
              ⮬ ,  ஬   . ⮬   [Execute
              Query], ⮡ ⮡ࠧ ᫥ ⢥   
              Query Where.         ᯮ짮   ⢥,   
              [Next Field],   ।஢ ,  
              ६.


       ᫨      㧭, ᪮쪮 ᥩ ୥  ,
ᥩ       ०,  祬 ⢨⥫쭮 믮 ,  室
       ᯮ짮 [Count Query Hits].  ᭮ 楤 
                ⢠   ᥩ,   㤮⢮ 
              ᪠:

 1.  [Enter Query].
 2.  ਩ ᪠.
 3.  [Count Query Hits].

    SQL*Forms 뢠 ,    㤮⢮  ᪠,  
    ⮡ࠦ  ⢮  ப ᮮ饭.

                                    -- 28 --



    ⨬,           [Count Query Hits]  [Execute Query]. 
      ᯮ짮  ,   㣨, ⮡   
     .

᫥  [Count Query Hits]    ᫥騥 樨:

     -  [Execute Query], ⮡ 믮 .
     -  㣮 ਩ ᪠.
     -  [Exit/Cancel],  ⮡      ० Enter Query  
       믮 .

ᯮ짮   ,         ७
ࠧ WHERE   ,   ᯮ짮    SQL . ( 
 ⢮  SQL  Language  Reference  Manual.)  SQL*Forms ন
᫮         ࠧ SELECT,   ᪫祭 ࠧ GROUP BY 
              CONNECT BY.

ᯮ SQL,    ࠧ WHERE   ᪮쪨 ᫮ﬨ:

 1.  [Enter Query], ⥬  ६ :ORDER   Order ID  
      ६ :CLIENT     Client ID.

 2.  [Execute Query]  ,  ⮢ Query Where, ᫥饥 
    ᫮:

    :ORDER > 500 AND :CLIENT < 110 ORDER BY :CLIENT

   SQL ⢥ত 㤥 롨  ,   Order ID   
500    ⮬ Client ID  110.    㯮冷祭  Client ID.
             6


                  

              


     ,   ᯮ짮  SQL*Forms  䨪樨  
    .   祭       ,  ..     
  㤥  ᯮ짮 SQL*Forms         ᥩ    
          ᥩ.   ⮩   
ᬠਢ  ᫥騥  ⥬:
   - , ⠢  㤠 ᨬ
   -  
   - 㤠 ଠ樨   
   - ᮧ ᥩ

        ⠢ ,   㤠 ᨬ

SQL*Forms    ᨬ , ᯮ    ०:

 1.  ⠢
      ⠭  ०  ⠢,     ᨬ,     
    ,       .  騩  ᨬ   ஬    
    ᫥騥  ᨬ ᤢ ࠢ.




                                    -- 29 --



 2.  
      ⠭ ० ,   ᨬ,    , 
     ᨬ   ஬.    ஬  ᤢ.

  ४ ० ⠢   ⨥ [Insert/Replase]. -
 ० ⠥ ⨢    ,       
⨥ ⮩  ( ﭨ ⮡ࠦ ⥪ ). ⮡ 㤠 
ᨬ, ⠭     ᨬ   [Delete Character]. 
[Delete Character]  室 ࠧ   ० ⠢, ⠪   
० .  (    室    ᫥  ᨬ   , 
[Delete Character]      ⢨). ᫨    㦭 㤠 ᨬ 
।  ஬,   [Delete Backward].


        ⠢  㤠 

             ᬮ ଠ樨,   
  ᮤঠ;   㣨       ଠ.

।,   Shape Up     थ 615.    
  थ  SP Junior Rackets ( 101863).

   ࠦ
1.    ⮬,       ⠭     Orders.
2.   [Enter Qwery].
3.  615   Order ID.
4.  [Execute Qwery].
   SQL*Forms 롨ࠥ  थ 615.

5.  [Next Block]  ६饭   ITEMS.
6.   [Clear Block], ⮡    ,  ⠫  
   ᫥ .
     祭, ⮡ࠦ饥    Order ID -    ⥪饣  
   थ 615.  祭,  㬮砭, 頥    ஬   
   ⮬᪨.

7.  [Execute Query].
   SQL*Forms  롨ࠥ        ,   ⠢ थ 
   615.  ࠭  룫拉 ᥩ   .6-1.

.6-1       Ŀ
थ 615                                                               
                        
                  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       
                      ͻ  ͻ  ͻ  ͻ  ͻ  ͻ          
                                                            
                      ͼ  ͼ  ͼ  ͼ  ͼ  ͼ          
                                                                        
                                                                        
                       

                                    -- 30 --



                 Count: 3                          <List><Replace>      
                                                                        
              

, ᫨      ࠭  ࠢ쭮  ⮡ࠦ थ,      
  ந  ,  襭 ⮬. ,   Shape  
Up    㣨       थ.

  ࠦ
1.  [Next Record], ⮡ ३    祭 2   Item No.
2.  [Clear Record].
         2   ࠭ (       )    
   ᢮          थ   4.

3.  [Next Record]  室    ᫥ .
   SQL*Forms ⮡ࠦ 615  祭   㬮砭  Order ID.
4.  [Next Field]   ६饭     Item No.
5.   4      Item No   [Next Field].
6.   10186     Code     [Next Field].
   SQL*Forms  ⮡ࠦ  ᮮ饭:

   FRM-40203: Field must be entered completely.
     Code -   ਬ     䨪஢  .  ..   
   䨪樮    த  ᮤঠ   ,   
     ।,              Code, ᫨    
      ⨧ . (. . 6-2).

.6-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                                <Replace>      
                                                                        
              

8.  12.50  Act.Price   [Next Field].
9.   5    Quantity   [Next Field].

     ⮫쪮      ३      Item Total, SQL*Forms  
       ⮡ࠦ    㬬     .   
     ⠢  SQL*Forms 㬭  祭      Act.Price    
   祭       Quantity.   ⮡ࠦ  Item Total,  
     室    ( C. . 6-3 ).


                                    -- 31 --



. 6-3      Ŀ
 㬬                                                             
                        
                  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                                <Replace>      
                                                                        
              

             .       
         塞.  饥 ࠦ  뢠,  
 ந室,     ⠥  塞 .

  ࠦ
1.  [Previous Block]  室   ORDERS.

2. ⠩  -    ORDER ID.
   SQL*Forms ⮡ࠦ ᮮ饭:

   FRM-40200 :Field is protekted against updata.

    ᤥ   塞, ⮡  뫨 饭  砩  
 䨪樮   थ. Order ID -  ᮡ 稭, 
⮫쪮 १  ଠ  ⠡  ORD 뢠   ଠ樥    
⠡ ITEM.  饭  訡 祧,     .


         ଠ樨   .

㣮  ᯮᮡ   ஢  ᮤঠ     - -   㤠 
楫  ᥩ. ਬ,    ᤥ -  ᫥饣:
   - 㤠    थ
   - ⬥ थ 
   - 㤠    

।,   Shape Up 訫 ⬥ ᢮ थ  Sp  Juniour Rackets  
(Code  101863). 饥  ࠦ 뢠  ,   㤠   
 . ( ⠪ ⠭ 砫   .)

  ࠦ 
1. ,   室   ITEMS.
2. ,   ⠭    Item 4.
3.  [Delete Record]  㤠   4.



                                    -- 32 --



                   ࠭  룫拉  . 6-4 .
. 6-4      Ŀ
                                                                
                  
                  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>      
                                                                        
              

 4.  [Commit], ⮡ 믮 㤠.
    SQL*Forms ࠦ ᮮ饭:

    Transaction completed -- 1 records processed.

     Code 101863 㭨⮦, ਣ쭠   ( ode 100863 - 
the Ace Tennis Racket IIs) -    . ᯮ,    㭨⮦
,   ⨫     [Clear Reckord]. ⮡ ஢,  
 ਣ쭠           ,   ,    
⮫쪮  㤠, 祧, थ ᫥饥 ࠦ.

  ࠦ
 1. ,      ⠭      Order ID   ITEMS.
 2.  [Execute Qwery].
      㪠뢠  SQL*Forms      ITEMS  ,    Order ID  
    ࠢ  615.

    SQL*Forms  롨          .  ਣ쭠  ,  
         ⨫,   㭨⮦,       .

 3.  [Clear Form/Rollback], ⮡    ᫥饣 
    ࠦ.

 祭 ,  [Clear Record] 㡨ࠥ   ࠡ祩  
, ⠢     . [Delete Record] 㤠     
 ࠧ ᫥    [Commit].










                                    -- 33 --




          ᥩ

     ࠧ,   Summit Sporting Goods  砥  㣮 थ,   
室         ।,  祭  
 थ   Just Tennis  Norhside Mall. (. . 6-5). 
 室     थ      .      
     , 뢠  ᫥饥  ࠦ.

. 6-5        Ŀ
थ            SUMMIT SPORTING GOODS - ORDER FORM      Order No.____ 
Just Tennis                                                              
                   Client Name ______________________      Client ID ___ 
                   Address __________________________      Date ________ 
                           __________________________      Phone _______ 
                                                                         
                Ĵ
                   Item                Product ID   Price    QTY   Total 
                Ĵ
                Ĵ
                Ĵ
                Ĵ
                Ĵ
                Ĵ
                Ĵ
                                                      Order Total ______ 
                

    ࢠ  थ ᮤন ᭮  ଠ   
 ORDERS   थ.      ORDERS 室 ᫥騥
              蠣.

  ࠦ
1. ⠭    ORDERS   [Clear Block].

2.  622   Order ID   [Next Field].

   ⨬,   Order Date  ᥣ譥 ⮩.  ᫮, 
    ᯥ稢 ஬ . ..     थ      
     ᠬ  ,    稫,   㦭  .

3.  [Next Field], ⮡ ਭ 祭  Order Date  ६ 
      lient ID.    諨   Client ID,     
   cﭨ     List  ।⢥   ᫥  
   Insert/Replace.   ᯥ ᯨ᮪ 祭      
     , ⮡  ⮬       室饥   祭.

4.   [List].  ᮪ 祭      ᯫ뢠饥   
   (. .6-6). ⮡  ன   ᯨ IDs       , 
   ᯮ  [Up]  [Down].

. 6-6      Ŀ
᮪                                                                  
祭               
ᯫ뢠饬       O R D E R S                                           
              Order ID           Order Date               
                                                                        
                  ClientID      Client Name            

                                    -- 34 --



                            Ŀ        
                  Ĵ            ORDID                       
                  I T E M S                                           
                             Find:          
                    OrderID Ĵ        
                      ͻ QUERY MOUNTAIN                104        
                          JOCKS PORTS                   100        
                      ͼ JUST TENNIS                   103        
                            K + T SPORTS                  105        
                            NORTH WOODS HEALTH            108        
                            SCOTT'S SPORTING GOODS        110        
                            SHAPK UP                      106        
                                    
                       
                 Count: 6                          <List><Replace>      
                                                                        
              

 5.  just  室   ᯨ᪠ 祭    [List]   
    [Next Field].

    ⨬,   "Just Tennis" - ⢥  , ஥ .

 6.  [Select].
    "Just Tennis"       Client  Name,    "103"  
      Client ID. . . 6-7.

ਬ砭:    ᤥ      ᥬ  , ⮡࠭   
            ᯨ᮪ 祭.






























                                    -- 35 --




. 6-7      Ŀ
                                                              
 ORDERS            
                  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: 6                                <Replace>      
                                                                        
              

㣨          ⠪    ᮧ  ,  ६⨢    
⮤        ⮩  "",  ᫥饩    ᫥   ⮡ࠦ
    ,       ⠬  祭  .  ⮡  
ᥩ       ࠧ  ᪮쪮 ᥩ,  [Insert Record]
               [Next Record] ᫥ ⮣    訫   
                .

᫨  砫           ,  [Clear 
Record].

     ᥩ  ᯮ  [Duplicate Record]    
[Duplicate Field]. [Duplicate Record]         ।饩  
      ; [Duplicate  Field ]    ⮫쪮  ⥪饥  
. ᫥  ⮩  㣮   ஢ 祭 , 
஥  ᪮஢.


      ITEMS -   ,         
 ITEMS   ଠ        .  饥  ࠦ
              ᪠       믮.

  ࠦ
 1.  [Next Block], ⮡  ३  ITEMS .
      थ, 622,   㬮砭   ORDER ID.

 2. ਭ  थ,  [Next Field].

 3.    ,     ⠡ .  ᫥   
      [Next Field]. ⮡   ,  [Next Record]
     1
               祭
    
    Item No        1



                                    -- 36 --



    Code           100860
    Act. Price     35
    Quantity       7

     2
               祭
    
    Item No.       2
    Code           100870
    Act.Price      2.80
    Quantity       12

     3
               祭
    
    Item No.       3
    Code           100890
    Act. Price     58
    Quantity       3

 ࠭   룫拉  ᥩ  .6-8.    ,  
  뫨   Quantity   [Next Field],     뫮  
᫥  祭  Item  Total.  ࠢ ⮩ 稭    थ 
த  ஫஢ 筮 थ.

. 6-8      Ŀ
                                                              
 ITEMS             
                  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: 6                                <Replace>      
                                                                        
              

     CLIENT DATA  cন ଠ,⭮  ,
         饬  थ,  ⠪  ,    .. 믮
CLIENT DATA   ᫥饥 ࠦ    CLIENT DATA.

 ࠦ
1.  [Next Block]   室   CLIENT DATA  ⥬  
   [Clear Block].

 ⨬,  ID - , 103, ⮬᪨    Client ID.



                                    -- 37 --



2.  [Next Field].
3.  JUST TENNIS   lient Name   [Next Field].
4.  NORTHSIDE MALL  Address, ⥬  [Next Field].
5.  BURLINGAME  City   [Next Field].
6.   - 묨 㪢   State.

   ⨬,     ࠫ  쪨  㪢, SQL*Forms  
      㪢.  ந室 ⮬,    
   ᪮஢      㪢.

    祭,  ⮫쪮   ࠫ ॢ  ,     
   ⮬᪨  室  ᫥饬 ,      [Next 
   Field].  ᪮஢ State  ⮬᪨ ய᪠饥 
   .   ⮫쪮   ࠢ쭮 ⢮  ᨬ  ,  
   ⮬᪨  ३    ᫥饬  .  ⢮ ⮬᪮ 
   ய᪠  ࠡ⠥ ⮫쪮 ⮣,      稭 
     ⮩  .

   ,        Zip,  ⨬,   SQL*Forms ⮬᪨ 
   ⮡ࠧ ࠢ筮 ᮮ饭:

   Enter the 9-digit ZIP code, if available.

         -        ⮬᪨  
   ⮡ࠦ ࠢ筮 ᮮ饭  ࠧ,    । 
   . (. . 6-9.)

. 6-9      Ŀ
⮬-            
 ࠢ       C L I E N T  D A T A                                  
  ZIP                                                            
                 Client ID                                        
                                                                        
                      Name                
                                                                        
                   Address                
                                                                        
                      City                            
                                                                        
                     State   Zip                                
                                                                        
                     Phone                                     
                                                                        
                    Credit                                        
                                                                        
                   Comment                
                                                                        
                     
                 Count: 6                                  <Replace>    
              

 7.  97544   Zip   [Next Field].
 8.  415  ᥪ樨    Phone.

    ⨬,   ᥪ      -  ⢨⥫쭮 ⤥쭮  .  
        ⠪     ᢮⢮ ⮬᪮   ய᪠, ⮬ 
      ᥩ -  ᥪ樨  ⥫䮭  Phone.


                                    -- 38 --



 9.  677-9312      ⥫䮭     [Next Field].

10.  3000    Credit Limit.       ࠭  
    룫拉  . 6-10.

. 6-10     Ŀ
襭              
        C L I E N T  D A T A                                  
CLIENT DATA                                                             
                 Client ID                                        
                                                                        
                      Name                
                                                                        
                   Address                
                                                                        
                      City                            
                                                                        
                     State   Zip                                
                                                                        
                     Phone                                     
                                                                        
                    Credit                                        
                                                                        
                   Comment                
                                                                        
                     
                 Count: 6                                  <Replace>    
              

                ᫥饬  ࠦ          थ
              ਨ.

       ਥ    LIENT DATA  믮
ਥ  ᫥騥 蠣:
 
CLIENT DATA    1. ,     Comments.
               2.  [Edit]   맮  ।  .   ࠭
                   ᯫ뢠饥  Edit (. . 6-11).

.6-11      Ŀ
ᯫ뢠饥             
 Edit         C L I E N T  D A T A                                  
                                                                        
                 Client ID                                        
                                                                        
                      Name                
                                                                        
                   Address                
                                                                        
                      City                            
                                                                        
                     State   Zip                                
                      Ŀ         
                     P           
                    Cr           
                   Com           
                               
                                                                        

                                    -- 39 --



                     
                 Count: 6                                  <Replace>    
              

 3.  ᫥饥 ।:
    ..  ਩ 㤥      Comment  ࠧ,  
    뢠  ,       ଠ  
    .   ࠢ  ७ ⮫쪮  ࠭ । 
    ᯮ , 㯭 ⮫쪮  ।    ᯫ뢠 . 
    (. ᠭ   ਫ .)

 4.   [Beginning of line]    ६饭    砫 .
 5.  [Delete Line], ⮡  ᯫ뢠饥 .
 6.    ᫥騩 ⥪:
    The JUST TENNIS account.....

    ,  ४㥬   ,  ⢨⥫
     ⭮  砫 . ⮬  室 ᢮ 
        ⥪,  ⮬  㤠   ⠢ 㤠 .

 7.  [First Line], ⮡ ६   砫 ⥪.
 8. ⠢   砫 ⥪ ⨥  Return.    ࠧ,  
    㤥  ᮧ       砫 ⥪.
 9.   [Last Line]    室      ⥪  ᯫ뢠饬 .

10.    3  .  [Select].
11.    ᫥ 8  ;  [Cut].
12.    [First Line],  ⮬  [Paste].   室  
    ࢮ   ᯫ뢠饣  ,    . 6-12.

. 6-12     Ŀ
믮              
।஢-      C L I E N T  D A T A                                  
 ᯫ뢠-                                                            
饣        Client ID                                        
                                                                        
                      Name                
                                                                        
                   Address                
                                                                        
                      City                            
                                                                        
                     State   Zip                                
                      Ŀ         
                     P           
                    Cr           
                   Com           
                               
                                                                        
                     
                 Count: 6                                  <Replace>    
              

13.   [Edit]  [Accept], ⮡ 㤠  ।.

14.  [Exit/Cancel]  ⢥ "No"    ⢥ত ⮢.    
    易⥫쭮     , ⮬     ⮫쪮   訫  
    믮  ࠦ ⮣ 㪮⢠.

                                    -- 40 --



    SQL*Forms     ⥬ .


























































                                    -- 41 --




             7                      S Q L * F o r m s

  ᮤন  ଠ    ᯮᮡ  믮 SQL*Forms, ᮡ  
६ ᮢ襭  ࠭権    .  ⮩    ᠭ 
᫥ ᮢ:
    - ᮢ襭 ࠭樨
    - ᢥ뢠 ࠭樨 
    - ᯮ ⮬᪮ ࠭ 

C襭 ࠭樨

  ࠡ⠥  ମ, 䨪樨,      ⠡  
,    뢠 ।⢥   ; ᪮॥,   
뢠    ࠡ  .  ⮡  ⢨⥫쭮  ᤥ    
䨪樨,    । ᮤন  ࠡ祩      ,  
 [Commit]. ᫥  ⮩ 㭪樮쭮    ࠡ祩 
 뢠  ⠡. ⨬,  [Commit]    
  ⮫쪮  ⥪饣 ,      ⥪饩 .

⨬,   ६  ࠭  ଠ樨    襩 ࠡ祩   㣨  
짮⥫ ORACLE     㢨.  ⮬, ᫨ 㣮 짮⥫ 
뢠 ப ᫥ ⮣,   ஢ ,   ⮣,    
।,  㢨 ஢  ப.

⮢     樨    SQL*Forms        
 ।    䨪樨   ०,  祬    ᬮ  த  ࠡ.
        ਬ, ᫨  ஢ ⥪騩 ,   ।
              䨪樨  , SQL*Forms  ⨨   [Enter Query]
              ⮡ࠧ  ⮢ (.. 7-1).

. 7-1      Ŀ
⮢              
 ।        C L I E N T  D A T A                                  
                                                                  
                 Client ID                                        
                                                                        
                      Name                
                       Ŀ        
                  Addre                                               
                         CAUTION                                      
                  City                                                
                          Do you want to commit the changes           
                  State           you have made?                      
                                                                      
                  Phone                                               
                               <Yes>    <No>   <Cancel>               
                                                                      
                  Credi        
                                                                        
                  Comment                 
                                                                        
                     
                 Count: 6                                  <Replace>    
              




                                    -- 42 --



 [Next Field]           ⢥, ⥬  
[Select], ⮡  . ᫨  ⢥ "Yes", SQL*Forms ᮢ -
 䨪樨  ⥪饣 .  ⮬,     砥, SQL*Forms  
室   ॡ㥬  ⢨. ,᫨  ⢥ "Cancel", 
SQL*Forms      ,   뫨,  ᮢ襭  
 .

騥 樨 ᪠  ⢨    ᠭ   樨, ᫨ 
室 ᮢ - :
   - [Enter Query]
   - [Execute Query]
   - [Exit/Cancel]
   - [Clear block]
   - [Clear Form/Rollback]
   - [Count Query Hits]

⨬,  ଠ   ᪮஢ ⠪, ⮡ 믮 । 
   ६,        㢥   ⮬.

஫        ६ ।  ଠ    ࠧ묨  ᯮᮡ
ࠢ쭮  ஫஢  ࠢ쭮  . ,    ஫
      ᠥ  ⮫쪮  痢    ᥩ,  
६       .
।

஫ ࠢ쭮, 믮塞  ६ । ,  :
   - ஫  㭨쭮.    ஫  ।頥     
       ப  ⠡    묨 祭ﬨ   . ਬ, 
       ।०   ᥩ  묨 ६ थ.

   - ஫ ᫥⥫쭮. ஫ ᫥⥫쭮, ਬ,   
       ࠭஢,    㬬  ⤥ ⮢  थ 㤥 
     ᮮ⢥⢮ 饬 祭 थ.

᫨ 訡 㦥,  SQL*Forms  ⮡ࠦ  ᮮ饭, ନ饥    
  訡.    ᮮ饭     ⠭ ᮮ饭  SQL*Forms, 
 ᮮ饭, ᤥ ஬ . , SQL*Forms ६  
   ,  뫠 દ 訡.

ਬ砭: ᫨  -      ࠡ祩    諠 ⮫  
ࠢ쭮,   ஢     । ; 祣  
।  ࠡ祩 .   ࠢ 訡  ᤥ । 
.

        뢠 ࠭樨 

⮡  ᮤন ࠡ祩 ,    믮 ᢥ뢠  
, ⥬   [Clear Form/Rollback]. ,  ᫨  ᮢ訫  
࠭   , [Clear Form/Rollback]   ⬥.

        ᯮ짮 ⮬᪮ ࠭ 

   SQL*Forms ᯥ稢  ⮬᪮ ࠭   ⮣, ⮡  
।    ⮩        ६    
짮⥫ﬨ.     ⠥    , SQL*Forms  ।, 
뫠     㭨⮦ 㣨  짮⥫  ᫥ ⮣,   
 ᤥ 롮    ᮬ. ᫨  뫠   㭨⮦-
,    믮   ⮣, ⮡ 㢨  ࠡ   

                                    -- 43 --



ࠢ . , ᫨     뫠  , SQL*Forms 
  ⠪,  㣮  짮⥫   ᬮ  ஢  
 ६,    .

 । ⥫⢠      ࠭, 
祬  ᤥ ⮬᪨. (ଥ,     थ  ६  
䨪樨  ⮢.) ᫨   室,  [Lock Record].




















































                                    -- 44 --
