Oracle Forms

Oracle Forms Oracle Forms Tutorial Under Development Tools Select Oracle for Windows (Other tools) Choose Oracle Developer 6.0 Form Builder Forms: Starting Developer At the “Welcome to Form Builder” Screen, make sure the “Use the Data Block Wizard” is selected and click “OK” Data Block Wizard At the initial screen click Next Make sure Table View is selected and choose Next Data Block Wizard: Part 2 At this Screen select the Browse Option Data Block Wizard: Part 3 A Connect screen will then appear. Enter your User Name, Password and Database that you were given for your Oracle Accounts Data Block Wizard: Part 4 At the Tables window, Choose Current User and Ok At the next Tables window, double click on the table you wish to create a form for. Data Block Wizard: Part 5 The Table and its fields will appear. If this is the wrong table click back and repeat from Part 2 Move all fields you wish to include in your Form to the right side Data Block Wizard: Part 6 After clicking Next, you will see the congratulations screen. Highlight the “Create the Data Block and Call Layout Wizard” button and select finish. Layout Wizard Select Next at the initial two screens Next, Select all fields you wish to include and move them to the right column Layout Wizard: Part 2 At this field you may edit the name and size of your attributes, but the defaults match your table definitions. When finished select Next Layout Wizard: Part 3 Select Forms and Click Next Title your record and Choose one Record to be displayed and click next Then Click Finish at the Congratulations Screen Adding more tables In some instances you will want multiple tables in your form. First, if your runtime screen is open, close it to get back to Developer. To add an additional table, go to the Tools menu then to Data Block Wizard. Adding more tables (cont.) After you choose the additional table, it will prompt you to make a join to the current table. To create a join: Uncheck the “Auto-join data blocks” box Click “Create Relationship…” Make sure the “Based on a join condition” radius is marked and click OK Choose the master table and click OK Match the Detail Item with the Master Item then click next Altering the Design  A window similar to this one will next appear.  You may drag and edit the fields in this window. Change font, size, height, width, location, etc.  You may also add triggers and specialized actions to the form using PL/SQL PL/SQL Stands for Procedural Language/SQL Implements application logic into SQL With PL/SQL you can write triggers that fire in response to the end-users actions (ex: press a button, execute a query, etc.) To learn more about using PL/SQL in forms, go to cbt.bus.iastate.edu and take a CBT (under Oracle Introduction and Oracle Database Programming) Run the Form Click the green stop light to run the Form (Forms Runtime) Entering Records You will now see your Form appear. To get to the next record, click the forward blue arrow When finished, click on the Open Teal Door and Save Changes Creating and Using Forms This will update your Oracle account adding all new records to your tables Learning more… To learn more about Oracle Developer: Goto: cbt.bus.iastate.edu Under Oracle Developer/2000 there are many CBTs to help.