Oracle developer suite
This presentation is the property of its rightful owner.
Sponsored Links
1 / 39

Oracle Developer Suite PowerPoint PPT Presentation


  • 160 Views
  • Uploaded on
  • Presentation posted in: General

Oracle Developer Suite. Forms & Reports. Oracle Developer Suite Tools. Oracle Developer Suite contains the following main components: Oracle Forms : For designing data entry forms. Oracle Reports : For designing reports .

Download Presentation

Oracle Developer Suite

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Oracle developer suite

Oracle Developer Suite

Forms & Reports


Oracle developer suite tools

Oracle Developer Suite Tools

Oracle Developer Suite contains the following main components:

  • Oracle Forms: For designing data entry forms.

  • Oracle Reports: For designing reports.

  • Oracle Jdeveloper: For developing Java applications or applets.

  • Oracle Warehouse Builder and Discoverer: OLAP tools for creating data warehouses and OLAP user interfaces.

  • Oracle Designer: Oracle's CASE tools that include modeling and code generation capabilities.


Forms reports

Forms & Reports

This tutorial covers the Developer Forms and Reports components.

We develop applications (forms, reports, menus, etc.) to make the job of data manipulation easier for users.


Oracle sql plus wokesheet ceate tables

ORACLE SQL PLUS WOKESHEET_Ceate Tables

  • DEPARTMENT Table


Oracle sql plus wokesheet ceate tables1

ORACLE SQL PLUS WOKESHEET_Ceate Tables

  • EMPLOYEE Table


Form developer

Form Developer

  • In Oracle Forms, a form (or data entry form) acts like a window into the database schema.

  • An individual focuses the attention of the user to one or a few of the tables at a time.

  • Form can give prompts so the user knows what kind of input is expected and how data is to be entered and manipulated.

  • Every form in Oracle Forms has the capability to:

    • Query existing data in a table,

    • Modify existing data in a table,

    • Add new data (records) to the table.


Form developer1

Form Developer

  • A form is built up using one or more data blocksthat correspond to tables in the database.

  • Fields within the data block correspond to columns in the database table.


Form developer log on

Form Developer-log on


Form developer log on1

Form Developer-log on


Form developer wizard

Form Developer-WIZARD


Form developer wizard1

Form Developer-WIZARD


Form developer lov

Form Developer_ LOV

  • xxx


Form developer lov1

Form Developer_ LOV

  • xxx


Form developer retrieve

Form Developer_RETRIEVE

  • xxx


Form developer insert

Form Developer_INSERT

  • xxx


Form developer clear

Form Developer_CLEAR

  • xxx


Form developer delete

Form Developer_DELETE

  • xxx


Form developer delete1

Form Developer_DELETE

  • xxx


Form developer end

Form Developer_END


Form developer end1

Form Developer_END


Prerequisites

Prerequisites

  • You must have a valid user account

    • in an Oracle server,

    • or a local installation of an Oracle database.

  • Existence of tables in the user's schema.


Important notes saving

IMPORTANT NOTES - SAVING

  • Forms & Reports can be saved in files in a directory of your choice.

  • Save them in a folder(subdirectory) on the local hard disk, on a flash memory or on a floppy disk.

  • You will have difficulty running any form saved in a folder that has spaces or punctuation other than the underscore character in the name.

    • For example, they will not run if you save them on "My Documents“ or on the “Desktop”.

    • It is critical that you DO NOT save the file with spaces in the file name.


Important notes compiling

IMPORTANT NOTES - COMPILING

  • Before executing (run) your form/Report, it must be Compiled and Built.

  • If there is an error (e.g., in the PL/SQL code, or if the database schema changes) it will be displayed in a window as its encountered.

  • Alternatively, Oracle Forms & Reports defaults to automatically compiling the form each time it is executed (run).


Important notes r unning

IMPORTANT NOTES - Running

  • Before running a Form or Report, the OC4J service should be started.

  • When run the Form or Report, the default web browser will be launched.

  • Oracle's JInitiator will load and the Form or the Report should appear.

  • To exit from a running Form or Report, pull down the Action menu and select the Exit menu item. Warning: Do not simply close the web browser as this will leave a Java Applet process running and this will lock your Form or Report.


Important notes r unning1

IMPORTANT NOTES - Running


Important notes r unning2

IMPORTANT NOTES - Running


Important notes r unning3

IMPORTANT NOTES - Running


Important notes r unning4

IMPORTANT NOTES - Running


Important notes r unning5

IMPORTANT NOTES - Running


Important notes r unning6

IMPORTANT NOTES - Running


Important notes r unning7

IMPORTANT NOTES - Running


Important notes r unning8

IMPORTANT NOTES - Running


Important notes r unning9

IMPORTANT NOTES - Running


Important notes r unning10

IMPORTANT NOTES - Running


Important notes r unning11

IMPORTANT NOTES - Running


The master detail relationship

The Master-Detail Relationship

  • The Master-Detail relationship is a relationship between entities shown as "One to Many" relationships.

  • A Department with many Employees is an example of this relationship.


The master detail relationship1

The Master-Detail Relationship

  • Oracle Forms implements the master-detail relationship using two data blocks.

  • The first block corresponds to the master table and the second block corresponds to the detail table.

  • There major function in a Master-Detail form is to guarantee that the detail block will display only records that are associated with the current record in the master block.


Report developer

Report Developer

  • Oracle Reports Builder allows the developer to create sophisticated reports in a variety of layouts and contains many customization features.

  • A report consists of objects that collectively define the report:

    • data model objects (queries, groups, columns, links, user parameters)

    • layout objects (repeating frames, frames, fields)

    • parameter form objects (parameters, fields)

    • PL/SQL objects (program units, triggers)

    • references to external PL/SQL libraries, if any


  • Login