






                           SQL*Forms 


                         


                             


                   3.0    (SQL*Forms Designer's Reference)









                                O R A C L E 

           _____________________________________________

                      ⥬ ࠢ 樮묨  .




SQL*Forms Designer's Reference Version 3.0 Part No. 3304-V3.0 0789

Contributing Author: Eric Bond

Contributors: Chris Schock, Susan K. Jackson,
           Michael C. Fine

Copyright 1986, 1989  Oracle Corporation All right reserved. Printed in U.S.A.


                                


  "ࠢ筮 㪮⢮ ࠧࠡ稪  SQL*Forms"       
    㬥樨  SQL*Forms ᨨ 3.0.  ० 祬  
筥  ࠡ    ,   室   ᫥騬
।⠬:
-  㬥樨  SQL*Forms;
-  ⮩ ;
- ⨯᪨ ᮣ襭.

   ᪠ ,  ⮢    ࠡ  ⮩ ,   
  ࠢ쭮      䥪⨢ ᯮ짮  ଠ樨.

 㬥樨 砥    ᥡ  ⠪    ࠪ⨢ help-⥬


                                    -- 1 --



 㬥  । 祭    ᢮  㤨.
  ⠡  ⪮  ।⠢       㬥-
樨,  ࠧ㬥 㤨  ᮢ    ⮬,   㦭 ।⥫쭮
.

㬥               ᭮ 㤨   ।⥫쭮 ⥭

㪮⢮    -箪     㦭

 祭
ࠧࠡ稪            ࠧࠡ稪-箪  㪮⢮ 

ࠪ⨢
help-⥬            ࠧࠡ稪-箪  㪮⢮ 

ࠢ筮 㪮⢮
ࠧࠡ稪             ࠧࠡ稪   祭 ࠧࠡ稪

⪨ ࠢ筨
                     㪮⢮ 

⪨ ࠢ筨
ࠧࠡ稪             ࠧࠡ稪   祭 ࠧࠡ稪

          砭:  ࠧࠡ稪 ਪ ணࠬ, ᯮ騩
            3.0  SQL*Forms,    ⠪       
          ᫥騬 㬥⠬:


    - "ࠢ筮 㪮⢮   SQL ᨨ 6.0", Part No.  778-V6.0

    - "㪮⢮  ࠢ筨 짮⥫ PL/SQL ᨨ 1.0", Part No.
       800-V1.0

    - "㪮⢮ 짮⥫ Oracle*Terminal ᨨ 1.0", Part No. 5206-V1.0
    -   ⠭  㪮⢮ 짮⥫ ORACLE  襩
      ⭮ 樮 ⥬.


          ⮩ 

  ᮤন 뢠 ଠ b SQL*Forms, 室  
⤥  .  ࠢ筠  ଠ (..  ᠭ   ᭥)
࠭   ⤥쭮      楤୮ ଠ樨 ( ..  ᥪ権 " 
" ), ⠪    㦭   ଠ ,     
     .

᫨      ࠡ⠫    ।騬  ﬨ  SQL*Forms,    室
    1,  "  ᭮  SQL*Forms".         
⥬,    ணࠬ ।  SQL*Forms,    砫
ଠ,  室    ⮣, ⮡  ந ᢮ ᮡ⢥
ਪ .

         ᭮ ࠧ ⮩ 

"ࠢ筮  㪮⢮  ࠧࠡ稪    SQL*Forms"  ⮨  ᫥
᭮ ࠧ,  ⥩:
-  I   :    

                                    -- 2 --



-  II  :    楯樨
-  III :    ꥪ
-  IV  :    
-  V   :      த
-  VI  :    ஢
-  VII :    ਫ

 ஡  ᮤন ᭮  ࠧ     ᬮ
⠡ .

           ᮬ

,  筮,     " ન  ન". ,   
࣠  ⠪  ࠧ,          ᪠ ⭮  ⥬
㦭        .    "뢠"   
室  ᠬ  .

 ᮤন 뫪   ࠧ .    ࠧ,   ᢮
।,  ⠪  砥   ᥡ ᯨ᮪ "⢥ ⥬".   ᯨ᮪
।⠢  ,          ⠪     
 ᢮ ਠ ⥪饣 ࠧ.

⤥ 㭪 ⮣ ᯨ᪠ ᯮ  䠢⭮  浪.  
⥬  ᮯ஢ ஬ ࠭,   ன  ᬠਢ
 ⨥.      㭪  ⠪  ᯨ᪠ ।⢥  易
  뫪    砩,  ᫨    ᬮ  뫪  
⥫   ࠭     , ᯮ㥬  ⮩ ⥬.

,       ,  筮  뫠   
㣠,     த⢥  ⥬,   -       ࠧ㬥,  
⠪    த⢥묨.   ⮣ ᯨ᮪ "⢥ ⥬"
뢠 裡   ⥬   ᥩ  ,     
祢묨.  ਬ,  ᯨ᮪ "⢥ ⥬",    
ࢮ  ࠭   12,   "",   㪠뢠      ࠧ,
"  "   "४஢ ",   易  ⮩  
"",   室  㣨  .

砭:   ᫨     ᯨ᪠  "⢥  ⥬"  ᮤন ,
 ࠧ㬥,   ᮮ⢥騩  ,     
뫪,    ⨥.  ਬ,   ᯨ᪠,
।      "NEXT_FIELD,   㯠 楤", 砥, 
ᮮ⢥騩       ⮬   "㯠
楤"    ࢨ筮  "NEXT_FIELD".

         ᪨ ᮣ襭

 㪮⢮ ᯮ  ⨯᪨  ᮣ襭    ⫨ 
⮢  ⠫쭮 ⥫ 㪮⢠.   ᫥  묨  ⨬
ᮣ襭ﬨ.

         㭪樮 

㭪樮   SQL*Forms  ।⠢    㭪樨 SQL*Forms,
祭         ᪮   (   ਬ, 㭪樮쭠  
[Next  Field]  ).      ᬮ ᠭ 㭪樮  
ᮮ⢥饬 ࠧ   ࠭  㭪樨  "Show  Keys"  SQL*Forms 
祭 ᮮ⢥⢨  㭪樮  䨧᪨ 蠬 襩
.

                                    -- 3 --



         ࠭ ᮮ饭

᪨ ᮮ饭   ᮮ饭    訡      
⤥쭮 ப, ਬ:

   .

         ⠪ 

      ᠭ. ਬ:

HOST ( { 'command_string' | 'variable' } [,NOSCREEN] ) ;

   ப 뤥 ᫥騬 ⨯᪨
ᮣ襭ﬨ:

襭               ᭥

⠭         뢠  ,     
                          ⠪,  

ભ⮥ 祭    뢠 祭  㬮砭.
                         ᫨   㪠뢠 ࠬ 
                          ࠬ஢ , SQL*Forms
                         ᯮ 祭  㬮砭.

'६'             祭 ६.  
                         ⠢ 室饥 祭 
                          .

| ( ⨪쭠  )  ୠ⨢ .

{ } ( 䨣 ᪮ )  ঠ  ୠ⨢ -
                         ,  ண  㦭 .

[ ] (  ᪮) ঠ   
                          ୠ⨢ , 
                         ண   㪠 㦭.

          । ਢ

ଠ Oracle   襩 㬥樨.     ⥩ 襭
  த⮢    졠      ⠭     
    ⢠  㬥樨   த⮢.


,  ⠪   ,  ᫨    砭  ।
 ⮬ 㪮   㣮    㬥樨 
SQL*Forms. ᯮ  "砭 ⥫", ਫ      ⮩
,     415-598-8000     த SQL*Forms.



                               
            ।᫮
           㬥樨  SQL*Forms
           ⮩ 
          ᪨ ᮣ襭

                                    -- 4 --



 I                    

 1
          ᭮ SQL*Forms
          ࠡ⪠ ਪ 
          ꥪ SQL*Forms .
          ⠫   ꥪ .
           ࠡ SQL*Forms .
           SQL*Forms
          ନ SQL*Forms   

 2
          ଠ  楤
          ᭮ 
           ࠭ ।஢

 II                   

 3
          ᭮ ࠡ⪠
          ࠢ
          ஢ઠ
          ஢
          ࠡ⪠  ( commit )
          ࠡ⪠ ᮢ ( query )
          ࠡ⪠ 㭪樮 
          ४஢ 

 4
          楯 ਣ஢
          ⫨ ਣ஢ V3  ਣ஢ V2
          ஢ । ਣ஢
           ⢨ ਣ஢
          ࠡ⪠ ਣ஢

 5
           䥩
          ।०
          ४⥫
          ஫쭮 
           
          
          ଠ
          ᮪ 祭
          
           ஫஢
           ࠬ஢ ( spread table )
          ப ﭨ
 6
          ⥪
          ⥪  㭪  
          ⥪   㢥祭 ⠡
          ⥪  ,   
          ⥪  ਣ஢
          ⥪  ࠭ ᮢ
           ⥪ 㭪樮묨 蠬
 7
          㭪樮 

                                    -- 5 --



           
          ᠭ 㭪樮 
          㯯 㭪樮 
 8
          Help-⥬
          ࣠ help-ਠ
          ᮡ help-⥬

 III                   
 9
          
          । 
          ࠪ⨪ 
           ⨯  ( non-enterable )
 10
          ࠭
          । ࠭
          ࠪ⨪ ࠭
 11
          
          । 
          ࠪ⨪ 
           
          ⭮襭 "᭮-⠫" ( master-detail )
 12
          
          । 
          ࠪ⨪ 
           
 13
          "ᯫ뢠騥" 
          "ᯫ뢠騩" । 
          "ᯫ뢠騩" ᯨ᮪ 祭
          "ᯫ뢠" ࠭
 14
          ਣ
          । ਣ஢
          ࠪ⨪ ਣ஢
           ਣ஢
 15
          PL/SQL
           SQL*Forms ᯮ PL/SQL
           PL/SQL  SQL*Forms .
          ꥪ SQL*Forms  PL/SQL
           楤  PL/SQL
          ࠭祭 PL/SQL  SQL*Forms
          ⪠ 믮塞 ஢
           PL/SQL
 16
           楤
          㭪樨  㯠 楤
          । 㯠 楤
          ࠭祭 㯠 楤
          ࠭祭 㯠 楤
 17
           㭪樨
          । 㯠 㭪権
 18

                                    -- 6 --



          ६
           ६ PL/SQL
           ६
          ⥬ ६
 19
          짮⥫᪨ 室
           짮⥫᪨ 室
           짮⥫᪮ 室
          ணࠬ "ᯫ뢠" 
 20
            ꥪ⠬
          襭   ꥪ⮢
          饭  ꥪ⠬

 IV                   
 21
          ࠡ⪠ ᮡ⨩
 22
          ࠭祭
          ࠭祭 ꥪ⮢
          ࠭祭 ஢
          ࠭祭 16-⭮ ।

 V                      
 23
          
          ⮬᪠ ॣ
           ॣ
          SQL*Forms ( Convert )
          SQL*Forms ( Design )
          SQL*Forms ( Generate )
          SQL*Forms ( Runform )
            ப
 24
          ࠭ 
          ଠ ࠭ 
          ७ᨬ  ⥬
          ᭮ ⠡ SQL*Forms ( Design )
          ଠ INP-䠩
 25
            㣨 த⠬
            ORACLE RDBMS
            ।⢠ ਪ ࠧࠡ⪨
          ᯮ짮 ४஢ ORACLE  SQL*Forms
          맮   ணࠬ
          ᯮ짮 Oracle*Terminal

 VI                   
 26
          樨
          樨 SQL*Forms ( Runform )
          樨 SQL*Forms  ( Design )
           ਢ 짮⥫
 27
          ਪ 㬥
          ⠫쭠 㬥
          㬥  
          㬥  맮 ꥪ⮢

                                    -- 7 --



          㬥  ࠭
          㬥  楤
          㬬ୠ 㬥
          㬥  ਣ
 28
          ।⢠ ⫠
          ⫠ ᮮ饭
          ࠡ⪠ 뢠
 29
           ।஢   
          ᯮ짮 ⮩ 
           譮 業 ( key script )

 VII                   

ਫ A
               ⪮  ᢮
                ᢮⢠
                ᢮⢠
ਫ  B
               ⨬ ᭨ 
               ॢ ਣ஢  PL/SQL
                 ⨯ 
ਫ C
               樨
ਫ D
               ᪨ ⥬ ᮡ
               । 筮 ०
               । ⮢ ⮡ࠦ
ਫ E
               饭
               饭 SQL*Forms ( Convert )
               饭 SQL*Forms ( Design )
               饭 SQL*Forms ( Generate )
               饭 SQL*Forms ( Runform )
ਫ F
               ਣ V2
               । ਣ஢ V2
               ࠪ⨪ ⠯ ਣ஢
                 ⠯ ਣ஢
                㭪権 V2
                CASE
               ६  ⠯ ਣ஢
               ࠡ⪠ ਣ஢ V2
               
               ଠ "砭 ⥫"

                                      I
              
                                      1
           SQL*Forms

  SQL*Forms  㭨ᠫ ।⢮  ࠧࠡ⪨   믮
ࠪ⨢  ਪ  ,  ࠡ   ᯮ짮  ..   .
  ࠧࠡ⪨  ⮣ ।⢠   ᯥ樠쭮  ᮧ    ⠪
ࠧࠡ稪   ணࠬ⮢,   믮 ᫥騥 :



                                    -- 8 --



- । ࠭権,  ꥤ   ࠧ ⠡  
  ;

-     㬮砭, ᯮ騩   ࠬ஢ 
  㬮砭,  ⮬᪮ । ⭮襭 "᭮-⥪騩";

- ᮮ⢥⢨ ᥬ ᯥ⠬ ⠭ .

SQL*Forms  ᯮ  ⠭    ௮樨   Oracle 짮⥫᪨
䥩 " "    楫 襭 த⨢ ࠧࠡ⪨  
᮪饭  ६ 祭.

   믮   SQL*Forms      ࠬ 믮,  
᪠,  ਪ ,  ᯮ騥 ᮧ  .

    ᮤন  ନ    楯樨,  ⭮騥   SQL*Forms 
५樮    ,             ᯥ譮
ᯮ짮   ⮣  ࠢ筮 㪮⢠.   ।祭   
짮⥫   ,   ᯮ ᭮ 楯樨 SQL*Forms .

 ⭮,   砥 ᫥騥 ⥬:
- ࠧࠡ⪠ ਪ ;
- ꥪ SQL*Forms;
- ⠫   ꥪ;
-  ࠡ SQL*Forms;
-  SQL*Forms;
- ନ SQL*Forms   .

    㦨    ⢥      ନ, ⭮ 
SQL*Forms. 設⢮  ਠ ⮩    
  ஡    㣨   ⮣ ࠢ筨.  ᪨ "⢥
⥬" ᪠ ,   ⥫ ଠ  ⤥ ⥬.

         ࠡ⪠ ਪ 

 祭    襤  ⨫⨩   孮   ࠧࠡ⪨ ਫ
,    ࠧ.      砫   楤
ᥬ஢   १ 모 쥣  ( 3GL ), ⠪ 
FORTRAN  COBOL,   몠 ⢥⮣   (  4GL  ).   ᭮
⥭樥  ⮩  樨  뫠 প  襩  㭪樮쭮  
楤୮  ⮤.    ।,    - ᤥ,
ࠧࠡ稪 ਫ ⥯  ।,  㦭 ᤥ.


           襭  SQL*Forms

SQL*Forms  ࠧ  ⥭  孮 ࠧࠡ⪨ ਫ,
    ꥬ  㭪樮쭮, ॠ㥬  㬮砭,
- 䠪᪨,   ࠡ騥 ਫ.  SQL*Forms  ন
   ਫ      㭪樮஢      ꥪ⮢
 ਫ.   १,  ⥩襥 ਫ  SQL*Forms 
। 㭪樮쭮  " 㬮砭",  ..   ᯮᮡ
஢ ⨯ , ࠢ 믮 ࠡ⪨     
 .

᫨    ᮧ  ਫ  㬮砭 ( default ),    -
஢    㭪樮  ࠪ⨪     "譨 ".
짮⥫᪨   䥩       ।

                                    -- 9 --



ᮡ । ਫ  ⥬    ଠ樨    ⥪⮢
         ⥬ "祭-몫祭" ⤥ 㭪⮢  
ᯨ᪥  ।.

ਬ, ।,   ਫ  㬮砭 । ,
 ,  ࠭ ਫ,  뢠    ⮫  
  ࠧ蠥  ஢  . ᫨  
 । ⮣  ⠪, ⮡       ४஢
뢮  ,      몫砥  ࠪ⨪  "  ࠧ襭"
( Input Allowed )  ⮣ .  믮  䨪樨 
- ணࠬ஢.

஬ 䥩    SQL*Forms  ন   ।⢠
࠭ ᮢ  ।஢ ࠭ ࠧ  
ﭭ ⥪, ᪠  ᪨ ⮢.

᫨  ਫ  ॡ  ᯥ樠 ⥩  ਬ ,
         ,   ᯮ   PL/SQL, ⥣஢
楤  ,   ஥ 䥩  ।⢮  맮
ணࠬ,   ᠭ    몠  쥣 .

  室 - ᯮ짮  歪樮쭮  㬮砭
  짮⥫᪨  䥩         -      
⥫쭮 㢥祭 த⨢.

         ७ᨬ । ࠧࠡ⪨

   ᢮  ᯮᮡ    ᮧ   ਫ
SQL*Forms  ন  ७ᨬ  ।  ࠧࠡ⪨ ਫ.   
ᮧ  ਫ,      뫨 ࠡ    ࠧ  設
  ᯫ,     砫 室 ᠭ   ࠧ
ਫ. ਫ SQL*Forms  ७ᨬ묨  ࠧ묨
  ।, 樮묨 ⥬  ⥬ ஢.

         ꥪ SQL*Forms

ਫ SQL*Forms ⮨  ꥪ⮢.  ꥪ ᮤঠ 
ଠ,  室    ࠢ   믮 ਫ SQL*Forms.

᭮ ꥪ⮬,  ⮩,  ਫ SQL*Forms  ଠ.
 ꥪ  ᮤঠ 楫 ਫ,  ⠪  ꥤ 
㣨 ଠ,  㯯 ,  ,  ⠬  㣨 ⠬ 
ᮧ    ᫮  ਫ.   SQL*Forms    ᮧ  ,  
  - ࠧ 裡  㣨 ⠬.

ଠ ⮨  ⥫ ꥪ⮢.    ꥪ  뢠   
⠬  ,  ⠪    ⠡,   ᯥ稢
ࠢ ᮬ 믮.


   뢠  ᥪ  ᥪ     㦠 ᭮
             ⢨   .

   ।⠢         뢠, 
                ⮡ࠦ    ஢७   
              ࠡ  -   묨   .



                                    -- 10 --



࠭    ࠬ 뢮 ଠ樨, ⠪    
             ⥪  䨪.   뢮-      ࠭.

ਣ    ࠬ ࠡ뢠 , 易묨  窠
             ᮡ⨩, ⠪ , ਬ,    ஬ 
             । 㭪樮쭠 .

楤       ࠬ ࠡ뢠 , 
஢    뢠   ਣ  㣮
               楤 ஢     㬥.

 ଠ ᮤন    ,   ࠭    
.   ꥪ  ଥ   ਡ⮢,   ࠪ⨪,
 ᮤঠ ଠ   ꥪ.  ,   ⭮,    ,
⠪        ᯮ짮   ᫥   ࠡ  묨
 .

設⢮ ꥪ⮢ ᮧ  ࠪ⨪  㬮砭,  
設⢮   ࠪ⨪ 筮 㤮⢮ ࠧࠡ稪.   
  ࠪ⨪ ꥪ  ᮥ 室 
ࠡ⪨,    㤥  ᯮ짮   䥩 ࠧࠡ稪
SQL*Forms.

         ୮ ᯮ짮 ꥪ⮢

  ᮧ  ਫ   筮 ᮧ ꥪ,    ந
ਫ.  ,  ..  ꥪ    ⤥묨 ⠬,  
  ந ਫ,   騥 ꥪ  ।
ਫ        騬 ꥪ⠬  ।.  (-
 筮 ஢,   ᪫祭 ⮣,  SQL*Forms 頥
䨪 ꥪ⮢,       饭.  )  ..  ꥪ
 "⭮ ᯮ㥬묨",   ᮧ   筮
ᯮ㥬 ꥪ⮢.  ᯮ짮   筮 ᯮ㥬
ਣ஢ -  ਬ  -  ᮪頥 ६  ਫ  
訡  ⮬,   ⠪   ࠭,   ࠧࠡ稪 ᯮ
⠭  䥪⨢ ਣ.

⢥ ⥬:                    饭  ꥪ⠬

         ⠫   ꥪ

।騥   ࠭     ᭨,     ꥪ  
"ந⥫묨  "  ਫ,    ⪮  ।⠢   ꥪ:
,  ,  ,  ࠭,  ਣ    楤 ஢  .  
ᥪ  뢠  ꥪ  SQL*Forms   ⠫쭮    ,    
    㣮.  騥    ⮩    ⠫쭮
뢠  ࠪ⨪       ꥪ⮢      । 
 䥩 ࠧࠡ稪.

砭: ,  ,  ਤ   ࠧ "ନ SQL*Forms  
  "  ⮩      ᫥饣 ਠ.

          ꥪ⮢

ꥪ  SQL*Forms    ᪨.   㭮   1-1
        뢠,    ꥪ 孥
஢  ꥪ⠬  ஢.


                                    -- 11 --



          1-1
                    Ŀ
 ꥪ⮢                                                       
SQL*Forms                                  ଠ                        
                                                                       
                         Ŀ    
                                                                    
                      ࠭      楤             ਣ 
                                         ஢                  
                                 Ŀ                          
                                       ਣ                     
                                                                       
                               ਣ                                 
                                                                        
                    

ଠ  ࢨ  ꥪ⮬,    ⮩,  ਫ SQL*Forms, 
⮬  頥   娨.  ਫ ଠ   ᥬ
㣨 ꥪ⠬. ᪫祭ﬨ  ꥪ,   ଠ 頥,
  ਭ 㣮 ଥ.  ⨬,   ꥪ   ࠧ
 ᪮쪨 ࠧ묨 ଠ ( १ ⭮襭  ꥪ⮢  ),  
ᥣ    ⮫쪮  .

⤥       ﬨ  ਣࠬ,   ⤥   
  ਣࠬ.  ਣ    㭨묨 ꥪ⠬    ⮬,  
   ⢮  祬    娨.  ஢ ।
ਣ  ⢮   ⢨  権.

⢥ ⥬:   ⥪
                     ⢨ ਣ஢

         

ଠ ᮤন     .        ⢮
 ⮫쪮   ⠡楩    㠫쭮 ⠡楩 (view).
  砥,       㭪  1-2,      易
 ⮫殬  ⠡ (⭮,   ᭮ ⠡)    㠫쭮
⠡.   㬮砭   אַ   ⢨   ࠬ  
,  ஢,  ⠢  㤠     ᭮ ⠡
 㠫쭮 ⠡.   SQL*Forms ।⠢ 짮⥫   樨
⮬᪨,    । ᭮    ⠡.     롮
ࠧࠡ稪       ⢮ ᢥ ( ..  
ଠ )     ᫮ ⠡    㠫 ⠡.

  뤠    ࠭       ᥩ.     㭪 1-2,
   㯯   ᮮ⢥饩 ଠ樥,  㡮
ᮮ⢥ ப  ⠡.

          1-2
               Ŀ
, ப,          
  ⮫     ITEMS                                                 
                                                                         
                Order ID  Item No.  Code  Act.Price  Quantity Item Total 
  ĳ[ 610 ] 3  10890  58  1  58  
                 611   1  10861  45  1  45  
   ĳ[ 612   1  10868  38  100  3800 ]
                                                                       

                                    -- 12 --



                 ITEM Table                                            
                 Ŀ                                             
                   ORDERID  ITEMID   PRODID  ACTUALPRICE  QTY  ITEMTOT 
                               
  ப ĳ[     610    3    10890    58    1             58 ]
                        611       1    10861    45    1             45  
                        612       1    10868           38  100    3800  
                                                               
 ⮫ ĳ                                             
               

    ࠪ⨪,      ।.  
ࠪ⨪  ।  ਡ,  ⠪    冷  뢮 ଠ樨,
  SQL*Forms  頥    ६ , ᫮ ᥩ ,
 뢮  ,   믮   । ⨯ ஢ન .

⢥ ⥬:         


         ⭮襭  

  뢠 b  ᮡ १  ⭮襭 "᭮-⠫"
(master-detail).  ⭮襭 筮 ⭮襭 "室    -
८।  "   ᭮묨 ⠡栬  . SQL*Forms
   ⮬᪨  ⠭ ⭮襭 "᭮-⥪騩"   
ᮧ  .    ᢮⢮     ᮧ ,
 뢠  ப  "⠫쭮"  ᥣ,   뢮
ᮮ⢥  ப  "᭮"  -  ।⥫쭮   
""  ᯥ樠     ࠡ⪨.
  ⢥ ⥬:      ⭮襭 "᭮-⠫"

         
 ᠬ 饬 ᫥  㦠  ⢥ ⥩஢   
.   㫨஢ ᮤন  -     
祭  ,  ⠪   ᫥  뢮 室 ⮣ ( 
ਣ   楤 ).    ᥣ ਭ ,  .. 易 
.   筮     .

    筮  ᮮ⢥  ⮫栬      ᭮ ⠡  
,  ஬ ਭ  .   ⮬ 砥     
 ᮤন ப  ,       
 ᭮  ⠡.  ,     ᥣ  ᮮ⢥  ⮫栬  
᭮ ⠡  ;       ᮤঠ   塞   祭,
뢮 ᮮ⢥   ଠ      㣨  ⠡    ਭ
᪨   쭥襩 ࠡ⪨.

ଠ  뢮  ⢮ "ॡ"     ⮣   .
 砥,     ।   뢮  祬  
ଠ樨 ६.   뢥   ᮤন    ॡ㥬
祭    .   ⠪ 祭 ⥭樠쭮
ᮮ⢥ ⤥쭮  ப     ,    ࠭ 祭
   ࠪ⨪.

      ࠪ⨪,     뢠  .   
ࠪ⨪ ।, । 祣,   ""  
    ࠡ    ,     뢮  ⮬ 
  ⨯  ⨬      .
⢥ ⥬:           

                                    -- 13 --



         ࠭
࠭  ࠬ 뢮 ଠ樨.  ࠭ 뢮  
ﭭ ⥪  ஢    믮     ਭ樯 ஥樨
᫠. ⨬,  ࠭ 㦠 ⮫쪮  뢮 ଠ樨.  
 ⥪ ( ਬ,     ),    뢮,
   "" ᠬ ﬨ,    뢮,   ,  
     易.            뢮 
  ࠭,       ⢥ ࠧ ࠭ 
冷  ﬨ 㣨 .   ਢ뢠   ; 室
뢮 ਢ뢠   ࠭栬.

࠭   ࠪ⨪,   ⠪      ࠧ    室
뢮 ࠭   "ᯫ뢠饣" .

  ⠩  ࠭   ࠭.  ࠭ -   뢮  ନ,
    אַ  易    ࠭栬.  ਬ, ᪮쪮  ࠭
     ࠭ ६,     㭪 1-3.
஬ ⮣, ࠭   ࠧ , 祬  뢥  ࠭.

          1-3
                 Ŀ
࠭筠          
ଠ             ORDERS                                                
                                                                        
                      Order ID 35       Order Date  14-MAY-89       
                                                                        
                      Client ID 147  Client Name Adamson 
                                                                        
                 -   Ŀ 
                                     Client Data                     
                     ĳ 
࠭ 1-    -                                               -
                  ITE Client ID   147                           
                                                                     
࠭ 2ĳĳĳ      Client Name Adamson     
                                                                     
                       Street      Rokabilly     
                       City        New Mexiko               
                       State       TS Zip 171-591                 
                                                                     
                     
                                                                        
                     
                 Count: *8                                  <Replace>  
                 

           ⢥ ⥬:        ࠭


         ਣ
ਣ -   ࠡ뢠 ,      .  
⨯ ਣ஢ 易  ࠧ묨 窠 ᮡ⨩  ࠡ SQL*Forms.
  ந室  ᮡ⨥,      易  ਣ,  
"", 믮 ,    ᮤঠ. ਬ,  
  [Next Field]  室     㣮, 
ਣ Key-NXTFLD.



                                    -- 14 --



設⢮ ਣ஢,   , ᨬ  ⨯  ਣࠬ
V3 ( ᨨ 3 ).   ਣ஢ ⮨  , ᠭ  PL/SQL,
 楤୮ 몥,  祭   ⠭    
SQL.     ਣ V3 ᫥騥 ⨯ :  -  SQL; -
 楤୮ ; -  ࠡ⪨ .

砭: ਣ  V2  (  ᨨ  2  )   ..  蠣  ௮
           Oracle ন   ᮢ⨬   ।騬 ﬨ
           SQL*Forms.
⢥ ⥬:    ਣ, 楯

          SQL  ਣ

 SQL ( 砥  Structured  Query  Language  - ஢
 ᮢ)          ਣ.    ।
࠭祭   ⮬,     믮    ࠧ
ਣ,    ᭮   ࠢ   SQL    ᯮ짮
   ਣ. ORACLE RDBMS 믮   .

          楤୮   ਣ

 楤୮  - ⠪  ᫮ ,  横  ࠡ⪠
訡  - ⠪ ⨬  ਣ.     ᯮ짮
祭 ,  ⥬ ६    ࠢ  ଠ  
த ࠡ⪨.       祭  
אַ ७祭.
          ࠡ⪨   ਣ

⥫ ,   㯠 楤, 
⢮     ७ PL/SQL, 騬 ⮫쪮  
SQL*Forms.              믮 । ⢨,
⠪  ६饭 , 맮 㣮       ࠪ⨪
.    楤 믮    ணࠬ
ࠢ,  ᭮   ᮡ  ਫ.

         楤 ஢ 

楤  ஢    -    뢠    .   楤
 ᯮ짮  ,       ᯮ짮 ਣ.
   ⠪      㬥    । 祭,  
   ணࠬ   몠 쥣  ⨯ COBOL.

 ⢨ 楤 ஢  ࠭祭 ⥪饩  ମ.   ,
   뢠  㣨 楤ࠬ ஢     ਣࠬ  
ଥ,    ன    ।   ८।.    ᢮⢮
    ᮧ ᭮ ணࠬ,      
ᯮ짮    ࠧ.   ᮪頥  ꥬ  ணࠬ஢ 
⭮     ᮧ  ᦠ  䥪⨢ ਫ.

⢥ ⥬:             楤 ஢ 

          ࠡ SQL*Forms

  ଠ  믮,  SQL*Forms  稭  ।⥫쭮
।  ࠢ  襭,  ⢨ 室 믮.
  ⢨   ᥡ ࠢ ।  ਫ (
 )  ஢ ࠢ쭮 .      ࠢ   ࠡ⪨


                                    -- 15 --



ਫ        । "" SQL*Forms  㬮砭  
ᮮ⢥⢨  ॡ  ਫ.  ⢥ ⥬:
  㭤⠫쭠 ࠡ⪠

        㭪樨

  ࠡ  SQL*Forms  ।稢   ᮡ⨩.   , 
ᮡ -  ,  ந室  믮 .  SQL*Forms  
ᮡ  ࠢ ,  믮 । 㭪樨.  ਬ஬  ᮡ
  ⨥  ஬  [Next Field].    ᮡ⨥
ந室,  SQL*Forms  믮 ।⥫쭮  । ᫥⥫-
 ⢨,     ।  㬮砭 (    砥
믮 㭪樨 NEXT_FIELD,   ६頥   ᫥饬  
 )    ᫥⥫쭮,    । (ਬ,
믮  㭪樨  MESSAGE    㭪樨 NEXT_FIELD  뢮 ᮮ饭
  ६饭  ).

⨬,    ६ ࠡ SQL*Forms  ᮡ  筮  ""   
㣮,  ..     ᮡ 筮 뢠 㭪樨, 
뢠 㣨 ᮡ.

饩 ⮩  㭪権,   뢠 ᮡﬨ (  ⠪
訬  ਣࠬ  ),    樨  ஢ .
⢥ ⥬:                    ࠡ⪠ ᮡ⨩

         窨 室 ਣ஢

 㭪,   뢠 ᮡ,   ᮤঠ  ᥡ  
 祪 室 ਣ஢,  易  ⮩ 㭪樥.  窠 室 ਣ
-  ६ ""  ᮡ⨨,    易  ।  ⨯
ਣ.   SQL*Forms ࠡ뢠 ᮡ⨥  ⨣ 窨 室
ਣ,  稭  믮 ⮣ ਣ,  易  
ᮡ⨥,  ᫨  । ਣ  ⮣  ⨯.  ਬ,    
믮  㭪樨 NEXT_FIELD    窠  室    ਣ Post-Field.
᫨  । ⠪ ਣ,  "",   SQL*Forms ⨣ ⮩
窨  믮 ⮩ 㭪樨.

窨  室    ᠬ ਣ  ࢨ묨 ।⢠  䨪樨
,     ஬   SQL*Forms   㦨,    믮, ।
ᮡ⨥. ⨬,    ᮡ  窨 室 ਣ஢  ਣ.
ਬ,    ᨬ  ନ  ᨬ쭮 ०, ந室
ᮡ⨥;  ..  SQL*Forms  ࠡ뢠  ⨥     ⮡ࠦ  ᨬ
 ᮮ⢥饬 . ,    窨 室 ਣ    
ᮥ ਣ  ⮬ ᮡ.

           ࠧ 䨣

孮 뢮  ࠭,    ᯮ,    ⫨ 
⮬,  SQL*Forms ࠡ뢠 ᮡ. ਬ,   
 TAB   ன⢥  ᨬ쭮  ०, SQL*Forms 뢠 㭪
NEXT_FIELD  ࠡ뢠  ਣ, ᮥ   窠 室
ਣ஢.  ,  ன⢥ 筮 ० TAB 뢠 㭪
쭮  ।஢   SQL*Forms    믮   㭪権 
ਣ஢ -   ⠪ ࠧ ६  ﬨ  
뢠 ᭮ ࠡ   ᮡ.




                                    -- 16 --



᫨    ࠧࠡ뢠  ਫ,     ࠡ 
ࠧ ⨯ ன,   뢠  ࠧ.
⢥ ⥬:  ᬮ७ ⥬-ᯥ᪨
                    ᮡ⥩ SQL*Forms

         
 -  ७ 㭪,  뢠  ।- 
ᮡ.  SQL*Forms 믮      ।   ६饭
          㣮.   , SQL*Forms ⠪ 믮
  ६ ᮡ⨩,    ६頥,   SQL*Forms 
࠭ ࠢ ࠡ⮩   ꥪ SQL*Forms  த 
ࠡ⪨.

묨  ﬨ 樨   ࠢ  .  
ࠢ -   ७  ꥪ,    ᫥   ꥪ,
  SQL*Forms  ࠡ뢠    .   ࠢ ᥣ
।    ᮡ  ଠ,  ,         ଥ    
 譥  ⭮ .  SQL*Forms । ࠡ ⤥쭮
,  ।  ࠢ   ꥪ 㣮.

  -   譥  ꥪ,   뢠 ⨢   
ଥ  ६  믮.    ᭮   ࠧ蠥 ६饭
      ᢮   ⥪饩,     ࢮ砫쭮,  樨   
.     ६饭  SQL*Forms 砫 ६頥 
ࠢ,    ।  ⢥ ꥪ 祭.

ਬ,         [Next  Record],   SQL*Forms 뢠
㭪 樨.  ⮡ ६    ⥪饣  (1.1  )
     ( 2.1),  SQL*Forms ६頥  ࠢ
 1.1  1, ⥬ 㤠 -   1,  ᫥ -    2  ,
, -  2.1.  ..  SQL*Forms  "頥"   "" 
襯᫥ ꥪ,  ந室  ᮡ,    
易      ਣ.     ࠡ⪠ 蠥   
ࠢ   ।   ᯥ譮,    2.1  (   ),
SQL*Forms ६頥    .
⢥ ⥬:                    ࠢ

         ஢ઠ
஢ઠ  -    ७  㭪,      뢠    ।
ᮡ.  ஢ઠ  ᮬ,   ஬ SQL*Forms ।,
ࠢ,  ४,    ꥪ.  SQL*Forms  ஢ ,
,   .

 SQL*Forms 믮 ஢ ꥪ  㬮砭,   ,  ⮡
㡥,   ꥪ ᮮ⢥ ᥬ ᮣ襭   ⮣  ꥪ.
ਬ,   SQL*Forms  ஢      ࠢ쭮  ⨯  ,
ᮮ⢥⢨  ⨬   祭    㣨 .
 ᥩ,       SQL*Forms  ஢,  ४    
ꥪ,   ਭ  ⮩ ,   ଥ.   㭪
஢ન 筮   ᪠,     뢠  㭪  樨,   -
ਬ,      室  ,  -   
 ᨬ묨   㣠.

    ஢    㬮砭,  । ਣ  窠  室
ਣ஢ ஢ન.   ⠪    ࠢ ⥫쭮     ⮩
஢ન      ଥ,    । ࠪ⨪   㫥 ஢ન.
⢥ ⥬:                    ஢ઠ


                                    -- 17 --



         믮 ਣ஢

 뢠 㭪樨,    窨  室  ਣ஢.  
SQL*Forms  ࠡ뢠  ⠪  ,    믮,   ᪠,
ᮮ⢥騩 ਣ.   窠 室  ਣ   ।  ⨯
ਣ,  易    .     ।    ਣ,    
⮬᪨    뢠     ᮮ⢥饩 窮 室 ਣ.  
砥,   ᫨  । ਣ Post-Block,    ᪠,  
  ,     , ਬ,    㤠
.

 ᪠ ਣ, SQL*Forms 믮     浪,
।   PL/SQL.      ਣ   믮
ᯥ譮    ᯥ譮  -  㤥 ﭨ SQL*Forms,    PL/SQL,  - 
  ஦  ।⥫쭮 ।  ᪫祭 PL/SQL.  室 
१⮢ 믮 ⤥쭮 ,     ⠪    ᮧ
᪫祭 PL/SQL,  । .  SQL*Forms ࠢ ⮩ ࠡ⪮ 
ᮮ⢥⢨      ஬    ,       
। 쭥襣 ० ࠡ.

ਣ  - ..  ⤥  ஢  -    ⠪ 
ᯥ譮  ᯥ譮.  ᫨    ᡮ,    SQL*Forms ਮ⠭
ࠡ ⥪饣 ᮡ.  ਬ, ᫨ ਣ Post-Field "뫥⠥",
SQL*Forms "    室" 樨   ୮ 室  , ஥ 
⠫ .

 ० ࠡ         ,    SQL*Forms த
᢮  ࠡ  ᫥  ⮣,    ਣ  ᢮ 믮.

᫨ ਣ 믮 ,   뢠 SQL*Forms   ࠢ
㣨  ᮡﬨ,  SQL*Forms ਮ⠭ ࠡ ⥪饣 ਣ, ⮡
ࠡ  ᮡ⨥. ਬ,  ᫨ ਣ   뢠   㭪
NEXT_FIELD,   SQL*Forms    ࠡ뢠 ᮡ⨥  NEXT_FIELD  (    
祭  ᮡ,       뢠  )    த  믮
⥪饣 ਣ.   ᫥⥫쭮 ࠡ  筠  ⮬,  
뢠  ணࠬ  ணࠬ  몠 쥣  ( 3GL ).
⢥ ⥬:            ࠡ⪠ ਣ஢

          ⢨  ᫥⢥

஬ ਢ離  ᮡ  ਣ  ⠪  易    ꥪ⠬.   
। ਣ,   ᥣ ਢ뢠   ଥ,   .
ꥪ,   ਣ஬,  ।   ⢨.

  SQL*Forms  ࠡ뢠    室  ਣ,   ᥣ
।,  㤥 믮 । ⨯ ਣ.  ..    
। ᪮쪮 ਣ஢  ⨯,  SQL*Forms 蠥,   ਣ
,  롨 ,   易    ᯮ㥬 ꥪ⮬.
ਬ, ᫨ SQL*Forms  맢   ਣ On-Validate-Field, 
᭠砫  ⠪ ਣ,   易    ⥪饬  .  ᫨  SQL*Forms
室 ,       믮,   室  㣨   ਣ   ⨯

On-Validate-Field,  易  ⥪騬   ମ.  , ᫨ 
室 ⠪ ਣ,  易    ⥪騬  , SQL*Forms  
,  易    ⥪騬    - ᫨ ⠪  -  ⥪饩
ମ. ..  SQL*Forms ᯮ ᢮⢮ ᫥⢥      



                                    -- 18 --



⨯  ਣ஢,     ਣ On-Validate-Field,   ਢ易 
ꥪ  孥  ஢, 㯥   ꥪ⮢,  묨  
ꥪ 孥 ஢.


          SQL*Forms

SQL*Forms ⮨  ᫥ ணࠬ,  ,   
믮 ᨬ   㣠   ப.  ࠧࠡ稪,    
        ᯮ짮     SQL*Forms(Design),    ன
       㣨 ⠬,    ॡ.

SQL*Forms        । , ᯮ ,

(Design)       ࠭    ஡ 
               help-⥬.  SQL*Forms(Design) ࠭ -
                 ꥪ⮢    㯯  ⠡  
               () ORACLE.

SQL*Forms       ࠬ 믮   ।-
(Runform)      ⥫쭮 । .   ⠪ -
               짮    ஢  -
                .

SQL*Forms        ᮧ 䠩 । ,
(Generate)      SQL*Forms(Runform)  믮 אַ
                ।⠢   ⥪⮢ 䠩,  
                - אַ 䠩.

SQL*Forms        ஢   ࠧ묨
(Convert)       ।⠢:
               -  ⥪⮢ 䠩  ।,
                   ࠭  ⠡ .
               - ⠢ ।  (  SQL*Forms
                   (Design)  ⥪⮢ 䠩)   ⠡ .
               -  ⥪⮢ 䠩  ଠ ᨨ 3.0  ⥪⮢
                 䠩, ᮧ  ।  SQL*Forms.

⢥ ⥬:           


ନ SQL*Forms  
          ⮡  䥪⨢  ᯮ짮 ࠢ筮 㪮⢮,   
           ᫥騥 ନ SQL*Forms  ନ .

ନ   㭪  1-4    1-5      ᭮   ନ,
SQL*Forms ᯮ㥬 SQL*Forms.

 1-4
          Ŀ
࠭ 1        
⮩        O R D E R S                                                
                                                                     
                                                                   Ŀ   
-           Order ID             Order Date         
 ĳĳ                                                         
            Client ID     Client Name        
                                                                      

                                    -- 19 --



                                                                          
                 
              I T E M S                                                   
                                                                          
                                                                     - 
-          Order ID Item No. Code Act. Price Quantity Item Total   
                
 ĳĳ          
                        
                        
                                                                      
                                                                          
                 
             Count: *0                                         <Replace>  
          


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

 
                      PL/SQL,            ॡ
                    易⥫쭮  祢 ᫮ BEGIN    END  
                    ଫ    믮塞   ஢.       
                    ᯮ짮        ⥪  ਣ஢,
                     ᠭ  PL/SQL ( .. V3-ਣ ).

ਫ
                    ଠ  㯯 ,   㤮⢮ 
                    㭪樨.  ਬ,     ந  ਫ,
                    㦠饥   ⢥ ⥬  .  ਫ
                     ⠪   ᥡ ࠧ ,    
                    㣨 .

᭮ ⠡     ,  ன ᮥ .


                                    -- 20 --




 ᭮ ⠡
                    , ஥ ᮮ⢥ ⮫  ᭮ ⠡
                    ,   ⨬ .

                (1)  ᪨        ଥ.     
                    ᮮ⢥⢮      ⠡             
                    ᮮ⢥⢮ .

                    (2) 㯯  PL/SQL.  . PL/SQL User's Guide and 
                    Reference .

ﭭ ⥪
                    ,   ᥣ   ଥ  ६  
                    ᪠.      ⠪ ⥪ -  
                    ,   ࠧ  㪠    䨪  -    ०
                    ࠭ ।஢.  . 㭮 1-5. ﭭ
                    ⥪  뢠 ⥪⮬ "⥫쭮 ".

⥪
                    楯,   ᯮ, ⮡ ।, 
                      ।     ⥪騩
                      ७ 䥩 SQL*Forms(Design).

ࠡ稪
                    ⥫   ਫ      ணࠬ,    
                    ᯮ  SQL*Forms    ࠧࠡ⪨    䨪樨
                    .

        
 ࠭,   뢮   ࠭  ਭ -
᪨ .   筮  ᢥ祭묨    ભ묨.
뢮        ᮮ⢥⢮        ⮫殢
⠡ . . 㭮 1-5.

         ଠ
᪨  , , ਣ஢  楤 ஢ . ।
   ०  ࠡ ਫ      ⢨  ஬.
  믮 ,    뤠  ᢮    
 ࠭ ନ.

         楤 ஢ 
    PL/SQL,     ॡ  ᨭ⠪ PL/SQL.  
 뫠  ⠪ 楤  ⥪ V3-ਣ஢ .

쭠           ࠭ ,  ᯮ  
६           ଠ.   ଠ ᮧ  ६,
                    SQL*Forms ন    "ᯮᮡ"  -
                     ਫ      ,   -
                    ᫥ ଠ   㤠   .

樮      짮⥫  ஫, 室  ࠡ 
ࠬ           RDBMS ORACLE.  ࠬ 筮 ⫨  
                    ॣ樮 ࠬ஢  樮 ⥬.

   ,   뢮  ࠭ , 祬 
                        맮. . 㭮 1-4.


                                    -- 21 --



ꥪ             (1) 㯯 , ⠪  ଠ,   ਣ,
                        ஢,  ६  㤠
                      .

                    (2)  㯯    ORACLE ⨯ ⠡
                     .

             짮⥫ ਫ SQL*Forms.

           楤
   ஥ 楤 PL/SQL, 㯭  SQL*Forms.   㯠
楤  믮  । 㭪  SQL*Forms  ⨯  ⪨  
 믮 .

         ࠭
 뢮  ଠ樨.  筮 ਭ樯 ஥樨  ᫠, ࠭
뢮   ﭭ ⥪  ࠬ             ࠭
ନ,     믮 .  ଠ 筮    
࠭        ⮫쪮 ࠭, ᪮쪮   ᮧ. .
㭮 1-4.

砭:  ..  ࠭   ࠧ  ᢮ ࠧࠬ  
४뢠    㣠,       ࠭  뢮
,  祬   ࠭     ६,   
࠭.

         ᯫ뢠饥 
ꥪ SQL*Forms,  ४뢠  ⥪饣 뢮  ࠭.
SQL*Forms 뢮 ᯫ뢠饥   ⢥   ᮡ  ⢨
짮⥫.  ᯫ뢠饥        뢠饩  ࠭楩,
ᯫ뢠騬   ᯨ᪮   祭        ᯫ뢠騬 ।஬ .

                    ப  ⠡    㠫쭮
                    ⠡,   ।⠢  ଥ.

 ⢨    ,   ,   ன  ਣ.  
                     । ஢ ( ଠ,    ),
                     ஬ ।  ਣ.

࠭ ।   "    "   SQL*Forms,          
                    ஢  .  ࠭ । 뢮
                     ࠭  ࠭筮.

    ,      ⮫쪮     
                    맮. . 㭮 1-4.

⥬ ६   ﭨ  㦥 ଠ樨,  
                    ᮤন  ଠ    ଥ    ꥪ  ଥ.
                    ਬ,  ⥬ ६    ᮤঠ  
                    ⥪饣   祭 ⥪饣 .

ਣ               ,    믮,   ᪠
                    ("is triggered")  ᮡ SQL*Forms(Runform).

         ନ 
㭮 1-6   ᭮ ନ ५樮 .    㭪樨
 ᠭ   "ORACLE RDBMS Database  Administrator's Guide" .


                                    -- 22 --



         㭮 1-6
          Ŀ
                                                                   
⠡                                                                 
                                                                          
⮫ĳĿ                                                   
                                                                         
              Ŀ                                              
                    ORDERID   ITEMID  PRODID  ACT. PRICE  QTY  ITEMTOT    
                                 
                        610        3   10890          58    1       58    
                        611        1   10861          45    1       45    
                        612        1   10860          30  100     3000    
                        681        1   28837         2.4    1      2.4    
பĳ[     682        1   10870         2.8   20       56  ] 
                        684        2   10890          58    3      174    
                        604        3   10886          42    2       84    
                        603        2   10868          44   10      440    
                        618        1   10960          56    4      224    
                                                            
                                                                          
          

        ⮫
  ⠡    -  "⨪쭠"  㯯  ⮢, ।⠢  ⨯
. . 㭮 1-6.

࠭祭         ࠢ, ࠭稢饥   (⨯ ࠭祭
                    NOT NULL    ⮫),  ஥      ஢
                     ᨫ쭥, 祬  ஢ ꥪ  ਫ.
 
                      ⠡   㠫 ⠡,  묨 
                     .  ᭮ 筨 ଠ樨 
                    ORACLE RDBMS.

                   ⠡, ࠢ塞  ᫮६ .

     짮⥫ ORACLE,  믮 ⨢-
(DBA)                㭪樨  . DBA 祭 ࠧ  ⬥
                    ࠢ   㯠    㣨    짮⥫        ,
                    ஢ 樨 ORACLE,     ࠡ
                       짮⥫   ,        믮    㣨
                    ⨢ 㭪樨.

      祭 ⮫   ⠡, ஥ 뫠 
                    ࢨ   㣮 ⠡.

              易⥫쭠   ,   易     ⠡楩,
                     ᯮ RDBMS    ண  ᪠
                    ப   ⠡  (  易⥫쭮 )  ⮣,  ⮡
                    ᯥ 㭨쭮  ப.

         ஢
  ࠭祭, ஥ 砥 ६ ࠢ - ,   ࠢ,
 ᮬ   (ਬ, ⠡楩  ப) ⤥쭮 짮⥫.
஢   ।࠭      㣨 짮⥫ﬨ   ,



                                    -- 23 --



            ⨬ 짮⥫.    ஢
 ࠬ   믮   ࠧ  ४஢  
᭮  楫⭮ .

ࢨ       ଠ,  ᯮ㥬  䨪樨  ப  
                    ⠡.  ⭠  .
ப                 ⠡    -  "ਧ⠫쭠"  㯯  祭
                    ⮫殢. . 㭮 1-6.

SQL                   ,    ᪮  ,   
                       ᭮   䥩ᮬ   짮⥫   
                    ࠭    ᪠  ଠ樨       ORACLE.   
                    쭥襩  ଠ樨   SQL    "SQL 
                    Language Reference Manual" .

             ᭮    ଠ樨    ⥬   ࠢ
                    ५樮묨    .   -  㬥ୠ
                    "⪠",   ⮨   ப    ⮫殢.  .
                    㭮 1-6.

࠭          ᪠  ࠡ.  ⥪  ࠭
                      㯯  ᮡ⨩,    ந室 
                    ᫥騬 ᮡﬨ:  짮⥫  ᮥ  
                    ORACLE,  ᮥ  ORACLE, ।  
                     (commit)  ⪠뢠   (rollback).


            2        

    ᮤন  ⪨  蠣  ᠭ  롨ࠥ , 
 믮   SQL*Forms(Design).   ⭮,    ।
ଠ    楤    ,     믮  ࠭
।  㣨 ᭮ .

ଠ  楤    ⮩    뢠   騥   ,
蠥   SQL*Forms.     ଠ樨   ⥫  頩
  "SQL*Forms  Designer's  Tutorial".

         ᭮ 

 ᥪ  ⪨ ᠭ  ᭮ ,   믮-
   䥩 SQL*Forms(Design).   ⭮,   ᥪ 砥
᫥騥 :  - ஢ ꥪ  饭  ; - ᮧ
ࠢ饣 ; - ᮧ   㬮砭; - ᮧ ; - ᮧ
; - ᮧ 㬥樨  ਫ; - 믮 ; - 
; - 맮 ࠪ⨢ help-⥬; - 㧪 ; - ४஢
; - ⨥ ; - 室  SQL*Forms(Design); - ࠭ ; -
 SQL*Forms(Design).


         ஢ ꥪ  饭  

1.  [Copy Object]  䥩 SQL*Forms(Design).
     室   ꥪ⮢.

2.  COPY  REFERENCE   Copy or Reference Object.
3.  祭  ଠ樨  室 ꥪ  [Next
   Field]  ६饭   .  室   ଠ,

                                    -- 24 --



   ⭮  ꥪ,     뢠. ਬ, 
   饭      㪠   (  짮⥫
   ORACLE ),  ⠪   ,  묨   易.

  砭:
     -     ⮫쪮  ⥬ ꥪ⠬,   
       ⥪饩 .
     -      ꥪ,   ⥪ ଠ. 
        ஢ ꥪ, ਭ騩 ⥪饩 ଥ, ⠢ 
       Owner  Form 묨.

     -    뫠  ﭭ ⥪.   ஢
       ﭭ ⥪, 㪠   "Text Page"  ࠭, ன
       ਭ  ⥪. ஢      
       ஢  ﭭ ⥪.

4.   ଠ   ꥪ.  㦭  
   ଠ  ꥪ, 㤠    㤠  饭.
   ਬ,  ஢    । , ஬ 㤥
   ਭ  ,  ,    㤥 뤠  ࠭
   (न X  Y,  ࠭ ).

5.  [Accept].
  SQL*Forms  室 ꥪ   ꥪ  뢠 室
  ꥪ   ꥪ.
⢥ ⥬:    饭  ꥪ⠬


          ࠢ饣 

1. 롥  Modify   .
   ଠ । ,  ⠡ ࠧ ࠬ஢ (spread
  table).

2.  ,  ⠡ ࠧ. ,  ।
   ࠪ⨪ Block Name   । ࠪ⨪

  Base Table.

3.  [Accept]   । .
4. 롥  Field   .
     .

5. 롥  Modify.
    ଠ । ,  ⠡ ࠧ.

6.  ,     ࠢ饬 .
   ,  ࠪ⨪ Base Table .

⢥ ⥬:   , ࠪ⨪
                    ࠢ騩 


            㬮砭

1. 롥  Default   .
   ଠ   㬮砭.


                                    -- 25 --



2.     㬮砭.
   㦭 । ᫥騥 ࠪ⨪ :
     -  ;
     - ᭮ ⠡;
     - ᫥⥫ ;
     - ᢥ稢 ;
     -  ப;
     -  ࠭;

3.  [Accept]   । .
  ⢥ ⥬:    , ࠪ⨪


          

1. 맮  । ,  ⠡ ࠧ
  ࠬ஢ । .

2. ᫨  室    ,  [Insert Record].
   SQL*Forms ᮧ    ६頥   .

3.   । ,  ⠡ ࠧ.  㦭
    ᫥騥 ࠪ⨪ :
     -  ;
     - ᫥⥫ ;
     - ⨯ ;
     - ࠭ ਡ;
     -  ࠭.

4.  [Accept]   । .
   ⢥ ⥬:    ,  筮 ०
                       , ࠪ⨪

            ࠭ ।

    ᮧ  ,          - 
 .   㤮 ᤥ   ࠭ ।.

1.  ࠭ ।    ,   
   ᤥ ࠩ  窮 .  [Select].

2.    ,    ᤥ ࠩ ࠢ
   窮 .  [Select].

3.  [Define Field].
   SQL*Forms ᮧ   ࠭ ।  뤠  ।
   .
4.   । .
5.  [Accept]   । .

          

1. 롥  New   Action.     New Form.
2.   Name  , ஥  ᢠ  ଥ.
    [Accept].
3. த ஥ , ।   ᮧ .

          㬥樨  ਫ

                                    -- 26 --



1.  ⥪饩 ,  ன   ᮧ 㬥. 
   ⠯ ॡ, ⮡ ଠ 뫠 㦥 㦥  .

2. 롥  Print Doc   Action.
     Print Doc.

3. 롥 ⨯ 㬥樨,    ᮧ.
      Print to File.

4. ᫨  ᮧ 㬥  饭  ꥪ⠬, 筮 ।
   ꥪ,  ண    ଠ    .
   ᯮ [Next Field]  ६饭  ﬨ.

5. ३   Name    䠩,    
    㬥.

6. ᫨    䠩, ३  ஫쭮 
   Send to Printer   [Select]  ⨢樨 ⮩ 樨.

7.  [Accept].
   SQL*Forms 뢠 㬥  㪠 䠩. ᫨  ࠫ 
   Send to File, SQL*Forms ⠪ 뫠 㬥  ⥬ ਭ
    㬮砭.
⢥ ⥬:   ਪ 㬥
                    ⥪

         믮 

। 믮,   ᪮,     㦥    
ଠ FRM. (   ᮧ FRM-䠩, ᣥ஢ . )

1. 롥  Execute   Action.
     Execute Form.  Name  㬮砭
  ᮤন  ⥪饩  ( ᫨  ⥪ ଠ ).

2.   Name 㪠  ,    .
3.  [Accept].
  SQL*Forms(Design) 뢠 SQL*Forms(Runform)  ᪠ 㪠 .
   襭   頥    SQL*Forms(Design).


          

1. 롥  Generate   Action.
      Generate Form.  Name  File
   ᮤঠ  㬮砭  ⥪饩  ( ᫨  ⠪ ).

2.      ᮡࠥ ஢   [Next Field]

3.   䠩,  ஬   ࠭ ᣥ஢ .
    [Accept].  SQL*Forms(Design)  㪠 .

砭: ᫨    ஢  ⥪饣 ⥪ ⮬-
            । 믮   SQL*Forms(Design),   
           Generate Before Executing Form.
⢥ ⥬:  SQL*Forms(Design) 樨 ।   믮 



                                    -- 27 --



         맮 ࠪ⨢ help-⥬

1.  祭   ⭮ ⥪,  [Help]   
   SQL*Forms(Design).   祭    help-⥬,
   롥  Help System   Help   [Help]   窨
   help-⥬.

2.  室  help-⥬ 롥 Exit   help-⥬.
⢥ ⥬:    Help-⥬


         㧪 

1. 롥  Load   Action.     Load Form.
  砭: ᫨  ⥪ ଠ, SQL*Forms 뤠 ।०,
             祭 ண   ⢥न.

2.   File   INP-䠩, ஥ ᮮ⢥ ଥ,  
    㧨.  [Accept].  㦥 ଠ ⠭ ⥪饩.
  ⢥ ⥬:    ଠ INP-䠩


         ४஢ 

1.  ଥ । ,  ⠡ ࠧ ࠬ஢ ।
   , ᤥ ⥪饩 , ᮮ⢥ , ஥  
   ४஢.

2. 믮 㦭    [Accept]  ࠭ 
   .


         ४஢   ࠭ ।

  室  ४஢   ,   ,   ᤥ
,    ࠭  ।.  ,  ⢨⥫쭮,  
쭮 .


1.  ࠭ । ६   , ஥  㦭
  ⪮४஢.  [Define Field].  SQL*Forms 뤠 
  । .

2.  室    [Accept]   ࠭.

         ⨥ 

1. 롥  Open   Action.     Open Form.
   砭: ᫨  ⥪ ଠ, SQL*Forms  ।।
              ,    㤥 ࠭.

2.    Name  ,    .
    [Accept].

  SQL*Forms ᪨ 㪠       ⥪饩.
  稭  ⮣ ,   ४஢ । .



                                    -- 28 --



         室  SQL*Forms(Design)

1. 롥  Quit   Action.
  ᫨  ந    ࠭ ,  ।०.
2. ᫨  ।०, 롥 室 .

         ࠭ 

1. 롥  Save   Action.
      Save Form.  Name ᮤন  㬮砭 
   ⥪饩 .

2.    Name ,     ࠭ .
    [Accept].
   SQL*Forms ࠭ ⥪   .


          SQL*Forms(Design)

1.  ⢥  ᪠ ⥬,  ᫥ :

   SQLFORMS [ options ] [ username/password ]
:

options        ।    ப, 
                 ⨢஢  ⮩ ᨨ ࠡ   SQL*Forms.


username/password  ।  짮⥫᪮   ORACLE    ஫.

  .

砭:  ᫨      㪠        ORACLE   ஫, SQL*Forms
            뢥 ࠭ ॣ樨,     .
⢥ ⥬:      ப

          ࠭ ।஢

 ᥪ  ᠭ    ᭮  ,     
믮   ࠭ ।.   ⭮,   ᥪ 뢠
᫥騥 :
- 롮 ꥪ⮢  ࠭ ।;
- 뢠  ⠭ ꥪ⮢;
- 㫨஢ ⢨ ࠭ ।;
- ᯮ짮 ﭭ ⥪.

         롮 ꥪ⮢  ࠭ ।

ᯮ [Select],        ꥪ,    㦭 ,
⠭   ।.  ꥪ,    , 
,  ࠭ ப  .           ,
  ࠭  ᥪ    ,   ᮤন,
室  ⥪饬 .
⢥ ⥬:    [Select]


     롮      樮   㦭    [Select].


                                    -- 29 --



     롮 ࠭ ப
1. ⠢     ப   [Select].
2. ⠢   㣮  ப   [Select].

         롮 
1.    ࠩ    [Select].
2.    ⨢ ࠩ     
   [Select].

         뢠  ⠭ ꥪ⮢

   ᯮ  [Cut]    [Paste],       ஢  , ,
६  㤠 ꥪ.  ꥪ,    襭  -
,    ,  ப    .        
  ,     ࠭  ᥪ    ,  
ᮤন,  室   ⥪饬 .

         뢠 ꥪ

    뢠 ꥪ,  ⠪ ࠧ 䥪⨢ 㤠 .
,  SQL*Forms  ࠭  ᠬ  ᫥  襭 ꥪ  ,
⠪    ⠭  -  ⮫쪮 ࠧ, ᪮쪮 
ॡ.
1. 롥 , ப  .
2.  [Cut].

         ⠭ ꥪ

  ᥣ ⠭ ꥪ,   室    paste  
騩 ꥪ⮬,     ᫥ 襭  ६  ⥪饩
ᨨ  SQL*Forms.      ⠭ ꥪ      
,      ࠭,   ⠭  頥 
࠭      ४뢠 㣮 .

1.   ⠬,   , ⮡   孨 ࠩ
   ꥪ.
2.  [Paste].

    ⠭  ,  SQL*Forms   ࠭  ᫥-
⥫  ⮣ .  ,  SQL*Forms 砥 ⠭
   ,   ᫥騩    ᠬ  訬 ᫥⥫ ஬, 㦥
ᯮ㥬  ⥪饬 .

         㫨஢ ⢨ ࠭ ।

    [Undo], ⮡ ⪠  襣 ᫥ ⢨   ࠭
।.  த  [Undo]  ᫥⥫쭮 ⪠  ।-
 ⢨ ( ᫨   諨  SQL*Forms  箬 -l,  ࠭稢-
 ࠧ   UNDO ⮫쪮   樨 ).

[Undo]     ࠡ  ଠ । ꥪ⮢  ⠡栬
ࠧ  ࠬ஢.   [Undo]  ⠪    ࠡ⠥    ﭭ ⥪⮬,
    ࠭ .

⨬,      ᢥ 㫨஢  ﭭ ⥪,
㫨஢ 㭪,   ४஢ ,  ⨯ [Cut]   [Paste].
⢥ ⥬:     -l, SQL*Forms(Design)


                                    -- 30 --



         ᯮ짮 ﭭ ⥪
ﭭ ⥪   ଥ ᥣ,   ᪠.
  ⥪     ,  ࠧ 㪠  䨪.

          ﭭ ⥪
⮡  ﭭ ⥪,  ᯮ樮  㤠,  㤠   
    ⥪,    稭 .     ﭭ
⥪   㣮    ࠭  ࠭,  ஬ .    室
  ० ⠢,  ⠪   ० ,     
⥪騬.

         ஢ ﭭ ⥪
 ।஢ ﭭ ⥪ ᯮ   [Delete Character]
 [Delete Backward]  㤠 ⥪.  (  ⠪ 롨  -
뢠 ⥪).  ᫨  ࠡ⠥  ० ,      
饣 ⥪.  ᫨  ࠡ⠥  ० ⠢,   
⠢ ⥪    樨 , ᤢ 騩 ⥪ ࠢ.

         ࠢ  ⥪⮬
ﭭ  ⥪  ਭ ࠭,    ।   .
⮬   ⠢ ﭭ  ⥪       ࠭  -  
,     ⥪騬   .    㤠 ,
  㤠 ﭭ ⥪,     ⨬ .

         ᮢ   
ᯮ      ᢮ ଠ  㠫쭮 뤥 ,
  ⪮ ﭭ ⥪.

        ᮢ 
1. 롥 ࠩ 窨 .
  砭: ..   ᮢ ⮫쪮 ⨪ 
  ਧ⠫ , ࠭ ࠩ 窨   
   ப  ⮫.   ᮧ   .
2.  [Draw Box/Line].

        ᮢ 
1. 롥  ࠩ 窨   .
2.  [Draw Box/Line].
⢥ ⥬:    ﭭ ⥪, । 筮 ०




















                                    -- 31 --
