Latest topics

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 queri...

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 ...

LOV (List of Values) in Oracle Forms are used to display the associated values while inserting values in forms. It makes the user easier to enter data on the forms. You can assign values in LOV statically or dynamically and can be displayed on the form manually or automatically. Filters can also be added on LOV to filter before display the list. Here I am writing some easy steps for creating List of Values in Oracle Forms using wizard. It may help you to learn the process of creating LOV in your Oracle Form. Steps for Creating LOV in Oracle Forms Using Wizard 1. To add a new List of Values, at first go to Object Navigator and click on LOVs option and click on + sign above, then the following dialog box will appear. 2. Select the option "Use the LOV Wizard" to create from Wizard.  3. Select the option "New Record Group base on query" to create new record group or select "Existing Record Group" to use existing Record Group and got to next. 4. Click on Build ...

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 Wizar...