-
Copyrights 2010 - Online Training Oracle Applications. All Rights Reserved.
|
Developer 10g suite It consists of three components Oracle Forms Oracle Reports Oracle Graphics
Forms 10g
Allows to create components and navigate between other screens of forms.
Used to design application screens. Supports to create controls ( GUI Controls).
Used to assign properties for controls.
Used to provide code for procedures, functions, packages, triggers.
Used to design menus.
Used to make components like blocks, canvas, charts, LOV. Form Components
Represents collection of controls (items).
Block created based on table, view or synonym or stored procedure.
Block created without any table. It will not represent any table. Note
Shortcut keys
Wizards Create your first form using wizard Form Builder Tool We are done with datablock wizard , You will get ‘welcome to layout wizard’ We are done with layout wizard Go to File - Save As - Create new folder in desktop with the name MY_FORMS Important is to observe the object navigator ( Press F3 ) You can see under forms your form name i.e. EMP_FORM Under canvases, you can see a canvas Understand hierarchy. It is simple. Now, Compile the form. In the Menu, Go to Program - Compile Module ( Ctrl + T ) Note: To run the form, start the listener / Start OC4J listener Now, Run the form
It will prompt to install Jinitiator, Install it. Your Form is opened in the browser.
Now check your EMP table in the database, you can see the new row is inserted.
To look at all the rows in the emp table, click on execute query
To look at the next row click on next record. To change the salary of ALLEN from 1600 to 2000. Go to ALLEN record, change the value of sal field to 2000. To delete the row of empno 111, traverse the record, click on delete button and save. Look at the EMP table , empno 111 is deleted. To see the details of all the employees working in deptno 20. Assignment Create FORM using rail_reservation table.
|