



                                             SQL*Forms Designer's

                    Tutorial

       Version 3.0 Part No.3302-V3.0 0789

            ⥫ ࠡ稪
                                                  SQL*Forms      ORACLE

                         ⥬ ࠢ 樮 
















































                                    -- 1 --




                           

⥫ ࠡ稪  SQL*Forms -     㬥⮢ 
SQL*Forms ᨨ 3.0. । ᯮ짮  㬥, 
室   ᫥騬 ࠧ :
      *  㬥樨  SQL*Forms
      *  

  㬥樨
               㬥樨  SQL*Forms  ᨨ 3.0 ⮨ 
              ⥬  ࠡ稪  ᫥  㬥⮢:

 * 㪮⢮   SQL*Forms,  3.0,
        Oracle Part No.3301-V3.0 0789
 * ⥫ ࠡ稪  SQL*Forms,  3.0,
        Oracle Part No.3302-V3.0 0789
 * ࠢ筨 ࠡ稪  SQL*Forms,  3.0,
        Oracle Part No.3304-V3.0 0789
 * ⪨ ࠢ筨  SQL*Forms, 3.0,
        Oracle Part No.3704-V3.0 0789
 * ⪨ ࠢ筨 ࠡ稪  SQL*Forms,  3.0,  Oracle Part
        No.3302-V3.0 0789

      㬥 ⠭  ࠧ 㯯 짮⥫.     ᫥饩
  ⠡ ਢ 祭 㬥⮢     SQL*Forms; ᭮ 㤨,
     ⠭;  ,     室 ।⥫쭮 .

         㬥  ᭮       ।⥫쭮
                   㤨      ⥭      
  
  砭:      ࠧࠡ稪 ਫ ᯮ  3.0      
  SQL*Forms, ⮬  室   ᫥騬 㬥⠬:
    * ࠢ筮 㪮⢮   SQL,  6.0, ORACLE Part No.778-V6.0
    * 㪮⢮  ࠢ筨 짮⥫  PL/SQL, 1.0
      ORACLE Part No.800-V1.0
    * 㪮⢮  ⠭  짮⥫  襩 樮 ⥬.


          

       㪮⢮    SQL*Forms  窨 ७ ࠧࠡ稪
   ਫ.   砥,     ᥬ ⮭ﬨ
   SQL*Forms,   㧭 ᭮ 楯樨  楤.  ⥫
    SQL*Forms  ,  ᮧ -ਬ,  ,
   ᯮ짮 ਣ  쭥襣    襭 .

   ᭮    

    
      1 ਢ 業਩  楫 ᠬ⥫  ᫥⥫쭮
 蠣,   室  ࠧࠡ⪥ .

               2  ନ SQL*Forms,
    室      䥩   ६ 
              ࠭.   ⠪ 祭 -ਬ,  



                                    -- 2 --



            ᭮ ᠬ⥫, ⠡-ਬ ᯮ㥬 ⨬ ଠ,
             ⮢⥫ ⢨, 室  ᯮ짮 ᠬ-
            ⥫.   짮⥫    2.

          3 뢠,  ᮧ  
            ⥩, ᯮ ⭮襭 "᭮-⠫".  -
              ,  ࠭ , ⥬ ᪠   ஢.

          4 뢠,    
           ६ 騥       ଥ.
                ⥬  ᯮ 祭 ਠ  襭
                來 .

    ।    5 뢠,  ᯮ짮
      ⠡      ஢ન ਡ-
                 ⮢ ,   ଠ ᮪.   ⠪ 㤥
                  .

ਣ      6 뢠,  ᮧ ਣ,  ஫-
              .  ⠪  ᬮ , ⮬᪨
            ᮧ  ⭮襭 "᭮-⠫",  ਬ 㣨
            ⨯ ਣ஢,  楤   SQL  PL/SQL.

                          ঠ
          1

 ⠪ SQL*Forms
   䥪⨢ ஢
   ࠭祭 
    ⥪
     ॠ஢    ॡ⥩

᭥ ᭮ SQL*Forms ......................
   ନ   .......................................
   ନ SQL*Forms .........................................
   襭   ꥪ⮢ .......................
 Forms ⠭   ⠡栬 ORACLE
 ꥪ⮢ SQL*Forms .....................

          2
  㤥    ᠬ⥫
। ⥬   .
   襭  ⨯䨨 .......
   祭  ..............
   -ਬ ..................
   ⠭ ......................
   ᮡ  ⥬ .....
樨 ᠬ⥫
   業਩
   
   

          3
  .......
 SQL*Forms .....
   祭  ...............
     .................
  ......

                                    -- 3 --



    ᭮  ...
    쥣  ........
࠭, 믮,  ஢ 
   ࠭  ...................
     믮  .......
   ஢  .................
⪮  :  

          4
  .......................
ࠢ ITEMS  ...............
   ८।   .
襭   .......................
       ८। 浪 
 ORDERS  .....................
   ᮢ   ।   ...........
஢  .........................
⪮  :   ...

          5
।    ..................
 , ᯮ ⠡ ࠬ஢
     ITEMS ...............................
     CUSTOMERS ...........................
 , ᯮ  .............
     ORDERS ..............................
             ITEMS .......................
             CUSTOMERS  ᯫ뢠饩 ࠭ ...
           ஢  ................................
           ⪮  : ।   

             6
            ਣ ......................
            ᭮ ਣ஢ ..............
   ⢨ ...............................
            뢮 易  ........

   祭 ਣ- Customer ID .......
   楤  PL/SQL ................
   ࠢ騥  .......................
   祭 ਣ- Product ID ........
   뢮 ⥪饩 業 .....................

⮬᪮ ᫥ ⮣
   祭 ਣ- Quantity
   祭 ਣ- Quantity Revised
   祭 ਣ- Actual Price

 ⥬ ᮮ饭
   祭 ਣ- Key-STARTUP
           ᬮ ⭮襭 '᭮-⠫'
           ⪮  : ਣ







                                    -- 4 --




    1       

             SQL*Forms   २⢠,
    ।⠢ SQL*Forms  ࠧࠡ⪥ .   ⠪
  ।⠢ ନ  楯樨 易  ORACLE RDBMS  SQL*Forms,
  室   ᯥ譮  ᠬ⥫.  
  ᮤন ᫥饥:
       *  ⠪ SQL*Forms
       *  ᭮ SQL*Forms
       *  SQL*Forms 뢠  ⠡栬 ORACLE
       *  ꥪ⮢ SQL*Forms

   ⠪ SQL*Forms

   SQL*Forms    ᮧ -ਫ  ,
  ᮢ, ४஢  㤠 .  ᠭ ணࠬ, 
  㪠뢠,   室 ᤥ, ᯮ   , ⠡
  ࠬ஢   ࠭ ।. ⥬ SQL*Forms ꥤ  -
    ଠ樥  ᫮  ORACLE  樨 襣 த.

    䥪⨢ ஢

   楤 室 SQL*Forms   䥪⨢ -
  ஢  ਫ. ஢   ࠧࠡ뢠 
  ਫ, ..   'ந'.   蠥 ஥,  㪠
     SQL*Forms ᤥ  ⮬᪨.  ࠡ  SQL*Forms
   ।稢 ᢮   ஥஢  ணࠬ஢.

   ࠭祭 
  SQL*Forms 蠥 ᫮ ஡,   ᯮ몠  த
  ⢥⮣ .    ᮧ 室 ਫ,
  ᯮ ,   SQL*Forms.

     ⥪
  SQL*Forms ।⠢  訥  ।⢮ ⮩
  ⥪,    ணࠬ ᠭ  COBOL, C 
  㣨 몠 ணࠬ஢, ⠪    魮 몥 PL/SQL. ⮬,
    ࠡ뢠 ଠ  㤮  ᯮᮡ.

    ॠ஢    ॡ⥩
    SQL*Forms    ॠ஢  騥 ॡ.
  "७ன"  SQL*Forms-ਫ ᮢ蠥  ,  
  .  楤ୠ  SQL*Forms   ORACLE RDMS
  ࠭  ᯥ.

    ᭥ ᭮ SQL*Forms
  ⮡ 䥪⨢ ᯮ짮  ᠬ⥫,  室 
   ᭮ ନ.

    ନ             㭮 1-1  ନ   ப.
    㭮 1    -ਬ
  Ŀ
                                                                            
   Ŀ                                                    
        Ŀ                                                          
                                                                            
            ORDID  ITEMID   PRODID  ACTUALPRICE    QTY ITEMTOT              

                                    -- 5 --



          ------- -------  -------  ----------- ------ -------              
              610       3   100890           58      1      58              
              611       1   100861           45      1      45              
              612       1   100860           30    100    3000              
              601       1   200376          2.4      1     2.4              
  [    602       1   100870          2.8     20      56  ]           
              604       1   100861           58      3     174              
              604       2   100860           42      2      84              
              603       3   100860           44     10     440              
              610       2   100860           56      4     224              
                                                                  
  
                   
                 1)  ᮤঠ騥    ⠡.
                 2) ⨪쭠 ''  ⠡. . 1.

        ⠡, ࠢ塞  ᫮६ .
    짮⥫ ORACLE 믮騩 㭪樨
       ஢.  ।⠢  蠥
  ()          짮⥫ 㯠  ⥬,  ࠬ ORACLE,
                    ࠡ   짮⥫  믮
                 㣨 㭪樨 ஢.

  ஢
  ࠭祭, ஥ ᢠ '६ '   (ਬ:
  ⠡  ப) 짮⥫.  ஢  ।࠭
   㯠    㣨 짮⥫ﬨ,   ,
    ४ 짮⥫.

   ࢨ 
     筮 騥  ப ⠡. ᫨
   ࠧࠡ뢠  ࠡ  㭨 箬, 樨 ஢
     ᮢ襭, ᫨  ப ᮮ⢥饩 ⠡ 
   祭  ࢨ筮 .

  ப    1)    ⠡.
            2) ਧ⠫쭠 ப   ⠡.   1-1.

  SQL
      宦  ᪨,  ।祭  ⢥
    ᭮ 짮⥫᪮ 䥩 ORACLE    롮ન
    ଠ樨   . SQL- ஭  "Structured Query Language".

  
    ᭮  ଠ樨  RDBMS. -   ࠧୠ '⪠',
      ப  ⮫殢.   1-1.

  ࠭
     ⭠  ନ   ᪠  ࠡ. ࠭ 
        ᪮쪨 । SQL. ࠭ 稭
       祭 짮⥫   ,    訫
    । ࠭. ࠭ 蠥,    ᮢ
    ⫮   ᮢ蠥 ⪠,   짮⥫
    ⪫砥  .





                                    -- 6 --



  ନ
        㭪 1-2  1-2   ᭮ ନ, SQL*Forms
            1-2
          Ŀ
࠭ 1        
ਬ             O R D E R S                                           
                                                                     
                                                                   Ŀ   
-        Order ID                   Order Date       
  ĳ                                                         
      |  Client ID            Client Name      
                                                                      
                                                                          
                 
            I T E M S                                                     
                                                                          
                                                                     - 
-           Order ID Item No. Code Act. Price Quantity Item Total  
                
ĳĳ         
                        
                        
                                                                      
                                                                          
                 
              Count: *0                                        <Replace>  
          

   1-3
            Ŀ
  ࠭ 2         
  ਬ                  C L I E N T   D A T A                            
                                                                       
                                                                            
ﭭ ĳ>                    Client ID              
⥪                                                                       
                              Name    
                                                                            
                           Address    
                                                                            
                              City            
                                                                            
                             State                 Zip         
                                                                            
                            Phone <>                         
                                        ^                                   
 ĳ                           
                     Credit Limit                              
                                                                            
                   
                 Count: *0                                       <Replace>  
            

   ਫ
         , , ⮢  㣨 ,   㤮⢮
        ᪨ 㭪.  ਬ,    ந ਫ 
        㦨 ⥬  .


                                    -- 7 --



    ⠡     ,  ன  .

       , ஥ ᮮ⢥    ⠡
           ,  ᯮ  .
               , ன 筮 ᮮ⢥  ⠡
                  .  ᮤন 㯯 易 ,
                  ᯮ    ᪮쪨 ࠭.

   ﭭ 
                  , ६ 騩  ६ 믮
                  .    ⥪  ࠭ ।,
                    , ४⨢  䨪.    1-3.

   ⥪
            뢠,   ଠ樨      
     ।⢮   SQL*Forms.   SQL*Forms ⠭ ⥪
     ᢥ   娨 ꥪ⮢.  砥,  SQL*Forms 
      ⥪⮬ ,  ⮣    ᬮ ⠭ ⥪
     ,  .. ( ' ꥪ⮢ SQL*Forms'    )

   ⠫ 
     ,  ꥤ  ᭮   ⭮襭 ᭮-⠫-
     . ⠫  뢠 '⠫'  樨஢  ᭮-
     묨 ﬨ   .

   
     ᢥ祭  ભ  ࠭,  ன  뢮-
        㤠 ஬  .  筮 ᮮ⢥
        ⠡ .   1-3.

   ଠ
     ।⢮ ࠡ⪨ ଠ樨, 饥  ⮣  㤥 ࠡ -
         㤥  .    ᪠ SQL*Forms,
     ଠ ᢥ稢  ନ.

   樮     ஫ 짮⥫  㯠  ORACLE RDBMS.
   

    
     , ꥤ塞  ⠫   ⭮襭 "᭮-⠫".
       뢠 , 樨஢  ⠫묨 ﬨ 
     ⠫쭮 .

   ⭮襭
          ᮮ⢥騩 ⠫ .
   ᭮-⠫  , ⭮襭 ᭮-⠫ ⮬᪨
   न    .  ᫨ ,   ⭮襭
    ⠪  न஢ 㤠   .

   -  ,  뢠 ६  
               .   1-2.

   ꥪ
     (1) 㯯 ,  ਬ ଠ, , , ਣ,  
      ஢, ६  㤠     ஥-
     ஢. (2)   㯯     ORACLE, 
     ਬ ⠡  .


                                    -- 8 --



   ࠭
      뢮 ଠ樨.   ᪮ ஥,  -
      뢮   ﭭ ⥪  ஢   ନ,
      믮 ଠ. ଠ, 筮,     ࠭, 
       ⮫쪮 ࠭, ᪮쪮  ᮧ.   1-2.

   ᯫ뢠饥 
      ,  ६ ४뢠    ⢥ 
     ஥ ᮡ⨥  ⢨ 짮⥫.  ᯫ뢠饥  
      ᯫ뢠饩 ࠭楩, ᯫ뢠騬 ᯨ᪮ 祭  ᯫ뢠騬
     ।஬ .

           ப ⠡,  ࠦ  ଥ

   ⥪
     (1) ,  ன  ਣ.   । ஢
     (ଠ, , ),  ஬  ᠫ ਣ. (2) ,  ன
     ଠ ஢ ⮢୮ .     ।  
      ஢ન (ଠ, , ),     .

   ࠭ 㤮 " " SQL*Forms,  ன  
     ᮧ  ஢ . ࠭ 㤮 뢠 
      ࠭ ६.   室  ࠭ 㤮,
       ।  ஢ 譨    .

   -  ,  뢠 ६ ⮫쪮 
              .   1-2.

   ਣ        ,  믮  ஬ SQL*Forms (Run
                  Form) ᮡ⨨.  ⢮ ⨯ ਣ஢
                  (ᬮ "ࠢ筨 ࠡ稪  SQL*Forms").

    襭    ꥪ⮢
    ࠢ   ꥪ⮢ ᮢ  ࠢ  
    ꥪ⮢ ORACLE.  :
        *     30 ᨬ
        * 稭  㪢
        *  ᮤঠ 㪢,   ᯥᨬ $,#,@,_
        *     㦥 饣 ꥪ ⮣  ⨯
          (⨬,  SQL*Forms  ࠧ砥 㪢 孥  
           ॣ஢   ꥪ⮢).
        *     १ࢨ஢ ᫮ ORACLE  SQL*Forms.

        ࠭   ଠ  䠩
    樮 ⥬  ᫥騬 :    ७
    (.INP  .FRM). ⮬,  ᮣ襭   ꥪ⮢ ORACLE -
    뢠 ࠭祭, 뢠   䠩   樮
    ⥬.

  砭:    ࠭祭  ⮣,    .

  १ࢨ஢ ᫮
     ᯮ  ⢥  ꥪ⮢ १ࢨ஢ ᫮ ORACLE
    (ᯨ᮪   ਢ  ࠢ筨 ࠧࠡ稪  SQL*Forms).


    SQL*Forms ⭮  ⠡栬 ORACLE


                                    -- 9 --



        㬮砭   ᮮ⢥  ⠡   .
         ⥪饣  ᮮ⢥   ⠡.
       筮   ᮮ⢥    ⠡  .
            ,  뢮  ᮮ
         ப ⠡.   1-4   ᮮ⭮襭.
   1-4
                  ப;
                  ;
          Ŀ
            
           ITEMS                                                          
                                                                          
               Order ID   Item No. Code   Act. Price Quantity Item Total  
[  610   3 1089 68 1 58 ]
               611   1 1061 45 1 45  
[  612 ] 1 1060 30 100 3000  
                                                                          
                                                                          
           ITEM Table                                                     
                Ŀ                                                 
                   ORDID  ITEMID  PRODID ACTUALPRICE    QTY  ITEMTOT      
                 -------  ------  ------ -----------  -----  -------      
ப[      610       3    1089          68      1       58  ]   
                     611       1    1061          45      1       45      
                     612       1    1060          30    100     3000      
                                                                 
                                                     
          

      易⥫쭮  ᮮ⢥ᢨ       
     ⠡  ﬨ . ਬ,  ᠭ    
          ᮮ⢥饩 ⠡. ,  
      ⥫ ,   ⭮   
     ⠡. (   ᯮ짮  ஢ન, ᫥ 
     뢮 ᮯ饩 ଠ樨  㣨 ⠡.)

  ꥪ⮢ SQL*Forms

      ꥪ SQL*Forms ᫥  ᮡ 娨,  ࠢ
     ⥬,  ꥪ 䥩   ᯮ짮  ࠧ
     ஢ ᮧ .   ⠪ ࠢ
     ६饭 ꥪ⮢  ᯮ짮 [Zoom In]  [Zoom Out],
     ஢ ꥪ⮢  뫪  ꥪ.

      孥 ஢ 娨 室 ଠ. ଠ  
     ᫥騬 ꥪ⠬ 䥩:
   - 
   - ࠭栬
   - 楤ࠬ ஢ 
   - ਣࠬ

                 ᫥饬 ஢ 室 ,   
                ᫥騬 ꥪ⠬:
   - ﬨ
   - ਣࠬ
      쥬 ஢ 室 .   ਣࠬ.
      ⢥⮬ (᫥) ஢ 室 ਣ. ਣ
      '蠣' ਣ.

                                    -- 10 --



      ᮧ ,         ஢
  ꥪ⮢, ⮡ ᯥ 㭪樮஢  - ᫥⥫쭮, 
  ଠ     . ਣ - 易⥫. (  
  6 ਬ ਣ஢.)

       ஢  ꥪ,   ६   ᮧ   㦥
  ᮧ ஢; ᫥⥫쭮,  ᪮஢ ,    
  ᮧ .

       । ꥪ  ଠ  ⠡ ࠬ஢:
  - ଠ:    ଠ ᠭ 
  - :     ଠ ᠭ  ⠡ ࠬ஢ ᠭ 
  - :     ଠ ᠭ  ⠡ ࠬ஢ ᠭ 
  - ਣ:  ଠ ᠭ ਣ ⠡ ࠬ஢ ᠭ ਣ
  -  ਣ: ଠ ᠭ 蠣 ਣ ⠡ ࠬ஢ ᠭ
                  蠣 ਣ
  - ࠭: ଠ ᠭ ࠭ ⠡ ࠬ஢ ᠭ ࠭
  - 楤 ஢ : ଠ c 楤
        ⠡ ࠬ஢ ᠭ 楤








































                                    -- 11 --



            2                               
                                          

       㦤 業਩ ᠬ⥫,  楫  室
 蠣  ⨦  楫.      :
       - ᮣ襭  ⨯䨨
       - 祭 
       - -ਬ
       - 樨  ⠭
       - ᮡ  ⥬
       - 樨 ᠬ⥫

      襭  ⨯䨨
    㪮⢮ ᯮ ⨯᪨ ᮣ襭  ࠧ 
   ⮢  ⥪ 㪮⢠.  室   묨
   ᮣ襭ﬨ । ࠡ⮩   㬥⮬.

   㭪樮 㭪樮  SQL*Forms ।⠢ 
        㭪権 SQL*Forms 祭묨   ᪮ (ਬ
               [Next Field]).   ᬮ ࠬ  
                ࠭   SQL*Forms (।⢮ 
               [Show Keys]),  ⮣, ⮡  ࠢ ᮮ⢥⢨
               䨧᪨    㭪樮 .
               ஡ ᠭ  㭪樮  ࠧࠡ稪
               ᬮ  "ࠢ筨 ࠧࠡ稪  SQL*Forms"  
               "⪨ ࠢ筨 ࠧࠡ稪  SQL*Forms".

    ࠭   饭     訡 
    ᮮ饭    ଠ (蠡). ਬ:
               FRM-20033: Field name is invalid.

    ⠪      ਢ ⠪   蠡.
        ਬ:

           COPY('value','field_reference');

              孥 ਬ,   ⤥ 
            㣠 ᫥騬 ⨯᪨ ᮣ襭ﬨ:

           ᮣ襭          ᭥
           -----------------------------------------------------------
           ॣ     㪠뢠,    
                                ⠪,  ਢ

          ᨢ       㪠뢠  ६.  ᫥ ⠢
                               ᮮ⢥饥 祭   .

           | ( )      ࠧ ୠ⨢ 


           {} (䨣 ᪮)  砥  ୠ⨢ ⮢,
                                     ᫥ .

           [] (㣫 ᪮)  砥 易⥫  
                                 ୠ⨢ ⮢.




                                    -- 12 --



    祭    த ORACLE 믮   ⨯
          ஢,  ࠧ묨 ࠬ  祭ﬨ ,
                ⮬    㪮⢥  㭪ﬨ,
                  믮 (ਬ, [Accept]),    
                  (ਬ, Do   VT220).

            奬 祭   襩     p㪮⢠
                                                                                
                                                                                

    㤥 ᯮ짮   祭    ᠬ⥫:
       -  ࠡ稪,  ६ ஥  䨪樨 
       -  ,  ६ ஢ 

       ६ ࠡ  SQL*Forms,  ᥣ  뢥 ᯨ᮪ 祭
  [Show Kews].  㤠 ࠭  祭 
 [Accept].

  -ਬ
       ᠬ⥫ ( 3-6), ਢ  ࠧ-
筮 ஢ 襭.    த ਬ  ।-
饩 . 祭   ࠢ ,  ⮣ ⮡  
. ᫨  ᫨ 訡       ᠬ⥫
 ᭠砫,   ᯮ짮 䠩-ਬ,  ᮤঠ 
ᮮ⢥   .  -ਬ (CHAPTER3, CHAPTER4,
CHAPTER5, CHAPTER6) ᮤঠ  襭   ᮮ⢥
. ᫨ 室,       ࠡ  ମ
㣮 ,  訢 ࠡ  ମ  ।饩 .

  ⠭
    । ⥬   祭 ᠬ⥫,  襬 
    室 ⠭ ᫥騥  ORACLE:
   - SQL*Forms,  3.0
   - ⥬ ࠢ ५樮   (RDBMS),  6.0
   - ⠡   室  ᠬ⥫  ਬ-

     짮⥫᪨ ⥬ ⠭ த⮢ ORACLE ᮢ蠥
DBA ( ).  ᫨      짮⥫᪠ ⥬ ( 
믮 㭪樨 DBA)  室 㪮⢮ ﬨ   
'㪮⢮  ⠭ ORACLE'.  ,   ⠭  த
ORACLE RDBMS  SQL*Forms.  ᫥ ᪠ ணࠬ  ⠭ SQL*Forms,
 㤥   ,   室   ⠭
த  襬 . ⢥砩    믮 樨,
   襬    ࠭.

               ᯮ짮 ORACLE RDBMS,  室 
    ॣ樮  ॣ樮  ORACLE. ᫨  ࠡ⠥ 
                짮⥫᪮ ⥬ ORACLE,  ॡ  
                     ஫ 짮⥫  襣 DBA.

                   ᫨   짮⥫᪠ ⥬,   ⠭
                    䨪 ஢  ६ ⠭ . 
                   ⠭ ॣ樮 ⮢ ᫥ 
                   '㪮⢮   ORACLE',  6.0.





                                    -- 13 --



          믮 ࠦ 2-1  ᮧ ⠡-ਬ஢  
           室   㪮⢠.   -
    ⠡-ਬ஢ ⥫묨 ﬨ  '㪮⢮ 짮⥫  
                                                                                

  ࠦ 2-1 筨  ᪠ 뤠 樮 ⥬.

  ⠡   
     1. ᯮ  ⥬  ᬥ ४, 
        ஬   믮 ਬ.

     2.    DEMOBLD    ᫥騬 username/password
        (/஫ 짮⥫), ⥬  [Return].

        ਬ, ᫨  ॣ樮  SCOTT  ஫
        TIGER,    DEMOBLD SCOTT/TIGER     [Return].

        ணࠬ DEMOBLD ந ⠡-ਬ   
        襣 ॣ樮 .

     ᫥ 砭 ࠡ  ਬࠬ  㤠 ਬ஢   ,
            ᤥ ᫥饥:
      1.    DEMODROP    ᫥騬 username/password
        (/஫ 짮⥫), ⥬  [Return].

     ணࠬ DEMODROP 㤠  ⠡ ᯮ㥬  㪮⢮.
  㤠 , ᮧ .  㤠 ᮧ  ,
ᯮ  Delete   ⢨ SQL*Forms.

   㧪         ᯮ짮 -ਬ஢,  ᭠砫 室
   -ਬ஢  㧨    .  ⠫ﬨ   楤
                   "ORACLE Instalation and User's Guide"   .

  ࠦ 2-2
                  1.  ᫥騥 INP 䠩  ⥪騩 ४਩.
  㧪 -ਬ஢
                    CHAPTER3.INP
                    CHAPTER4.INP
                    CHAPTER5.INP
                    CHAPTER6.INP

   2.   SQL*Forms.
      . ᫥ ᪠ 樮 ⥬  SQLFORMS
                         [Return].
      .   짮⥫   Username  [Next Field].
      .   ஫   Password,   [Next Field].

                 䠩 INP 室 ᤥ ᫥饥.

  3. 㧨 .
     .   롥 Action. ⮡ ᤥ ,
          㪢  (  砥 ).
     .  [Next Field]  ६饭    Load.

     .  [Select]     Name 
        -ਬ,    㧨.
     .  [Accept]. SQL*Forms 㧨   .


                                    -- 14 --



  4. ࠭ .
     .  [Select]     Action`
     .  [Next Field]  ६饭    Save.
     .  [Select] ᭮  ࠭ .

  5.  .
     .    Action.
     .  [Next Field]  ६饭    Generate.
                   .  [Select].
     .  [Accept]  樨 .

   6. ᫥ ⮣,   ᤥ 蠣 3-5   ,
     롥 Action  Quit  室  SQL*Forms.

  ᮡ  ⥬
  ࠦ  㪮⢠ ࠡ  ⥬  䨣樨. 
 , ᫨  ᯮ SQL*Forms   ०    ।
筮 樨 (bit-mapped),  室  
楤 ⫨.

    ।  ०
   SQL*Forms 뢠   㪮⢥ ࠧ㬥,  
믮 SQL*Forms  ᨬ쭮 ०    ஢ન SQL*Forms -
  "Default".  ( ⠭ ᮮ頥 SQL*Forms,  室
'஢'    ࠧ,    ᨬ  
ᮮ⢥ 㭪樮 .)

  ᫨  ⨫ SQL*Forms    ନ   ० 
 ஢ન SQL*Forms ⠭  "Default",  ⮫  㣨 -
 ணࠬ.  ᮡ,   믮 , ஢ઠ   -
ࠧ    , 祬 ᪠  㪮⢥.   
 訡 襩 -  SQL*Forms ࠡ뢠  ᫥ ⮣
  '஬'   (    ᮮ⢥
㭪樮 ).   ⠭ ଠ쭮  ணࠬ
(..   ᨬ쭮 ०), ⠭  ஢ન  "Field"  ଥ
ᠭ .

᫨  ஥   ନ   ०   SQL*Forms,
   ᯮ짮 롮   ᠭ  ।饬 ਬ. 
⮣  室 ६ 㭪 롮 , ᯮ થ  -
 Tab (⠡). ⥬  㭪  ᮮ⢥饩 㭪樮쭮
襩 (ਬ,  [Select]).   ஡ ଠ樥  ࠡ
 SQL*Forms  ନ   ०,   "ࠢ筨
ࠡ稪  SQL*Forms",  3.0.


    ।  筮 樥
   (業਩)  ᠬ⥫ ࠧ㬥,   ࠡ⠥ 
SQL*Forms  ନ  ᨬ쭮 ०.  ᫨  ᯮ ନ 
筮 樥,  ᯮ짮 ""  ६饭, ஫஢-
  롮 㭪⮢ . ਬ:  ᯮ짮  ࠢ
஬   㪢 롮   롮 樨 ,  롨ࠩ
室 㭪    .  ⠪  ᯮ짮  
     ⮣ ⮡ ᤥ 롮   ஫.





                                    -- 15 --



    樨 ᠬ⥫
    ᠬ⥫  㤥 ⠢ ᭮ ਬ஢ 室  
  .  ᥪ 뢠 ॡ   楫,
  蠣 ,  室 ᤥ  ⨦  楫.

    業਩
         室  .
  쥧 ࠧ㬥  祭 ᫥  .
⠭ ⢠ ६ , 室  ࠡ⪨  ࠭
ᥩ, 易  ⠭ ⢠ 訡   , ࠦ
  襭 ⮬⨧樨 ⥬.

  ࢮ ⤥ । த , 室  ᯮ짮 
࠭.   ᮧ    - ⠡   2-1  2-5 
࠭ .  ⠡  ᭮  ,   ᪮
 ⮬ ᠬ⥫.

    CUSTOMER 砥 ᭮   㯠⥫.

    㭮 2-1
                                  Null ?          
                 -----------------------------------------------------------
   CUSTOMER
                 CUSTID                       NOT NULL        NUMBER(6)
                 NAME                                         CHAR(45)
                 ADRESS                                       CHAR(40)
                 CITY                                         CHAR(30)
                 STATE                                        CHAR(2)
                 ZIP                                          CHAR(9)
                 AREA                                         NUMBER(3)
                 PHONE                                        CHAR(9)
                 REPID                         NOT NULL       NUMBER(4)
                 CREDITLIMIT                                  NUMBER(9)

   ORD ᮤন ଠ   ,砥  १
  ।⠢⥫ த.

    㭮 2-2
                     Null ?         
                 ------------------------------------------
   ORD    ORDID           NOT NULL       NUMBER(4)
                 ORDERDATE                      DATE
                 COMMPLAN                       CHAR(1)
                 CUSTID          NOT NULL       NUMBER(6)
                 SHIPDATE                       DATE
                 TOTAL                          NUMBER(8,2)

   ITEM ᮤন ᯨ᮪ ⮢஢ ,訢   .

    㭮 2-3      Null?         
                 ----------------------------------------
   ITEM   ORDID          NOT NULL        NUMBER(4)
                 ITEMID         NOT NULL        NUMBER(4)
                 PRODID                         NUMBER(6)
                 ACTUALPRICE                    NUMBER(8,2)
                 QTY                            NUMBER(8)
                 ITEMTOT                        NUMBER(8,2)


                                    -- 16 --



   PRODUCT ᮤন  த⮢   த த
   ᮮ⢥饥 ᠭ  த.

    㭮 2-4
                    Null ?          
                 -----------------------------------------------------
   PRODUCT
                 PRODID         NOT NULL        NUMBER(6)
                 DESCRIP                        CHAR(30)

     PRICE ᮤন ⥪騥  ⥫ 業   த.

    㭮 2-5
                    Null ?          
                 -----------------------------------------------------
   PRICE
                 PRODID         NOT NULL        NUMBER(6)
                 STDPRICE                       NUMBER(8,2)
                 MINPRICE                       NUMBER(8,2)
                 STARTDATE                      DATE
                 ENDDATE                        DATE

         ।⠢⥫ த殢    ᪠  㯠⥫
  ⮢ ᮡ⢥筮   ,    㭪 2-6.
  ।⠢⥫ த殢 ࠢ     ,  ᮭ
  ࠡ뢠  .

    㭮 2-6    ଠ PAPER
    Ŀ
        C  -         No.21Ĵ
                                                                   
                 
                                
                                              䮭     
    Ĵ
                     த        QTY     ⮣    
                                                                   
    Ĵ
    Ĵ
    Ĵ
    Ĵ
                                   ⮣        
    

  
          ਫ ࠧ , ᫥  楫:
         室 ஢    ⠪ ⮡

        1) 뫮 㤮  ᯮ짮
        2) 﫮  ᯮ짮 SQL*Forms   ,  訡
             ᪮쪮   , ᭭    ⠡
             .

              , 㤥 ᯮᮡ ஢ 筮
                                                                                
                                                                                



                                    -- 17 --



         -   㯠⥫ ᮮ⢥ 䠬 㯠⥫
         -   த ᮮ⢥ ࠢ쭮 ᠭ த
         -  㬬   த ࠢ쭠.
         - ⢨⥫쭠 業      ⨬ 業

   
騥 蠣     ਬ   .  ᫥-
⥫쭮  㤥 ਬ  ᥬ ଠ ,   ᮧ;
  뫠    ࠧࠡ뢠 ᢮ ᮡ⢥ .

     ᠬ⥫ ⥫쭠 ଠ ॡ㥬  蠣  1 
4 室  ।  業਩.   ࠧࠡ뢠 ᢮
ᮡ⢥  ,   室  蠣  1  4 ,訢
    ६  ࣨ  樨 ⢨⥫ .

    1. ᭨  楫 :     믮 ?
    2. ।  ⠡  㤥 ᯮ짮  ଥ.
    3. ।  襩 .
    4. । 冷  ஬   ᯮ 室  
       襩 ଥ. ᬮ   㤥 室 ᤥ ࢮ-
       砫쭮    .(    
       ᫥⥫쭮 ᫨ .)
    5. ᯮ   㬮砭  ஥ 㡮
       ୮ .

    6.   ७砩  㬮砭  ᮧ ᢮ 
               㦤.
    7. 蠩   㠫쭮  ⥪  뤥
       । ⥩  ࠬ  ﬨ.
    8.  ஢ ஫  ਬ 祭 㬮砭 
       㣨  ਨ.
    9. । ਣ. ਣ -   ,  믮
        ४ । ᮡ⨥  ଠ ᪠.
   10.     - SQL*Forms ந ⠪ ⮡ ᯥ
       㤮 ஫   䠧 ࠧࠡ⪨.  ⨪ 訡
         ࠧࠡ⪨  ,⮬     
       ஫  蠣  5  9.






















                                    -- 18 --
