Oracle Forms Customization

Objective

To create Forms for Banking Application Using Oracle 10g Forms as front end and Oracle 10g as backend.

Table Structure

Table 1. 

trans_detrails(trans_id,acc_no,cust_name,acc_type,trans_type,trans_date,trans_amt)
where acc_no is account reference,account type=[savings,current],transaction type=[deposit,withdraw]

Table 2.
account(acc_no,balance)

Software Requirements
[1] Oracle Forms 10G
[2] Oracle 10G

SQL Commands for Table Creation
Table 1. 
SQL > create table trans_detail(trans_id number, acc_no number , cust_name char(10), acc_type char(10), trans_type char(10), trans_date date, trans_amt number);

Table 2. 
SQL > create table acc(acc_no number,balance number);

Procedure to create Forms
1. To log on to Oracle10g Forms/Reports, go to Start Programs Oracle10g Developer Suite Forms Developer, click Start OC4J Instance after OC4J initialized, then click Forms Builder.
2. Immediately, you will see the window for Forms Builder
3. Double click Data Blocks, Select 'Use the Datablock Wizard' and click OK- -This is the easiest method to design a new form.
4. You will now see the Welcome to the Datablock Wizard Window. Click Next to proceed.
5. You will now see the window for the Datablock Wizard. Select Table or View and click Next.
6. You will now see the window that prompts you to select a table or a view--your form will be created based on this selection. Since no table or view is being shown, click on browse to look at the list of tables and views in your database.
7. Once you click browse, the connect window will appear. Type in your username, password and database to connect to the database.
8. You will now see the tables window. Select current users and tables and click OK.
9. You will now see the list of tables created in your database. Select Trans_details and click OK.
10. You will now see your selected table and its available columns on your screen. Click on the > to select one of the columns to be shown in your form; . You will now see this column under the database items selected sub-window.
11. To move the rest of the columns, simply click on the double right arrow and this will select all your columns in to the database items.
12. You will now see the Congratulations window. Make sure that "Create the data block, then call the Layout Wizard" is selected and click on Finish.
13. You will now see the Layout Wizard Welcome window, click next. You will see the following screen, click next.
14. select the items that you would like to show in the form. Make sure that the data block selected is Account and then click the double right arrow to move all the columns of the account block from the available items to the displayed items. Click on Next to continue.
15. The window with the prompt for the height and width of the items will appear. Click Next to accept the default values. The Layout Wizard will now prompt you to select the layout or view style of your block. Select Form and click Next.
16. The Layout Wizard will now prompt you to select a title for the form that you are creating. Type in Account Records. Click Next to continue.
17. Congratulations! You have now successfully created your first form. Click Finish to view your form.
18. You will now see the canvas view of the form that you have created.
19. You can now format the form manually. Click on the frame to select it. Then drag the frame to make it bigger.
20. You can now space out the data fields to make your form more visually appealing. You can do this by simply selecting the data field and dragging it to your desired area.