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

Oracle Developer Suite

282 Views Download Presentation
Download Presentation

Oracle Developer Suite

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



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

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

  8. Form Developer-log on

  9. Form Developer-log on

  10. Form Developer-WIZARD

  11. Form Developer-WIZARD

  12. Form Developer_ LOV • xxx

  13. Form Developer_ LOV • xxx

  14. Form Developer_RETRIEVE • xxx

  15. Form Developer_INSERT • xxx

  16. Form Developer_CLEAR • xxx

  17. Form Developer_DELETE • xxx

  18. Form Developer_DELETE • xxx

  19. Form Developer_END

  20. Form Developer_END

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

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

  23. 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).

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

  25. IMPORTANT NOTES - Running

  26. IMPORTANT NOTES - Running

  27. IMPORTANT NOTES - Running

  28. IMPORTANT NOTES - Running

  29. IMPORTANT NOTES - Running

  30. IMPORTANT NOTES - Running

  31. IMPORTANT NOTES - Running

  32. IMPORTANT NOTES - Running

  33. IMPORTANT NOTES - Running

  34. IMPORTANT NOTES - Running

  35. IMPORTANT NOTES - Running

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

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

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