Oracle

Oracle Forms

• Connect Oracle Forms 11g to database 11g
• Change Module Name in Oracle Forms 11g
• Part 1: Create New Data Block Wizard in Oracle Forms 11g
• Part 2: Create New Data Block Wizard in Oracle Forms 11g
• Part 3: Create New Data Block Wizard in Oracle Forms 11g
• Part 1: Create Wizard Layout Oracle Forms 11g: Display in a frame on a canvas
• Part 2: Create Wizard Layout Oracle Forms 11g: Display available items
• Part 3: Create Wizard Layout Oracle Forms 11g: Select the Layout Style for your frame
• Part 4: Finish the Wizard Layout and display the new frame in the Layout Editor

Oracle Reports

• Connect Oracle Reports 11g to database 11g
• Create New Report Wizard in Oracle Reports 11g
• Choose The Type of Layout and Style Reports in Oracle 11g
• Choose a Data Source and Select Sql Query Builder for Reports in Oracle 11g
• Move Available Fields in Displayed Fields in Rreports Oracle 11g
• Select Available Fields in Reports Wizard to calculate totals
• Choose a Template for your Report Wizard in Oracle Reports 11g
• Run Module Report Editor Paper Design Oracle Reports 11g

First you need to copy the file tnsnames.ora from database folder to config folder from Oracle Middleware.

Open the Oracle Form Builder, go to File Menu and press Connect or just execute the command Ctrl+J.

On the last step, you need to enter the user name, password and the database name.

• Change Module Name in Oracle Forms 11g

Right-click on Form Module name, then choose Property Palette. On Property Palette just click on the name and write your module name.

Open the Oracle Form Builder, go to File Menu and press Connect or just execute the command Ctrl+J.

• Part 1: Create New Data Block Wizard in Oracle Forms 11g

First you must click on Data Blocks and the press the button Create. An alert with two option will appear, and here you choose: Use the Data Block Wizard.

Welcome to the Data Block Wizard! – Click Next to begin creating your data block.

Select the type of Data Block: Table/View or Stored Procedure.

• Part 2: Create New Data Block Wizard in Oracle Forms 11g

Press Browse button and will apper a small window with more choices: Tables, Views, Current user, Synonyms, Other users.

After you choose the table name, oracle forms will show all Available Columns from the table.
Here you can bring all columns from the table in your form or you can select just a few columns.

After you moved the items press Next.

• Part 3: Create New Data Block Wizard in Oracle Forms 11g