How to Create Pop Up Menus in Oracle Forms ?

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;"><br />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 <a href="http://www.siteforinfotech.com/2014/02/how-to-insert-navigate-delete-records.html" target="_blank">inserting, saving, deleting and navigating records </a>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.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXvVb6K31DEAg72yx_DMLsbogjIk2c5b2Oce3teldU_YJWAK6ca6TLrS6kscV-j47UsyKvP8ZfcSKLhwWejVCEOdU4Aj8Y71TqSTFlexPhjw_6Lkj3rjySt6eWN0fUGF4YStSQbJ1Quc5e/s1600/pop-up-menu-7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Pop Up Menus in Oracle Forms " border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgXvVb6K31DEAg72yx_DMLsbogjIk2c5b2Oce3teldU_YJWAK6ca6TLrS6kscV-j47UsyKvP8ZfcSKLhwWejVCEOdU4Aj8Y71TqSTFlexPhjw_6Lkj3rjySt6eWN0fUGF4YStSQbJ1Quc5e/s1600/pop-up-menu-7.png" title="Pop Up Menus in Oracle Forms " width="640" /></a></div><br /></div><div style="text-align: justify;"><h3 style="text-align: left;">Steps for Creating Pop Up Menus </h3><div><br /></div><div><span style="text-align: left;"><br /></span></div><div><span style="text-align: left;"><span id="goog_1946110751"></span><span id="goog_1946110752"></span>1. At first create a form as the post "<a href="http://www.siteforinfotech.com/2014/02/how-to-create-oracle-forms-using-wizard.html" target="_blank">How to Create Oracle Forms by Using Wizard ?</a>"  .  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.</span><br /><a name="more"></a><br /><span style="text-align: left;"><br /></span><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1S7V-0BXrapBYIeJv68RfkiQIpij3Qr7UaFB00wN2CtDW8EkcGB8ehc_QmCnRgNmhrB2U-hz6vTN5rrPQDu0WUYR-SayGyInCBtQ3rR1L9ai5kqVyaDfvWkx5Y7sAUQ0AriOwohelOYX_/s1600/pop-up-menu-5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Menu Editor for Pop Up Menus in Oracle Forms " border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj1S7V-0BXrapBYIeJv68RfkiQIpij3Qr7UaFB00wN2CtDW8EkcGB8ehc_QmCnRgNmhrB2U-hz6vTN5rrPQDu0WUYR-SayGyInCBtQ3rR1L9ai5kqVyaDfvWkx5Y7sAUQ0AriOwohelOYX_/s1600/pop-up-menu-5.png" title="Menu Editor for Pop Up Menus in Oracle Forms " /></a></div><span style="text-align: left;"><br /></span><span style="text-align: left;"><br /></span><span style="text-align: left;">2. Add the items as given in the image below.  </span><br /><span style="text-align: left;"><br /></span><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgngK6i49-4Aq8jmJxk-a1nBxmrrsLymX4g9_ggGOsmmzH9W3p9g7I6webQeePIbTjg5hg8EQ-7S_LCaiKU0Sv4MqkJbRP3q3cWS_PioxujUTirpUx4o0dx5MOIsb9dzIebbDxSWisUhx1P/s1600/pop-up-menu-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Menu Editor for Pop Up Menus in Oracle Forms " border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgngK6i49-4Aq8jmJxk-a1nBxmrrsLymX4g9_ggGOsmmzH9W3p9g7I6webQeePIbTjg5hg8EQ-7S_LCaiKU0Sv4MqkJbRP3q3cWS_PioxujUTirpUx4o0dx5MOIsb9dzIebbDxSWisUhx1P/s1600/pop-up-menu-2.png" title="Menu Editor for Pop Up Menus in Oracle Forms " /></a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div><br /><div class="separator" style="clear: both; text-align: center;"></div></div><div><br /></div>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. </div><div><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2-baT6yf8Ma5kGStw24lr23DVs5sJH-PWKo_8Ww4zsgTBubtbjABL-A2jvy8HYNX8P3ZGlO_kx4Rkcoyisqg3DkOZNj3_CXctfyp7Q_vEKhYfXy_9H1fN7-k0kKn__fEkWX1zCgqkRecC/s1600/pop-up-menu-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="PL/SQL Editor for Pop Up Menus in Oracle Forms " border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj2-baT6yf8Ma5kGStw24lr23DVs5sJH-PWKo_8Ww4zsgTBubtbjABL-A2jvy8HYNX8P3ZGlO_kx4Rkcoyisqg3DkOZNj3_CXctfyp7Q_vEKhYfXy_9H1fN7-k0kKn__fEkWX1zCgqkRecC/s1600/pop-up-menu-3.png" title="PL/SQL Editor for Pop Up Menus in Oracle Forms " /></a></div><div><br /> 4<span style="text-align: left;">. Add the following PL/SQL queries in the PL/SQL editor for respected items.</span><br /><ul style="text-align: left;"><li>PREVIOUS:           previous_record;</li><li>NEXT:                  next_record;</li><li>FIRST:                  first_record;</li><li>LAST:                   last_record;</li><li>INSERT:               create_query;</li><li>CONDITION:        enter_query;</li><li>SAVE:                  commit;</li><li>DELETE:              delete_record;</li><li>EXIT:                  exit_form;</li></ul><div style="text-align: left;"></div><br />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.<br /><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjpcbHcYzlKMZxDKbSM3OcH-ZY7rqvsQKQgxDfbTzjEETs1dv-3E8FfP2PX-7OTtb511kVwrvEFJ9sEnKxt0VOqlATNNzcLdAfh5T6Y0JjuikacXbRTIGAnLCEFxeLjiKWuKpgvxTF9j1c/s1600/pop-up-menu-4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Property Palette for Pop Up Menus in Oracle Forms " border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgjpcbHcYzlKMZxDKbSM3OcH-ZY7rqvsQKQgxDfbTzjEETs1dv-3E8FfP2PX-7OTtb511kVwrvEFJ9sEnKxt0VOqlATNNzcLdAfh5T6Y0JjuikacXbRTIGAnLCEFxeLjiKWuKpgvxTF9j1c/s1600/pop-up-menu-4.png" title="Property Palette for Pop Up Menus in Oracle Forms " /></a></div><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><span style="text-align: left;"><span style="text-align: justify;">6. For assigning Pop Up menu on the form, right click on canvas and click on Property Palette option</span><span style="text-align: justify;">. From Popup Menu option under Functional property select the Popup Menu name as in the image below.</span></span><br /><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><br /><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghKMAwKh-td3kr_VGjwUZNyKggKpkQ8UIjcG8zJAoxUj5sC2rSPGpJADM1UYKyBgsWhLDQ5Y-ut3EvMopOyAF0EWYvr2I3iDw_EY1hWy-zHFVVsZ6WIVlG4XOx007UzdBAmkSaaESTRJYP/s1600/pop-up-menu-6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Property Palette for Pop Up Menus in Oracle Forms " border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghKMAwKh-td3kr_VGjwUZNyKggKpkQ8UIjcG8zJAoxUj5sC2rSPGpJADM1UYKyBgsWhLDQ5Y-ut3EvMopOyAF0EWYvr2I3iDw_EY1hWy-zHFVVsZ6WIVlG4XOx007UzdBAmkSaaESTRJYP/s1600/pop-up-menu-6.png" title="Property Palette for Pop Up Menus in Oracle Forms " /></a></div><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><span style="text-align: left;"><span style="text-align: justify;">7. Save, Compile and Run the form. You can view the Popup menu while right clicking on form area.</span></span><br /><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><span style="text-align: left;"><span style="text-align: justify;"><br /></span></span><br /><h4 style="text-align: left;">Related Posts:</h4><div style="text-align: left;"><br /></div><span style="text-align: left;"><span style="text-align: justify;"></span></span><br /><ul><li><a href="http://www.siteforinfotech.com/2014/02/how-to-create-oracle-forms-using-wizard.html">How to Create Oracle Forms by Using Wizard ?</a></li><li><a href="http://www.siteforinfotech.com/2014/02/how-to-create-lov-oracle-forms-using-wizard.html">How to Create LOV in Oracle Forms Using Wizard ?</a></li><li><a href="http://www.siteforinfotech.com/2014/02/how-to-insert-navigate-delete-records.html" target="_blank">How to Insert, Navigate and Delete Records in Oracle Forms ?</a></li><li><a href="http://www.siteforinfotech.com/2013/11/image-slideshow-with-navigation-buttons.html">Image Slideshow with Navigation Buttons Using JavaScript</a></li><li><a href="http://www.siteforinfotech.com/2013/11/javascript-image-slideshow-with-links.html">How to Create JavaScript Image Slideshow with LInks</a></li><li><a href="http://www.siteforinfotech.com/2013/04/how-to-write-program-in-c-using-for-loop.html">How to write a program in C using for Loop?</a></li><li><a href="http://www.siteforinfotech.com/2013/07/create-simple-image-slideshow-using-javascript.html">How To Create Simple Image Slideshow Using JavaScript ?</a></li><li><a href="http://www.siteforinfotech.com/2013/08/create-simple-javascript-fade-effect-animation.html">How to Create Simple JavaScript Fade Effect Animation?</a></li><li><a href="http://www.siteforinfotech.com/2013/09/simple-javascript-fade-effect-animation-using-jquery.html">Simple JavaScript Fade Effect Animation Using Jquery</a></li></ul></div></div></div>

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

مزيد من المعلومات »

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

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: justify;"><br />I have already described in my previous posts about <a href="http://www.siteforinfotech.com/2014/02/how-to-create-oracle-forms-using-wizard.html" target="_blank">creating oracle forms using wizards</a> and <a href="http://www.siteforinfotech.com/2014/02/how-to-create-lov-oracle-forms-using-wizard.html" target="_blank">creating list of values (LOVs)</a>. 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.</div><div style="text-align: left;"><br /></div><div style="text-align: left;"><br /></div><h3 style="text-align: left;"> Steps for creating Insertion, Navigational and Deletion Buttons </h3><div style="text-align: left;"><br /></div><div style="text-align: left;">1. At first create a form as given in the post "<a href="http://www.siteforinfotech.com/2014/02/how-to-create-oracle-forms-using-wizard.html" target="_blank">How to Create Oracle Forms by Using Wizard ?</a>"  then start to add the buttons on the form as given in the image below.</div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2hkl6X1RHbjRtq5DqzzLokGXuHIKjH5rrGxyB8VvSLcfhyphenhyphen-dX_OycIQgHjxGL9PCfA4Vk6tNK_f2ZR58gHxCgH6R1fy30oOOxGhdG0OE8BKvGFKYKh8-OoQMITwOA9kEeXReEfp63YtE2/s1600/form-navigation-1.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="creating Insertion, Navigational and Deletion Buttons " border="0" height="317" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi2hkl6X1RHbjRtq5DqzzLokGXuHIKjH5rrGxyB8VvSLcfhyphenhyphen-dX_OycIQgHjxGL9PCfA4Vk6tNK_f2ZR58gHxCgH6R1fy30oOOxGhdG0OE8BKvGFKYKh8-OoQMITwOA9kEeXReEfp63YtE2/s1600/form-navigation-1.png" title="creating Insertion, Navigational and Deletion Buttons " width="640" /></a></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><div style="text-align: justify;">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.</div></div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr8hh78j7heagDAvhmbHunG-qcXII-ClxmqzkYiCXEB_wPDrHvseEryqwLGuawfe_AgKT2rXhXwr3D19GDNXWsjkOnCyhT3ZtWIhyphenhyphenCJCyDpymtN3tQjfL5YxMDLBc5L16p_KEX7U7J3ey4/s1600/form-navigation-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Insert, Navigate and Delete Records in Oracle Forms" border="0" height="475" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr8hh78j7heagDAvhmbHunG-qcXII-ClxmqzkYiCXEB_wPDrHvseEryqwLGuawfe_AgKT2rXhXwr3D19GDNXWsjkOnCyhT3ZtWIhyphenhyphenCJCyDpymtN3tQjfL5YxMDLBc5L16p_KEX7U7J3ey4/s1600/form-navigation-2.png" title="Insert, Navigate and Delete Records in Oracle Forms" width="640" /></a></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><div style="text-align: justify;">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 <b>+</b> sign above to add new trigger. Find and select "WHEN-BUTTON-PRESSED" option and click on OK. </div></div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyrD8s_Mo8E4UR0eGsvj8TvNCq_E8ht6NQY4GEIbHFClKmRINWiyMYGXxITu30AL_wictyt9WVyBJs3aIoaMXQ-yMyJqawumFR7VcS5xxMlMiAiry4_AZxpSNDuR2_UZbIxxjo38xBDTgK/s1600/form-navigation-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="Using Triggers in Oracle Forms" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjyrD8s_Mo8E4UR0eGsvj8TvNCq_E8ht6NQY4GEIbHFClKmRINWiyMYGXxITu30AL_wictyt9WVyBJs3aIoaMXQ-yMyJqawumFR7VcS5xxMlMiAiry4_AZxpSNDuR2_UZbIxxjo38xBDTgK/s1600/form-navigation-3.png" title="Using Triggers in Oracle Forms" /></a></div><div style="text-align: left;"><br /></div><div style="text-align: left;"><div style="text-align: justify;">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 <i>commit; </i>given in the image below is for saving records in the database. </div></div><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPTLEBr-zoWiqokNI2hxUL1JVNKxwgQDWJH7pblhfHObUoNns3EuVdEJ7MMctcbiFIkNsDVWMa4Pp9pSuu3Q2CC0gk4K8G-TMNmGLGI6kF5spsQ-qahhZfcRy6ZREzEwir6whjIpQ676Ph/s1600/form-navigation-4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="PL/SQL editor window in Oracle Forms" border="0" height="428" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiPTLEBr-zoWiqokNI2hxUL1JVNKxwgQDWJH7pblhfHObUoNns3EuVdEJ7MMctcbiFIkNsDVWMa4Pp9pSuu3Q2CC0gk4K8G-TMNmGLGI6kF5spsQ-qahhZfcRy6ZREzEwir6whjIpQ676Ph/s1600/form-navigation-4.png" title="PL/SQL editor window in Oracle Forms" width="640" /></a></div><div style="text-align: left;"><br /></div><div style="text-align: left;">5. Add the following PL/SQL queries in the PL/SQL editor for respected buttons.</div><ul style="text-align: left;"><li>Show Record:       execute_query;</li><li>Previous Record:  previous_record;</li><li>Next Record:        next_record;</li><li>First Record:        first_record;</li><li>Last Record:         last_record;</li><li>Insert Record:      create_query;</li><li>Condition:            enter_query;</li><li>Save:                    commit;</li><li>Delete:                 delete_record;</li><li>Exit Form:           exit_form;</li></ul><div style="text-align: left;"><br /></div><div style="text-align: left;">6. After completing all the steps, run that form and test the buttons whether or not they are working.<br /><br /></div><br />  <br /><h4>Related Posts:</h4><div><br /></div><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2014/02/how-to-create-oracle-forms-using-wizard.html">How to Create Oracle Forms by Using Wizard ?</a></li><li><a href="http://www.siteforinfotech.com/2014/02/how-to-create-lov-oracle-forms-using-wizard.html">How to Create LOV in Oracle Forms Using Wizard ?</a></li><li><a href="http://www.siteforinfotech.com/2014/01/how-to-create-simple-menu-using-css.html">How To Create Simple Menu Using CSS ?</a></li><li><a href="http://www.siteforinfotech.com/2013/11/image-slideshow-with-navigation-buttons.html">Image Slideshow with Navigation Buttons Using JavaScript</a></li><li><a href="http://www.siteforinfotech.com/2013/11/javascript-image-slideshow-with-links.html">How to Create JavaScript Image Slideshow with LInks</a></li><li><a href="http://www.siteforinfotech.com/2013/04/how-to-write-program-in-c-using-for-loop.html">How to write a program in C using for Loop?</a></li><li><a href="http://www.siteforinfotech.com/2013/07/create-simple-image-slideshow-using-javascript.html">How To Create Simple Image Slideshow Using JavaScript ?</a></li><li><a href="http://www.siteforinfotech.com/2013/08/create-simple-javascript-fade-effect-animation.html">How to Create Simple JavaScript Fade Effect Animation?</a></li><li><a href="http://www.siteforinfotech.com/2013/09/simple-javascript-fade-effect-animation-using-jquery.html">Simple JavaScript Fade Effect Animation Using Jquery</a></li></ul></div>

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

مزيد من المعلومات »

How to Create LOV in Oracle Forms Using Wizard ?

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: left;"><br /></div><div style="text-align: justify;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgj3wVOhhHZClF9boHiJusfjzWLMMTbeZ6aTuexQ7-iWGPXpBSnrLlhW5eviE66K_yTyXwKUnu9le_GPobwEU-oreXj7ayhIWDE_3nISU51d9HJVBp0yjyRJnZDvhB-S7W2x9DNca3e9mKZ/s1600/lov-wizard0.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="LOV in Oracle Forms" border="0" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgj3wVOhhHZClF9boHiJusfjzWLMMTbeZ6aTuexQ7-iWGPXpBSnrLlhW5eviE66K_yTyXwKUnu9le_GPobwEU-oreXj7ayhIWDE_3nISU51d9HJVBp0yjyRJnZDvhB-S7W2x9DNca3e9mKZ/s1600/lov-wizard0.png" title="LOV in Oracle Forms" width="320" /></a>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.<br /><br /><br /><br /><br /><h3>Steps for Creating LOV in Oracle Forms Using Wizard </h3><br /><br /></div><div style="text-align: justify;">1. To add a new List of Values, at first go to Object Navigator and click on LOVs option and click on <b>+ </b>sign above, then the following dialog box will appear.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1K0SIJUY0h1BjCLY_gVUCMb0ZfmE4jopokJL0r29w1exw3fUZrcRl1iwDtzlxYFmoR3oLetCYTR2JV8ZlX6ff4bCYo0g9lC5aE5aqUMRKaie1phU7M8NYGUchhtkJ5HUmhaV559xWg_Fq/s1600/lov-wizard.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -add LOV" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg1K0SIJUY0h1BjCLY_gVUCMb0ZfmE4jopokJL0r29w1exw3fUZrcRl1iwDtzlxYFmoR3oLetCYTR2JV8ZlX6ff4bCYo0g9lC5aE5aqUMRKaie1phU7M8NYGUchhtkJ5HUmhaV559xWg_Fq/s1600/lov-wizard.png" title="How to Create LOV in Oracle Forms Using Wizard ? -add LOV" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">2. Select the option "Use the LOV Wizard" to create from Wizard.</div><div style="text-align: justify;"><br /><a name="more"></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8Okalwv6Evl2HJvtLH0oHZRwLT01kajAYWpUhwPdQYe_Zda-7xCe3C-2sGp4TAjX5o3CebF8bguqr70WXWnKRvwg7yXY6W5JZUmVgitK1BLoOrnBAuqVs-UhHcAaNuNgWOYRNzFBe1A2j/s1600/lov-wizard2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -New Record Group" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg8Okalwv6Evl2HJvtLH0oHZRwLT01kajAYWpUhwPdQYe_Zda-7xCe3C-2sGp4TAjX5o3CebF8bguqr70WXWnKRvwg7yXY6W5JZUmVgitK1BLoOrnBAuqVs-UhHcAaNuNgWOYRNzFBe1A2j/s1600/lov-wizard2.png" title="How to Create LOV in Oracle Forms Using Wizard ? -New Record Group" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"> 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.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPRxF_kXm9SeiD_IMrSlVmhmAxP3bmcyzv2AUv-Xzj3WCyvk5ttujBnGsv555xmgJhIZf1cxQ9KyWafFvWVcBE9v0X8VM0lXky7n4-wr_S0z8Y1sVW4skVHZic8Hb3kivgWhnW02Jab4gx/s1600/lov-wizard3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Connect Database" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgPRxF_kXm9SeiD_IMrSlVmhmAxP3bmcyzv2AUv-Xzj3WCyvk5ttujBnGsv555xmgJhIZf1cxQ9KyWafFvWVcBE9v0X8VM0lXky7n4-wr_S0z8Y1sVW4skVHZic8Hb3kivgWhnW02Jab4gx/s1600/lov-wizard3.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Connect Database" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">4. Click on Build SQL Query button, give User Name, Passport and Database name and connect to the Database. Select the required Table from where you want to take the values.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi02PPfj8cNmi4XIH6jc8L-DDANtRRzjIhneO7qqPZrgUtCnDPGIEjFw4KBfON7aYzz0ub-1jWv2CcDmBp4GycVNFMAyOW6ItJl7gxsFaEA0NQb7YkiFieqUg2z6lkuLsw_W8t6J5LVXGsw/s1600/lov-wizard4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Select Table" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi02PPfj8cNmi4XIH6jc8L-DDANtRRzjIhneO7qqPZrgUtCnDPGIEjFw4KBfON7aYzz0ub-1jWv2CcDmBp4GycVNFMAyOW6ItJl7gxsFaEA0NQb7YkiFieqUg2z6lkuLsw_W8t6J5LVXGsw/s1600/lov-wizard4.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Select Table" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">5. Select the Columns which you want to display in the list and click on OK. Select all the columns on the LOV columns and go to next.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFD5RA5lpL_qxOIsTR-K0b79RyZdhfQ7Jbn5AEKLMi5-QI0yi1mnrkrHCHeXSoduS09zv8JcD7TpTaRPrjoAt0rYR2XebpnPpbryegu5JtyrU04l4pEObEdRFQKXjJIRqYovX2vwWn2CBt/s1600/lov-wizard5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Select Columns" border="0" height="391" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiFD5RA5lpL_qxOIsTR-K0b79RyZdhfQ7Jbn5AEKLMi5-QI0yi1mnrkrHCHeXSoduS09zv8JcD7TpTaRPrjoAt0rYR2XebpnPpbryegu5JtyrU04l4pEObEdRFQKXjJIRqYovX2vwWn2CBt/s1600/lov-wizard5.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Select Columns" width="640" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">6. Give the title what you would like to display in LOV window. Also select width, height and position of the LOV window.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjE2awNdgf5tJpmCbGKmT0TeyOgTIlgCdPjG5xmHZSPBOlNHgVoN_tRKzFmA3KUsCthByi7cbA395UJPQ_gv5gwvaMzWTtDCDuxkQ0nuMCMI9isjdpcfNJI_uOhQluua6XoxnyKAn1_OVc/s1600/lov-wizard7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Add Title" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjE2awNdgf5tJpmCbGKmT0TeyOgTIlgCdPjG5xmHZSPBOlNHgVoN_tRKzFmA3KUsCthByi7cbA395UJPQ_gv5gwvaMzWTtDCDuxkQ0nuMCMI9isjdpcfNJI_uOhQluua6XoxnyKAn1_OVc/s1600/lov-wizard7.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Add Title" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">7. Give the no of rows you want to display in LOV and select the check box having "Let the user filter records before displaying them", if you want to display the records with filter. Go to next and finish the wizard. Now the LOV is successfully created.</div><div style="text-align: justify;"><br /></div><div style="text-align: justify;"><br /></div><h3 style="text-align: justify;">How to Assign Value of LOV to the Column ?</h3><div style="text-align: justify;"><br /></div><div style="text-align: justify;">1. Right click on LOV name and go to property palette. </div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwwpb_Ubp-bxJMW89bo0G9kelWDtHw5iZdsWFv40ctdDU_Pdeg3qWuAnV8eGnIRVnyQhyYvG4y_BEwBC07v92l0K3Jn-M6IuGpAN0n6fVe-Rv_tRg7CxV9PSQJBTIj6Yghl8d1wzPeZx_b/s1600/lov-wizard8.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Property Palette" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjwwpb_Ubp-bxJMW89bo0G9kelWDtHw5iZdsWFv40ctdDU_Pdeg3qWuAnV8eGnIRVnyQhyYvG4y_BEwBC07v92l0K3Jn-M6IuGpAN0n6fVe-Rv_tRg7CxV9PSQJBTIj6Yghl8d1wzPeZx_b/s1600/lov-wizard8.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Property Palette" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">2. Under functional property go to column mapping properties, select the required column and click on browse and select the column to assign.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE0t4hsBWupDAArU0V1vofBicP3iKXC0GHLNYDwp406dAORDv9kHfJH55sMQDpI-PyuAml1wDfR4EMvDIiT59Ojas4t9PBrImODXeq0_LrXDqXJUTXvpjUlI5pBKR-KMiK4rydUH70cknz/s1600/lov-wizard9.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Lov Column mapping" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhE0t4hsBWupDAArU0V1vofBicP3iKXC0GHLNYDwp406dAORDv9kHfJH55sMQDpI-PyuAml1wDfR4EMvDIiT59Ojas4t9PBrImODXeq0_LrXDqXJUTXvpjUlI5pBKR-KMiK4rydUH70cknz/s1600/lov-wizard9.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Lov Column mapping" /></a></div><br /><h3 style="text-align: justify;">How to Display LOV Automatically on the Form ?</h3><div style="text-align: justify;"><br /></div><div style="text-align: justify;">1. Under functional property of property palette, go to "Automatic Display" option and change to "Yes".</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC_wKHEDQ1rgI3J7XbEk20VkNLs2EaAC-PkWMib58zLTwh505KMd7Vp13HIS2ecp8uezBzMylnVuA3gvulL-kHQVvyIInqfD9s-dqg4kljkVy-vfWlAjB02gRt113LQRmevyVUvdYR2Kqc/s1600/lov-wizard10.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create LOV in Oracle Forms Using Wizard ? -Automatic Display" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgC_wKHEDQ1rgI3J7XbEk20VkNLs2EaAC-PkWMib58zLTwh505KMd7Vp13HIS2ecp8uezBzMylnVuA3gvulL-kHQVvyIInqfD9s-dqg4kljkVy-vfWlAjB02gRt113LQRmevyVUvdYR2Kqc/s1600/lov-wizard10.png" title="How to Create LOV in Oracle Forms Using Wizard ? -Automatic Display" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">2. Go to "Automatic Skip" option and change to "Yes" to go to the next navigation automatically. </div><div style="text-align: justify;"><br /><br /><br /><h4 style="text-align: left;">Related Posts:</h4><h4 style="text-align: left;"> </h4><ul style="text-align: left;"><li> <a href="http://www.siteforinfotech.com/2014/02/how-to-create-oracle-forms-using-wizard.html">How to Create Oracle Forms by Using Wizard ?</a></li><li><a href="http://www.siteforinfotech.com/2014/01/how-to-create-simple-menu-using-css.html">How To Create Simple Menu Using CSS ?</a></li><li><a href="http://www.siteforinfotech.com/2013/11/image-slideshow-with-navigation-buttons.html">Image Slideshow with Navigation Buttons Using JavaScript</a> </li><li><a href="http://www.siteforinfotech.com/2013/11/javascript-image-slideshow-with-links.html">How to Create JavaScript Image Slideshow with LInks</a> </li><li><a href="http://www.siteforinfotech.com/2013/04/how-to-write-program-in-c-using-for-loop.html">How to write a program in C using for Loop?</a> </li><li><a href="http://www.siteforinfotech.com/2013/07/create-simple-image-slideshow-using-javascript.html">How To Create Simple Image Slideshow Using JavaScript ?</a> </li><li><a href="http://www.siteforinfotech.com/2013/08/create-simple-javascript-fade-effect-animation.html">How to Create Simple JavaScript Fade Effect Animation?</a> </li><li><a href="http://www.siteforinfotech.com/2013/09/simple-javascript-fade-effect-animation-using-jquery.html">Simple JavaScript Fade Effect Animation Using Jquery</a> </li></ul></div></div>

How to Create LOV in Oracle Forms Using Wizard ?

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

مزيد من المعلومات »

How to Create Oracle Forms by Using Wizard ?

<div dir="ltr" style="text-align: left;" trbidi="on"><div style="text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF21jnxiV1px0T7hMJ6bUeObK5waQ5Slt1wZsAb9dgnfDzrYu8-FQWzWHIXMSLABI-6N5N0Vz_d9oCVC3oDKX_gcNkaBbF9xjVDm6yZEmtyFZOAvvOONUW6NAO0CIrl1_n8XhaOqTiKZja/s1600/forms.png" imageanchor="1" style="clear: right; float: right; margin-bottom: 1em; margin-left: 1em;"><img alt="Oracle Forms Developer" border="0" height="201" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjF21jnxiV1px0T7hMJ6bUeObK5waQ5Slt1wZsAb9dgnfDzrYu8-FQWzWHIXMSLABI-6N5N0Vz_d9oCVC3oDKX_gcNkaBbF9xjVDm6yZEmtyFZOAvvOONUW6NAO0CIrl1_n8XhaOqTiKZja/s1600/forms.png" title="Oracle Forms Developer" width="320" /></a></div><div style="text-align: justify;">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.</div><div style="text-align: left;"><br /></div><h3 style="text-align: justify;">Steps for Creating Oracle Forms by Using Wizard</h3><div style="text-align: justify;"><br /><br />1. At first start Weblogic Server by clicking on Start Weblogic Server option under Oracle Forms of Oracle Instance from start menu.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGIH5rw1fATIwfJUycMx2Glo6ZLN-1OuXLVYKWOyyWx4S62VZW-_Iv8hebKH3BX7HAFrDZtp7GdlXHcTEcIy0QXEVBtIXD0EzZF2Fh9bJwV4IwRi8OD1YDSEhQaNFZ5RMe_PPaaKAwnYtv/s1600/WLS-server-start.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? -Start Weblogic" border="0" height="323" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgGIH5rw1fATIwfJUycMx2Glo6ZLN-1OuXLVYKWOyyWx4S62VZW-_Iv8hebKH3BX7HAFrDZtp7GdlXHcTEcIy0QXEVBtIXD0EzZF2Fh9bJwV4IwRi8OD1YDSEhQaNFZ5RMe_PPaaKAwnYtv/s1600/WLS-server-start.png" title="How to Create Oracle Forms by Using Wizard ? -Start Weblogic" width="640" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">2. Give your weblogic username and password.</div><div style="text-align: justify;">3. Start form builder application from the start menu, which is located under Developer Tools of oracle instance folder.</div><div style="text-align: justify;"><br /><a name="more"></a></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhwoAGh8NOinLsy0cpkpSRemrJ1uflYfU3G2pvTKnbzfMLQ5EHwR_m0Scor4bOeqfE8JV0M_1FlynVCq6X9HBp1XxjBY0IXlbgNElECtQjj1-oyp6oVjKESqCBweNWreKuADDFzPdFCvxx/s1600/start-form-builder.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Start Oracle Form" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhwoAGh8NOinLsy0cpkpSRemrJ1uflYfU3G2pvTKnbzfMLQ5EHwR_m0Scor4bOeqfE8JV0M_1FlynVCq6X9HBp1XxjBY0IXlbgNElECtQjj1-oyp6oVjKESqCBweNWreKuADDFzPdFCvxx/s1600/start-form-builder.png" title="How to Create Oracle Forms by Using Wizard ? - Start Oracle Form" /></a></div><div style="text-align: justify;"><br /></div><div style="text-align: justify;">4. After opening form builder application, Click on data block option and click on <b>+</b> sign above under forms module of Object Navigator.</div><div style="text-align: justify;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfs2pqRQMBIMMWuJ-CFkl6f4KTEBQC21TxN_yDDqtcZ9JD83Y-w3NaXh0PhaulgGH96MYHSOYZU9yPHsPgfIbWSe4UlyHmdbDBXU4psmawpDPBaJVfE7IWW3kDowgGdtYKxPZGE5uP2bSr/s1600/object-nevigator.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Object Navigator" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhfs2pqRQMBIMMWuJ-CFkl6f4KTEBQC21TxN_yDDqtcZ9JD83Y-w3NaXh0PhaulgGH96MYHSOYZU9yPHsPgfIbWSe4UlyHmdbDBXU4psmawpDPBaJVfE7IWW3kDowgGdtYKxPZGE5uP2bSr/s1600/object-nevigator.png" title="How to Create Oracle Forms by Using Wizard ? - Object Navigator" /> </a></div><div class="separator" style="clear: both; text-align: center;"><br /></div><div class="separator" style="clear: both; text-align: left;"> 5. Click on "Use the Data Block Wizard" option to create a form by using wizard.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkTIIIpcwzHtT7k6zymAsYlDlqJF2NoNWC1fIwUgmu1i_KdPs6uUFUifCR6DkG2wZEfu-MqxRW5Phsne7KiSSwRC1qrikzklKAYcLxSdpwVr-DM-wMMzFsWjiF9WOsoiD7Re3709x5WEhD/s1600/new-data-block.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - New Data Block" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhkTIIIpcwzHtT7k6zymAsYlDlqJF2NoNWC1fIwUgmu1i_KdPs6uUFUifCR6DkG2wZEfu-MqxRW5Phsne7KiSSwRC1qrikzklKAYcLxSdpwVr-DM-wMMzFsWjiF9WOsoiD7Re3709x5WEhD/s1600/new-data-block.png" title="How to Create Oracle Forms by Using Wizard ? - New Data Block" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">  6. Click on "Table or View" option to create from Table or View.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr4VGs0qPOpjHSNSen1A8zK0XUaYZiqfY6R-iswaJIdbST_VmigGK1VIJH2T7vCAiNXxfIcMMfw_3g8B2k5C-rjVqutkRfRQZmpq2fltwZX49ompvjZoMbefcnMEpsqnQrEPL5E-K3X6a0/s1600/data-block-wizard.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Data Block" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgr4VGs0qPOpjHSNSen1A8zK0XUaYZiqfY6R-iswaJIdbST_VmigGK1VIJH2T7vCAiNXxfIcMMfw_3g8B2k5C-rjVqutkRfRQZmpq2fltwZX49ompvjZoMbefcnMEpsqnQrEPL5E-K3X6a0/s1600/data-block-wizard.png" title="How to Create Oracle Forms by Using Wizard ? -Data Block " /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">7. Click on "Browse" button to open Table or View. Give User name, Password and Database name to connect to the database.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0kzhErc1_wBZIj2o0-SZvO_Y_YfD7-SfK76DQ4AuYwamHboJgRzB-cfXbG7XoclhHpeBpa1ea-ip6TbVt18kvOyfkASpflHf0Ox7Nsgd382jXwmELnqsWoAGtP466RAOAYEW1nkfbvqVJ/s1600/data-block-wizard-2.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Connecting Database" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0kzhErc1_wBZIj2o0-SZvO_Y_YfD7-SfK76DQ4AuYwamHboJgRzB-cfXbG7XoclhHpeBpa1ea-ip6TbVt18kvOyfkASpflHf0Ox7Nsgd382jXwmELnqsWoAGtP466RAOAYEW1nkfbvqVJ/s1600/data-block-wizard-2.png" title="How to Create Oracle Forms by Using Wizard ? - Connecting Database" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div style="text-align: left;">8. After configuring the Data Block, Click on "Create the data block, then call the Layout Wizard" option and finish the wizard.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5_xjA3ZyzC1pseXYnvR1FlRjK8jzfZpzX_5x9BylY4_gjHMTeHRVUhIt8XT3AjD5KvZVRQwkgE3ikJPBWzQ3OwCBKOmpKoajBkOA0twSlT94Lc0JVq3SB5-7pQpcrIhQsUhElbr7ANFF_/s1600/data-block-wizard-3.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Finish Data Block" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5_xjA3ZyzC1pseXYnvR1FlRjK8jzfZpzX_5x9BylY4_gjHMTeHRVUhIt8XT3AjD5KvZVRQwkgE3ikJPBWzQ3OwCBKOmpKoajBkOA0twSlT94Lc0JVq3SB5-7pQpcrIhQsUhElbr7ANFF_/s1600/data-block-wizard-3.png" title="How to Create Oracle Forms by Using Wizard ? -Finish Data Block" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">9. Select "New Canvas" option from the combo box to create New Canvas to locate data blocks physically.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB6KAUkpeBnlzx58tV6i2ffT2m5IZgylogPZQGKNIxn8KMS-tCnm2LFFPbpMbdNuLfDADsYgJGFGXrugLCm2kUtLi7QGZdKpOc44aZ3wlcIg6vGa-Nif0R6IpbTZHUmXf8s6lPr7_hWMl7/s1600/data-block-wizard-4.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Create Canvas" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjB6KAUkpeBnlzx58tV6i2ffT2m5IZgylogPZQGKNIxn8KMS-tCnm2LFFPbpMbdNuLfDADsYgJGFGXrugLCm2kUtLi7QGZdKpOc44aZ3wlcIg6vGa-Nif0R6IpbTZHUmXf8s6lPr7_hWMl7/s1600/data-block-wizard-4.png" title="How to Create Oracle Forms by Using Wizard ? - Create Canvas" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;">10. Specify the required Width and Height of the fields.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr7QcnGxbpU-ckMVzvDBQK7syjVuy8iUe1MzV75gnMCE-nT-QdCfEYwRNT7JFQeXcvQst2Z8EZANWfpE1PcLl0nmxYqbNVIXM6GP0bycxg4AB69fJ6UMEAcB9jZ-CFevZcaYOfWFtaMEpG/s1600/data-block-wizard-5.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - Width and Height" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhr7QcnGxbpU-ckMVzvDBQK7syjVuy8iUe1MzV75gnMCE-nT-QdCfEYwRNT7JFQeXcvQst2Z8EZANWfpE1PcLl0nmxYqbNVIXM6GP0bycxg4AB69fJ6UMEAcB9jZ-CFevZcaYOfWFtaMEpG/s1600/data-block-wizard-5.png" title="How to Create Oracle Forms by Using Wizard ? - Width and Height" /> </a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"> 11. Give the Title of the Frame, Number of Records to be Displayed and the Distance Between Records.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrdEsNltiBXMkXXdp-lR-ZK15rDWptXyPvD7jZhPwNnGgcIRnYFxcrFkVYLLalrxvlTDvRQFkzsxSDkGuAaLBrAtW0RYg_Uik-TRXO0P1-WSI0g36SZIZImG3vFzr10rA8n614xHyfphxo/s1600/data-block-wizard-6.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? - No of Records" border="0" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhrdEsNltiBXMkXXdp-lR-ZK15rDWptXyPvD7jZhPwNnGgcIRnYFxcrFkVYLLalrxvlTDvRQFkzsxSDkGuAaLBrAtW0RYg_Uik-TRXO0P1-WSI0g36SZIZImG3vFzr10rA8n614xHyfphxo/s1600/data-block-wizard-6.png" title="How to Create Oracle Forms by Using Wizard ? - No of Records" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"> 12. After completing the wizard click on Finish to finish the wizard. Then you can view the design view as below.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaRfLQa4AWo1AdX5dcyZfMwSL7h583_tPkb_ive_6PGlXLY2qy7FPc7y2ITmjZQ4uIbtUUsPTnmXjf1aMclxO_8A3Yxv83RTb5hB9bvl6fwrWF1mAv_iJGRjLfLHiekUy9NAPMzkoQEut_/s1600/data-block-wizard-7.png" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img alt="How to Create Oracle Forms by Using Wizard ? -Form Design View" border="0" height="379" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaRfLQa4AWo1AdX5dcyZfMwSL7h583_tPkb_ive_6PGlXLY2qy7FPc7y2ITmjZQ4uIbtUUsPTnmXjf1aMclxO_8A3Yxv83RTb5hB9bvl6fwrWF1mAv_iJGRjLfLHiekUy9NAPMzkoQEut_/s1600/data-block-wizard-7.png" title="How to Create Oracle Forms by Using Wizard ? -Form Design View" width="640" /></a></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"> 13. Run the form to view this form in browser.</div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><div class="separator" style="clear: both; text-align: left;"><br /></div><h4 style="text-align: left;">Related Posts:</h4><ul style="text-align: left;"></ul><br /><ul style="text-align: left;"><li><a href="http://www.siteforinfotech.com/2014/02/how-to-create-lov-oracle-forms-using-wizard.html" target="_blank">How to Create LOV in Oracle Forms Using Wizard ?</a></li><li><a href="http://www.siteforinfotech.com/2014/01/how-to-create-simple-menu-using-css.html">How To Create Simple Menu Using CSS ?</a></li><li><a href="http://www.siteforinfotech.com/2013/11/image-slideshow-with-navigation-buttons.html">Image Slideshow with Navigation Buttons Using JavaScript</a> </li><li><a href="http://www.siteforinfotech.com/2013/11/javascript-image-slideshow-with-links.html">How to Create JavaScript Image Slideshow with LInks</a> </li><li><a href="http://www.siteforinfotech.com/2013/04/how-to-write-program-in-c-using-for-loop.html">How to write a program in C using for Loop?</a> </li><li><a href="http://www.siteforinfotech.com/2013/07/create-simple-image-slideshow-using-javascript.html">How To Create Simple Image Slideshow Using JavaScript ?</a> </li><li><a href="http://www.siteforinfotech.com/2013/08/create-simple-javascript-fade-effect-animation.html">How to Create Simple JavaScript Fade Effect Animation?</a> </li><li><a href="http://www.siteforinfotech.com/2013/09/simple-javascript-fade-effect-animation-using-jquery.html">Simple JavaScript Fade Effect Animation Using Jquery</a> </li></ul><div class="separator" style="clear: both; text-align: left;"><br /></div></div>

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

مزيد من المعلومات »