People Innovation Excellence
 

APPLIED DATABASE II (4 Credits)

Learning Outcomes :

On successful completion of this course, student will be able to: Explain Oracle Report Developer; Create Web Repoting; Create PL/SQL Triggers Code; Use Oracle Form.

Topics:

  1. Introduction to Oracle Reports;
  2. Designing and Running Reports;
  3. Report Builder Concepts;
  4. Creating Reports Using the Report Wizard;
  5. Enhancing Reports in the Live Previewer;
  6. Managing Report Templates;
  7. Report Storage Methods;
  8. Enhancing Reports Using the Data Model: Creating Queries and Groups;
  9. Enhancing Reports Using the Data Model: Creating Columns;
  10. Enhancing Reports Using the Layout Model;
  11. Modifying Common Layout Properties;
  12. Creating and Using Report Parameters;
  13. Embedding a Chart in a Report;
  14. Enhancing Matrix Reports;
  15. Coding PL/SQL Triggers in Reports;
  16. Building a Web Report;
  17. Using the Report Builder Built-In Package;
  18. Customizing Reports at Run Time;
  19. Maximizing Performance Using the Reports Server;
  20. Building Reports: Efficiency Guidelines;
  21. Running a Forms Application;
  22. Working in the Forms Environment;
  23. Creating a Basic Form Module;
  24. Creating a Master-Detail Form;
  25. Working with Data Blocks and Frames;
  26. Working with Text Items;
  27. Creating LOVs and Editors;
  28. Creating Additional Input Items;
  29. Creating Noninput Items;
  30. Creating Windows and Content Canvases;
  31. Working with Other Canvas Types;
  32. Producing Triggers;
  33. Debugging Triggers;
  34. Adding Functionality to Items;
  35. Run-Time Messages and Alerts;
  36. Query Triggers;
  37. Validation;
  38. Navigation;
  39. Transaction Processing;
  40. Writing Flexible Code;
  41. Sharing Objects and Code;
  42. Using WebUtil to Interact with the Client;
  43. Introducing Multiple Form Applications;
  44. Modifying Specific Layout Properties.

Published at : Updated

Periksa Browser Anda

Check Your Browser

Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

We're Moving Forward.

This Site Is No Longer Supporting Out-of Date Browser.

If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

Best viewed with one of these browser instead. It is totally free.

  1. Google Chrome
  2. Mozilla Firefox
  3. Opera
  4. Internet Explorer 9
Close