Link

Only available on StudyMode
  • Topic: Oracle Forms, Oracle Database, SQL
  • Pages : 21 (2048 words )
  • Download(s) : 126
  • Published : January 11, 2013
Open Document
Text Preview
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

Creating a data block (cont’s)
• Select Table/view option • Select a table by clicking on Browse button

Introduction to Oracle Form Builder

10

By Anna SidorovaIntro to Oracle Form Builder

5

BCIS 5420

Selecting a table (cont’d)
• When you click browse, you will be prompted to log in • Login into your usual account and select table STUDENT from the displayed list

Introduction to Oracle Form Builder

11

Select database items
• Move all the attributes into selected attributes pane using arrow buttons

Introduction to Oracle Form Builder

12

By Anna SidorovaIntro to Oracle Form Builder

6

BCIS 5420

Name your data block

Introduction to Oracle Form Builder

13

Select the “… then call the Layout wizard” option

Introduction to Oracle Form Builder

14

By Anna SidorovaIntro to Oracle Form Builder

7

BCIS 5420

Creating a layout
• Layout wizard allows you to create a form layout • Click next on the welcome page and select content canvas type

Introduction to Oracle Form Builder

15

Select items to be displayed
• Select items to be displayed • Modify the labels (prompts) and widths of corresponding text boxes if necessary

Introduction to Oracle Form Builder

16

By Anna SidorovaIntro to Oracle Form Builder

8

BCIS 5420

Select a layout
• Select form layout • Name the frame • Select the number of students to be displayed

Introduction to Oracle Form Builder

17

Complete and view the form
• Complete and view the form design

Introduction to Oracle Form Builder

18

By Anna SidorovaIntro to Oracle Form Builder

9

BCIS 5420

MODIFYING A FORM

Introduction to Oracle Form Builder

19

Modifying the form
• To change color, select the form of its element • Go to Property palette • Modify Foreground and background color properties

Introduction to Oracle Form Builder

20

By Anna SidorovaIntro to Oracle Form Builder

10

BCIS 5420

Add a title to your...
tracking img