السلام عليكم ورحمه الله وبركاته


ده فهرس باهم مواضيع الاوركل للمبتدئين
 

 

Forms.rar

شكرا لك ووفقك الله لكل ما يحبه ويرضاه
وبالتوفيق

بارك الله فيكي و الى الامام ان شاء الله

جزاك الله خيرا

السلام عليكم ورحمة الله

هذا هو محتوى الملف المشار اليه فى المشاركة الاولى

ch 1  Introduction   -------

ch2  creating 1 table into 1 canvas and  1 window   ------

ch3  creating 2 tables into 1 canvas and  1 window -------- 

ch4  creating 2 tables into 2 canvas and 2 window ( connecting between window and canvas )  *******

ch5  Form and DataBlock propertty palette  ********

ch6  Text Item propertty palette    ********

ch7  LOVs and Editors   ******

ch8  Input Items  ****

ch9  Noninput Items  *******

ch10  Creating Different canvases  { content -  tab - stack  -  horizontal - vertical }

ch11   Alert  { Message Box }

ch12  Manipulating Triggers

ch13  Debugging Triggers

ch14  Menu

-----------------------------------------------------------------------------
Report
------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------

1}  change the module name  *****
2}  change the canvas name    LAYOUT 
3}  change the window name   
4}  create data block   --- table

-----------------------------------------
           No of canvas =  no of window  *******


----------------------------------------------
1}  creating 1 table into 1 canvas and  1 window    ----------

2}  creating 2 tables into 1 canvas and  1 window 

3}  creating 2 tables into 2 canvas and 2 window

--------------------------------------------------------------
 Data Block
a)    Data Block Wizard *****  نأخذ كل أعمده الجدول من قاعده البيانات

    Layout Wizard    نأخذ كل أو بعض أعمده الجدول من قاعده البيانات

   Form    ........   image أن يكون الجدول به 
            ........  Master table ( 1 )  ان يكون الجدول 

  Tabular   ......   Detail Table (  Many  )  أن يكون الجدول 

   Many - Many ---------   يتم تجزأه  الجدول وبناء جدول وسيط
   many وبذلك يكون عندنا  جدولين (1)  و جدول واحد 
   
      فى حاله وجود جدول واحد يمكن إستخدام أى نــــوع   

  Form      >>>>>>>  No of records displayed   =  1
  Tabular  >>>>>>>  No of records displayed      4 - 5 - 6 - 7 - 8 - 9 ( 7) 
  
  ----------------------------------------------------------
  من أجل الإستعلام عن السجلات المخزنه
  F8
  trigger  (  When new form instance ) >>>    execute_query;
  
  ------------------------------------------------------------
  F4    property palette شاشه الخصائص
  F3   object navigator
  F2   canvas ---------------------------------------------------------------------------

                   ---------------- Using   manual data Block-------------------------

with Buttons
---------------------------------------------------------

Exit  Button

When Button pressed   >>>>>> exit_form;
When Mouse Move >>>>>> exit_form;
When Mouse DoubleClick >>>

---------------------------------------------------------------------------------------------------

LOV 

1)   Using LOV as a list of values in the text item  *******

2)   Using  LOV as a parameter     ********

-------------------------------------------------------------------------------------

To display the LOV

a)  F3 --->   lov8 ----> F4 -----> Automatic Display  >>  Yes
-------------------
  F3 --->   lov8 ----> F4 -----> Automatic Display  >>  no
  
+   Command Button  >>>

DECLARE


x   boolean;


BEGIN x := show_lov('lov7');
   
END;
--------------------------------------------------------------------------------------------

----- Using Multiple LOV-------------


F3 -->  Lov8 -->  Tools >>  lov wizard >>>  ------------

----------------------------------------------------------------------------------------

2)   Using  LOV as a parameter 

-----------------------------------------------------------------------------------------

-------  ******    Chapter 8 Input Items   **********-------------------

1}  Text  Item  -------*****

2}  List  Item

3}  Radio Group

4}  Check Box

------------------------------------------------------------------------------------

List Item  >>>

1) on any item >>>  F4  
2) item type >>>   list item
3)  element in list >>> write your elements

-----------------------------------------------------------------------------------
Radio Group>>>

1) on any item >>>  F4  
2) item type >>>. radio group
3) F2 
4) F3
5) On item [ gender ]  create 2 radio buttons
6)  select the first radio button
7) F4
    a)  name >>> MALE
      label >>> Male
    c) Radio button value >>> Male
8)  F3
9) select the second radio button + F4
     a)  name >>> FEMALE
      label >>> Female
    c) Radio button value >>> Female

10)  F3
11) on the item  [ gender ] 
12)  F4
13)  Initial  value >>>> Male  [ Female ] 

---------------------------------------------------------------------------------------


**************************   CH 9  Noninput Items ********************

1-  Push Button   ****
2-  Image Button  ****
3-  Display Item  ****
4-  Formula Item
5-  Summary Item
-----------------------------------------------------------------------

create table empsal
( id number(10) primary key ,
 name varchar2(20),
 salary number(10)  );
--------------------------------------------------------------------

***creating formula item
1-  from toolbox create "display item "
2- F4
    a)  name --->  comm
   datatype ---> number 
 c)  database item --->  no
 d)  calculation mode --->    formula
 e)  Formula ***>    NVL (:empsal.salary,0) * 0.08

                TOTALIN= NVL ( :EMPSAL.SALARY, 0)  +  NVL( :EMPSAL.COMM,0) 

                 totalout =   nvl ( :empsal.tax, 0) * 1.5  

                  net  =     nvl ( :empsal.totalin,0 )  - nvl (:empsal.totalout,0) 

-----------------------------------------------------------------
*** creating summary item

1-  from toolbox create "display item "
2-  F4
    a)  name --> sumsal 
   datatype --> number
 c)  database item -->  no
 d)  no of items displayed --> 
 e) calculation mode -->>> summary
 f)  summary function --->  sum
 g) summarized block -->> empsal
 h)  summarized item -->  net
3-   F3
4- on block ( empsal)  +  F4
5-  Query all records >>   yes
---------------------------------------------------------------------------------------

Forms.rar

لطفا أرجو رفع الملف ... لأن تم حذفه من الموقع ...