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