Follow us: Connect on YouTube Connect on YouTube Connect on YouTube


Wednesday, 6 July 2016

Create Oracle Form Wizard

Open the Form Builder and select Data Blocks click on create button as shown bellow
Create new data block  by selected "Use data block wizard" and click on "OK" as shown below

Click on "Next" on following screen

Select the type of data block clicking on radio button "Table or View" and click on "Next" as shown below

Enter the "Table or View" Name Click on Refresh , it will ask for database username and password and click on connect on following screen
 It will show all the column which is available in table and you can select by clicking on arrow marks what columns are required  as shown bellow and click on “Next”

Enter the Data block Name and click on “Next” as shown below

Now Data Block Creation part completed and let us start create Layout of  form 
Select "Create Data Block, then call the Layout Wizard" radio button  and click on "Finish" as shown bellow

Let start Layout creation part 
Click on "Next" following screen 
 As per Business requirement you can select one of canvas on list of values
 Canvas Types:
                        Vertical Tool Bar
                        Horizontal Tool Bar
Note: Default Canvas is "Content"

Create Canvas as shown below screen click on "Next"

Now It will show available item whatever we have select on creating of data block
as show below screenshot 

By using arrow marks  you can select what field are need to be display on form as shown below and Click on “Next”
 On following screen you can change prompt field name and width and height as shown bellow and click on "Next"

You can select layout of report either Form or Tabular and click on "Next"

On following screen you can give details of  Frame Title ,Records Display and Distance between records and click on “Next” and "Finish"

Now your form ready to use 
Share this article :


  1. Hello There,

    Jeez oh man, while I applaud for your writing , it’s just so damn straight to the point Create Oracle Form Wizard.

    I have a number of table spaces based over a 4-year period and would like a script which when executed drops the oldest table space and data files after a period of 30 days / 60 days / 90 days etc - which will be executed via corn once per month
    Does anyone have a script where they can upload and I can test

    But great job man, do keep posted with the new updates.

    Kind Regards,

  2. Selamat Petang,

    The challenge however, is we don’t yet know how it will be used making to hard to assess their value proposition and consequently value.

    how to apply refcursor in package with multiple insted of multple cursors in oracle?

    Give one example.

    Thank you very much and will look for more postings from you.


  3. Hi There,

    Seems like I won the lottery here….This is a treasure box of blogs and your folks are like leprechauns! Phenomenal read on Create Oracle Form Wizard !

    I'd like to be able to log all constraint errors when users are running an application having Oracle as the back-end. That means inserting a record into an Errors Log table in Oracle.

    Is that even possible? In an exception clause, I could do that; however, when a constraint fails, I don't know where I'd be able to run such code to do the insert.

    Is this even possible?

    Thanks for any help you can give.


    Appreciate your effort for making such useful blogs and helping the community.


  4. You can't alter this area which gives connects to the Terms of Administration and Report Misuse pages. Wikipedia writers for hire

  5. Things happen for a reason is something I believe in. I also believe that I am the person I am because of my life experiences. Billdu invoice generator online