Link
BCIS 5420
Oracle 10G Form Builder and Report Builder
By Anna Sidorova
Tutorial plan
• Create, modify tables, insert, select data in SQL • Create interface in Oracle designer
– – – – Forms based on one table or two tables Custom forms A switchboard Reports
Introduction to Oracle Form Builder
2
By Anna SidorovaIntro to Oracle Form Builder
1
BCIS 5420
Example:
STUDENT
COURSE_STUDENT
Grade_ Level SR SO GR SR SR JR FR SR
SID 100 150 200 250 300 350 400 450
Name Jones Parks Baker Glass Baker Russell Rogers Jones
Major History y Acctg Math History Acctg Math Acctg History
Age 21 19 32 28 24 20 18 25
SID 100 150 200 200 300 400 400 400 450
CourseName MIS520 ACC220 MIS520 CSI312 ACC415 ACC220 CSI312 MAT101 ACC220
COURSE
Name ACC220 ACC415 CSI312 MAT101 MIS520
Time Room M-F9 BA110 MWF3 BA210 MWF8 SS213 MWF3 ES123 MWF12 BCIS4610, Spring 2009 BA224
Creating tables and inserting data in SQL Plus
• Start SQL Plus and log in • Download file Dev_Tutorial_SQL_SQL_Plus from the course web site • Create tables STUDENT, COURSE, COURSE_STUDENT • Insert data using INSERT statements
Starting Oracle Designer
4
By Anna SidorovaIntro to Oracle Form Builder
2
BCIS 5420
Start Oracle Form Builder
Introduction to Oracle Form Builder
5
CREATING A FORM USING A WIZARD
Introduction to Oracle Form Builder 6
By Anna SidorovaIntro to Oracle Form Builder
3
BCIS 5420
Oracle Form Builder
Introduction to Oracle Form Builder
7
Create a new form based on MODULE1
• Go to File/New/Form – a new module is added to your object navigator window • Click on MODULE2 and rename it into STUDENT
Introduction to Oracle Form Builder
8
By Anna SidorovaIntro to Oracle Form Builder
4
BCIS 5420
Create a data block based on a table
• Right click on the STUDENT module and select Data Block Wizard • Click next on the Data Block Wizard welcome page
Introduction to Oracle Form Builder
9
Oracle 10G Form Builder and Report Builder
By Anna Sidorova
Tutorial plan
• Create, modify tables, insert, select data in SQL • Create interface in Oracle designer
– – – – Forms based on one table or two tables Custom forms A switchboard Reports
Introduction to Oracle Form Builder
2
By Anna SidorovaIntro to Oracle Form Builder
1
BCIS 5420
Example:
STUDENT
COURSE_STUDENT
Grade_ Level SR SO GR SR SR JR FR SR
SID 100 150 200 250 300 350 400 450
Name Jones Parks Baker Glass Baker Russell Rogers Jones
Major History y Acctg Math History Acctg Math Acctg History
Age 21 19 32 28 24 20 18 25
SID 100 150 200 200 300 400 400 400 450
CourseName MIS520 ACC220 MIS520 CSI312 ACC415 ACC220 CSI312 MAT101 ACC220
COURSE
Name ACC220 ACC415 CSI312 MAT101 MIS520
Time Room M-F9 BA110 MWF3 BA210 MWF8 SS213 MWF3 ES123 MWF12 BCIS4610, Spring 2009 BA224
Creating tables and inserting data in SQL Plus
• Start SQL Plus and log in • Download file Dev_Tutorial_SQL_SQL_Plus from the course web site • Create tables STUDENT, COURSE, COURSE_STUDENT • Insert data using INSERT statements
Starting Oracle Designer
4
By Anna SidorovaIntro to Oracle Form Builder
2
BCIS 5420
Start Oracle Form Builder
Introduction to Oracle Form Builder
5
CREATING A FORM USING A WIZARD
Introduction to Oracle Form Builder 6
By Anna SidorovaIntro to Oracle Form Builder
3
BCIS 5420
Oracle Form Builder
Introduction to Oracle Form Builder
7
Create a new form based on MODULE1
• Go to File/New/Form – a new module is added to your object navigator window • Click on MODULE2 and rename it into STUDENT
Introduction to Oracle Form Builder
8
By Anna SidorovaIntro to Oracle Form Builder
4
BCIS 5420
Create a data block based on a table
• Right click on the STUDENT module and select Data Block Wizard • Click next on the Data Block Wizard welcome page
Introduction to Oracle Form Builder
9