oracle developer suite n.
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle Developer Suite PowerPoint Presentation
Download Presentation
Oracle Developer Suite

Loading in 2 Seconds...

play fullscreen
1 / 203

Oracle Developer Suite - PowerPoint PPT Presentation

  • Uploaded on

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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
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
    1. Oracle Developer Suite Forms & Reports

    2. 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.

    3. Oracle Developer Suite Tools 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.

    4. 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.

    5. make the internet explorer your default browser

    6. Department Table

    7. Employee Table

    8. Form

    9. Form • 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.

    10. Form • 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.

    11. LOVs