How to Create Pop Up Menus in Oracle Forms ?

Pop Up menus are those, which are displayed on the screen when we right click on it. Pop Up menu makes any application easier to use it. In Oracle Forms also we can make pop up menus to add different menu items for the operating form.  The items for operations such as inserting, saving, deleting and navigating records can be included in the pop up menu. Here I have written some steps for creating pop up menus in Oracle Forms along with their screenshots.

Steps for Creating Pop Up Menus 

1. At first create a form as the post "How to Create Oracle Forms by Using Wizard ?"  .  Click on Pop Up option in object navigator, Click on plus + sign and rename the menu name. Right click on menu name and click on Menu Editor. Add the new items by clicking on plus down and plus right buttons as given below.

2. Add the items as given in the image below.  

3. Right click on menu items on the object navigator and click on PL/SQL Editor option. Write PL/SQL queries On the PL/SQL Editor window as given below. 

 4. Add the following PL/SQL queries in the PL/SQL editor for respected items.

• PREVIOUS:           previous_record;
• NEXT:                  next_record;
• FIRST:                  first_record;
• LAST:                   last_record;
• INSERT:               create_query;
• CONDITION:        enter_query;
• SAVE:                  commit;
• DELETE:              delete_record;
• EXIT:                  exit_form;

5. For adding Menu Item Type as Separator, go to Property Palette by right clicking on menu item and clicking on Property Palette option. Select Separator on Menu Item Type property under Functional property.

6. For assigning Pop Up menu on the form, right click on canvas and click on Property Palette option. From Popup Menu option under Functional property select the Popup Menu name as in the image below.

7. Save, Compile and Run the form. You can view the Popup menu while right clicking on form area.

Related Posts:

• How to Create Oracle Forms by Using Wizard ?
• How to Create LOV in Oracle Forms Using Wizard ?
• How to Insert, Navigate and Delete Records in Oracle Forms ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

How to Insert, Navigate and Delete Records in Oracle Forms ?

I have already described in my previous posts about creating oracle forms using wizards and creating list of values (LOVs). In this post I am going to describe How to create buttons for Inserting, Saving, Navigating and Deleting records in oracle forms. Insertion, Deletion and Navigation functions are necessary for manipulating data within forms whether it is greed line view or form view or any other format. You can add those buttons by simply adding push buttons from toolbox to the form and adding PL/SQL query in the button trigger using PL/SQL editor. Here are some steps for adding buttons on the form.

 Steps for creating Insertion, Navigational and Deletion Buttons 

1. At first create a form as given in the post "How to Create Oracle Forms by Using Wizard ?"  then start to add the buttons on the form as given in the image below.

2. Add push buttons in the form area from toolbox by clicking on it and drawing on the form. Then give a new name and label name as given in the image below from the Property Palette. You can open the Property Palette by right clicking on the button and clicking on Property Palette option.

3. After renaming and labeling the buttons, go to Object Navigator and expand the button name by clicking on the plus sign, then click on Triggers option and click on + sign above to add new trigger. Find and select "WHEN-BUTTON-PRESSED" option and click on OK.

4. A new PL/SQL editor window will appear as given below. Type the required query, save it and exit from the window. Repeat the same process for all the buttons you have created. The query commit; given in the image below is for saving records in the database.

5. Add the following PL/SQL queries in the PL/SQL editor for respected buttons.

• Show Record:       execute_query;
• Previous Record:  previous_record;
• Next Record:        next_record;
• First Record:        first_record;
• Last Record:         last_record;
• Insert Record:      create_query;
• Condition:            enter_query;
• Save:                    commit;
• Delete:                 delete_record;
• Exit Form:           exit_form;

6. After completing all the steps, run that form and test the buttons whether or not they are working.

 

Related Posts:

• How to Create Oracle Forms by Using Wizard ?
• How to Create LOV in Oracle Forms Using Wizard ?
• How To Create Simple Menu Using CSS ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery

How to Create Oracle Forms by Using Wizard ?

Oracle Forms is a technology developed by Oracle to develop database driven web applications quickly and easily. It is a component of Oracle Fusion Middleware Technology of Oracle corporation. By using Oracle Forms you can develop even advanced web applications more easily. While developing web applications, you can use graphical methods such as wizards for faster development. Here are some easy steps with screenshots for developing oracle forms by using wizard.

Steps for Creating Oracle Forms by Using Wizard

1. At first start Weblogic Server by clicking on Start Weblogic Server option under Oracle Forms of Oracle Instance from start menu.

2. Give your weblogic username and password.

3. Start form builder application from the start menu, which is located under Developer Tools of oracle instance folder.

4. After opening form builder application, Click on data block option and click on + sign above under forms module of Object Navigator.

 

 5. Click on "Use the Data Block Wizard" option to create a form by using wizard.

  6. Click on "Table or View" option to create from Table or View.

7. Click on "Browse" button to open Table or View. Give User name, Password and Database name to connect to the database.

8. After configuring the Data Block, Click on "Create the data block, then call the Layout Wizard" option and finish the wizard.

9. Select "New Canvas" option from the combo box to create New Canvas to locate data blocks physically.

10. Specify the required Width and Height of the fields.

 

 11. Give the Title of the Frame, Number of Records to be Displayed and the Distance Between Records.

 12. After completing the wizard click on Finish to finish the wizard. Then you can view the design view as below.

 13. Run the form to view this form in browser.

Related Posts:

• How to Create LOV in Oracle Forms Using Wizard ?
• How To Create Simple Menu Using CSS ?
• Image Slideshow with Navigation Buttons Using JavaScript
• How to Create JavaScript Image Slideshow with LInks
• How to write a program in C using for Loop?
• How To Create Simple Image Slideshow Using JavaScript ?
• How to Create Simple JavaScript Fade Effect Animation?
• Simple JavaScript Fade Effect Animation Using Jquery