







          SQL*Forms          Operator's Quick Reference


          Version 3.0        ⪨ ࠢ筨 




                        ORACLE













































                                    -- 45 --




         楤

         

1.   ⥬  ᯮᮡ.
2. ᫥  ᪠  RUNFORM   ஡.
3.   ᪠ .
4.   [Return].
5.   -짮⥫-ORACLE   [Next Field].
6.   ஫-ORACLE   [Next Field].
   SQL*Forms   ࠭ 饭  .


        ⠢  

1.  [Insert Record]  ३  ⮩ .
2.  祭  .
3.   ⥫ ᥩ   ᫥⥫쭮 
   ⢨.
4.  [Commit] ⮣,   稫    .

        ४஢ 

1. ४ 室 .
2.  [Commit] ⮣,   稫    .

         

1. ६     㤠塞    [Delete Record]
2.  㤠 㣨 ᥩ ६   㤠塞 
     [Delete Record].
3.  [Commit] ⮣,   稫    .

        롮ઠ  ᥩ  ⠡

1.  [Execute Query].
2.  [Next Field]  [Previous Record]  뢮 ࠭ ᥩ.


        롮 ᥩ  ।⢥  ᫮

1.  [Enter Query].
2.  祭   㤥 ந ⡮ ᥩ
3.  [Execute Query].


        롮 ᥩ ।⢮  ᫮ WHERE

1.  [Enter Query].
2. ६    (),  ஬    ६.
3.  稥 (:)     ६ (ਬ, :SAL).
4.  [Execute Query].
5.    QUERY WHERE,  ᫮ WHERE, ᯮ
    ६   .  ⠪  ᯮ짮
   易⥫ ࠧ ORDER BY. ਬ:

:SAL > 2500 ORDER BY ENAME, :SAL

                                    -- 46 --



        室  

1.  [Exit/Cancel].


        ନ  楯樨

ଠ         "।⢮ -஡", ஥  
                 ࠢ ,  ⠪  .

࠭         頥   ࠭. (ଠ 
                   ᪮쪨 ࠭).

            , ன ᮮ⢥  ⠡ 
               㠫쭠 ⠡ (view)    ᮤঠ  
                ᥩ ⠡. (⨧  
                  ࠭ ,   
                ᯮ  ᪮쪨 ࠭ .)

            ப ⠡  .

           ᢥ祭  ࠭,   뢮
                ਭ  祭.  筮
               ।⠢  ⠡  .

 
             Ŀ
          ĳ  
             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  
   >            
         >            
                        
Ĵ        >            
                                                                         
             
             Ŀ
                                                                         
               
              C L I E N T  D A T A                                       
                                                                         
   >        Client ID                                    
                                                                         
                    Name                 
                                                                         
                    Adress               
                                                                         
                    City                                 
                                                                         
                    State        Zip                       

                                    -- 47 --



                                                                         
                    Comment                 
                                                                         
             
 

          㭪樮 
        
  㭪樮 , ᫥  䠢⭮ 浪   㪮-
⢥, 㯭   ६ 믮 .    ࠧ  
ࠧ , ⮬   㬥 ਢ ᯨ᮪  㭪権, 
   .

  ᫥⥫쭮     ᮮ⢥⢨ 㭪- 
뢮  ࠧ  ஢  ORACLE  ࠭ (⠬   
஫   짮⥫).   뢠  㭪 
SQL*Forms  祭   .

砭:  ᠭ 㭪樮  ਢ  ᭮ 
            祭  㬮砭.


[Accept]            뢠    ਭ  

[Begining of Line]  ६頥    ᨬ ப.
                    㯭 ⮫쪮  ।.

[Block Menu]        뢠 ᯨ᮪    .     
                    ६        ᯨ᪠, ࠢ 
                    .   롨ࠥ      ,   
                    ६頥     .

[Clear Block]       ࠥ    ⥪饣   ᮧ    
                    . [Clear Block]      ஢ 
                      .

[Clear Field]       頥 ⥪饥       .
                    ᫨  室  ࠩ ࠢ 樨,
                     頥  .

[Clear Form/Rolback]
               頥   ⥪饩 , ⬥ 
               ஢ ⠢, , 㤠  
                . [Clear Form/Rolback]   
               ஢ .

               [Clear Form/Rolback]  ஢  ⠢,
               㤠,  ᫠  .
               [Clear Form/Rolback]  㤠   , 
               ⮫쪮 㤠   ࠡ祩 .

[Clear Record] 頥 ⥪  ⥪饣 , ⬥  
               ஢  ᮢ襭   .
               頥   㤠  㤠  
               .

[Commit]       ஢     ந ᫥
               ᫥  [Clear Form/Rolback]  [Commit].

                                    -- 48 --



[Count Query Hits]
               頥 ⥪騩   뢮 ⢮ ப,
                  ࠭, ᫨ 믮 
               ([Execute Query]). ᫨  室  ० 
               , ⥪騩   㤥 饭.

                ᯮ ०   ᫥ 
               [Enter Query], [Count Query Hits] 뢠
               ⢮ ᥩ 㤮⢮  ᪠.

               砭:  ⨥ [Count Query Hits] ᫥ 
               [Execute Query] 㭨⮦ , 頥  
                ࠡ祩   뢠    ⠡,
                  ࠭ .

[Cut]          p  ⥪, ᫥ ⮣   뫠 ࠭ 襩 
               [Select]  ࠭   . 㯭 ⮫쪮  ।.

[Delete Backward]    ᨬ ᫥  .

[Delete Character]   ᨬ  ⥪饩 樨 .

[Delete Line]        ⥪ ப     .
                    㯭 ⮫쪮  ।.

[Delete Record]        ࠭    .  
                    㤠      ,   ஢
                        (commit).

[Display Error]     뢮 ଠ  訡 / 襭 
                    ᯮ⥫ ଠ, ᫨ ,    
                    ஬ ᫥ ࠧ ந諠 訡.

[Down]              ६頥     ᠬ  ᫥饩 .
                    ᫨ ᫥   , [Down]   ६頥 
                      ࢮ   .     । [Down]
                    ६頥       ப.

[Duplicate Field]    祭   筮  ।饩 
                    .

[Edit]              뢮 ,  ஬   ४஢
                    .
                    [Edit]  ४⥫-   ன ࠧ,
                    ᮤন  ਭ ணࠬ  ⥬ 
                    祧. ⮡ ⬥ १ ४஢ 
                       [Exit/Cancel].

[End of Line]       ६頥    ப. 㯭  ।

[Enter]             ।  ஢ઠ ,   ஢ 
                      .

[Enter Query]       頥 ⥪騩      ਩
                    ᪠.




                                    -- 49 --



[Execute Query]     頥 ⥪騩   롨ࠥ    ⠡
                     ,  ᮮ⢥ . (뢮
                    ⮫쪮  ,     ନ).

                    ᫨ [Execute Query] ᯮ ᫥ [Enter Query],
                      롨  㪠  .

[Exit/Cancel]       室    頥  ⥬ 
                    ᪠. [Exit/Cancel] 蠥 ࠡ 
                     뢠 㭪 [List].

                     ।, ࠡ⠥  [Undo], ..
                    ⠭   ஢  
                    ᥠ. [Exit/Cancel] ⠪ 㡨ࠥ  ।.

[First Line]        ६頥     ⥪  .
                    㯭 ⮫쪮  ० ।஢.

[Help]              뢮 ⪮ ᯮ⥫쭮 ᮮ饭  ⥪饣
                    . ୮ ⨥ [Help] 뢮, ᫨ 㯭,
                    ७ help-ଠ   .

[Insert Line]       ⠢  ப   窥 । 
                     ᮧ  ப ᫥ ⥪饩. 㯭 ⮫쪮
                     ।.

[Insert Record]     ⠢   ᫥ ⥪饩.

[Insert Replace]    ४⥫  ०    ᨬ.

[Last Line]         ६頥   ᠬ ᫥ ப ⥪.
                    㯭 ⮫쪮  ।.

[Left]              ६頥     ᨬ ( 
                     ப)

[List]              뢠 ᯨ᮪ 祭, ᫨   
                     .   ⨯ ᯨ᪮:

                    1. ᫨  ᯫ뢠饥 ,  㤥 뢮
                      㯭    ᯨ᮪   祭 
                     ⥪饣 .  ⮡  祭,  -
                    ਩ 롮   㯭      [List].
                    SQL*Forms  믮 ⡮      ᯨ᮪. 
                    ᯮ    ࠢ ஬  
                    [Scroll Up]  [Scroll Down]    ६饭  ᯨ. 
                     [Select]  롮   祭  㤠 . 
                     [Exit/Cancel]    ⪠  롮 祭.

                    2. ᫨ 祣  뢥,    [List],
                      㤥 뢠  祭  
                    ⥪饣 .  [Next Field], ⮡ ᬮ 
                    ᫥⥫쭮 祭. ⮡ ᤥ 롮 
                     [Exit/Cancel].





                                    -- 50 --



[Lock Record]        ⠪ ࠧ,  㣨 짮⥫
                          ,    
                     ४஢. [Lock Record]   
                         , ஥ 饭
                       ४஢.

[Menu]              뢠   SQL*Forms, ᫨  㯭.

[Next Block]        ६頥   ᫥騩  . (᫥⥫-
                     室 ⠭ ࠧࠡ稪   ).

[Next Field]        ६頥   ᫥饬 㯭  
                     ⥪饩 . (᫥⥫쭮 室
                    ⠭ ࠧࠡ稪 ).

[Next Primary Key Fld]
                    ६頥    ᫥饬 㯭  
                     ⥪饩 , ஥  
                    ࢨ筮 -   ࠭ 㭨쭮
                    ப ⠡  .

[Next Record]       ६頥   ᫥饩  ⥪饣 .
                    ᫨ ᥩ  , [Next Record] ᮧ 
                     .

[Next Set of Records]
                    롨ࠥ ᫥騩  ᥩ (⢮
                    ⠭ ࠧࠡ稪)  ᥩ 㤮⢮
                    ⨢ .

[Paste]             ⠢ ⥪   㤠,  ⠭ 

[Previous Block]    ६頥   ।騩  .
                    (᫥⥫쭮 室 ⠭
                    ࠧࠡ稪 ).

[Previous Field]    ६頥   ।饥 㯭  
                     ⥪饩 . (᫥⥫쭮 室
                    ⠭ ࠧࠡ稪 ).

[Previous Record]   ६頥   ।  ⥪饣 .

[Print]             뢠 ⥪騩 ࠭  䠩  訢 襣
                    ࠧ襭  .

[Refresh]           ᮢ뢠 ࠭.

[Right]             ६頥  ࠢ   ᨬ ( 
                     ப)

[Scroll Down]         ⥪饣   ᯨ᮪  (ਬ୮
                     80%), 뢮 ,  室  .

[Scroll Left]          ﬨ  ਬ୮    80%  
                    , 뢮 ᮤন   .

[Scroll Right]        뢮  ࠢ ਬ୮  80%   
                    뢮 , 뮤 ᮤন  饥  .

                                    -- 51 --



[Scroll Up]           ⥪饣   ᯨ᮪  ਬ୮
                     80%  , 뢮 ,  室
                     । .

[Search]            뢮      ᪠ 
                    饭.   אַ  ⭮ ࠢ 
                    ⮯ . 㯭 ⮫쪮  ०
                    ।஢.

[Select]            ந 롮 祭  ᪠   .

[Show Keys]         뢮 "" , .. ᮮ⢥ᢨ
                    㭪樮  蠬 .

[Transmit]          뫠   ନ    ஢ન
                     ⢥ত.

[Up]                ६頥   ⮦ ᠬ  ।饩 .
                     ।, [Up] ६頥     ப.


        㯯 㭪樮 

㭪樮   ࠧ  6 ⥣਩:
     -  ६饭 
     -  ।஢
     -  ࠡ⪨ 
     -  প  
     -  ࠡ   ०
     -   짮⥫

   ᯮ  ⥣ਨ,   筮 ,    
ᤥ,   㢥७  ࠢ쭮 롮 .

         ६饭 

[Block Menu]        [Next Record]            [Scroll Down]
[Down]              [Next Set of Records]    [Scroll Left]
[Left]              [Previous Block]         [Scrol Right]
[Next Block]        [Previous Field]         [Scrolll Up]
[Next Field]        [Previous Record]        [Up]
[Next Primary Key Fld]  [Right]


         ।஢

[Beginning of Line]  [Delete Backward]       [Insert/Replace]
[Clear Block]        [Delete Character]      [Last Line]
[Clear Field]        [Delete Line]           [Paste]

[Clear Form/Rollback]  [Edit]                [Search]

[Clear Record]       [End of Line]           [Select]
[Cut]                [First Line]


         ࠡ⪨ 


                                    -- 52 --



[Count Query Hits]  [Enter Query]           [Execute Query]

         প  

[Commit]            [Delete Record]        [Insert Record]

        K ࠡ   ०

[Enter]             [Lock Record]          [Transmit]

        K  짮⥫

[Block Menu]        [Exit/Cancel]          [Print]
[Display Error]     [Help]                 [Refresh]
[Duplicate Field]   [List]                 [Show Keys]
[Duplicate Record]  [Menu]


     SQL*Forms Operator's Quick Reference    Version 3.0

     Part No. 3704-V3.0 0789
     Copyright  ORACLE Corporation 1986, 1989





































                                    -- 53 --
