Hands-On Oracle Tools
Hands-On
01 (An example of how to use Schema Builder)
Learn how to to define the tables,
views, snapshots, synonyms, constraints, and table relationships that will make up your database.
You can visualize your database design, including the tables, columns, data types, and
relationships, and then execute that design.
Hands-On
02 (An example of how to use Query Builder)
Learn how to write your simple or
complex query. You can save your query at your client-side. It allows you to set your
table relationships and visualize your database objects that being linked, including the tables,
columns, and datatypes.
-
Hands-On
03 (An example of how to use Procedure Builder)
Learn how to develop stored
procedures, functions, packages, and triggers in Oracle. Many developers have found the
SQL*PLUS and favorite text editor approach cumbersome. You use Procedure Builder for
ease of writing program development, debugging, and version control.
Hands-On
04 (An example of how to use Form Builder)
Learn how to simplify for the
creation of data-entry screens, also known as Forms. Forms are the applications that connect to a
database, retrieve information requested by the user, present it in a layout specified by Form
designer, and allow the user to modify or add information. Form Builder allows you to build
forms quickly and easily.
Hands-On
05 (An example of how to use Report Builder)
Learn how to use report wizard, use
object navigator, use report builder, save report, use “data model”, use property palette, work
on query and group box, see report style, use tabular style, navigating through report’s record,
change the format mask for dollar, numeric and date items.
Hands-On
06 (An example of how to use Graphics Builder)
Learn how to create a chart, write a
query, execute a query, modify a query, and save a chart.
Forms and Reports Case Study
Hands-On Form Builder
(Internet
Applications Tool)
Hands-On 01(Forms)-Tab
canvas, Master-detail relationship
Learn how to use tab canvas, Master-Detail relationship.
Hands-On 02(Forms)-Tooltip,
Hint, Format Mask, Properties
Learn how to use and change the Help, Hint, and format
mask of properties.
Hands-On 03(Forms)-LOVs,
Record Group
Learn how to use the List of Values (LOV), and group
records.
Hands-On 04(Forms)-Radio
Buttons
Learn how to add and use Radio Buttons.
Hands-On 05(Forms)-Display
items, Summary and Function columns
Learn how to display fields, summary and formula
functions.
Hands-On 06(Forms)-Triggers
(POST-QUERY)
Learn how to use
the POST-QUERY trigger.
Hands-On 07(Forms)-Horizontal
Toolbar, Push Button, Trigger (when-button-pressed)
Learn how to create and use
horizontal toolbar, create and use push button item, create "WHEN-PUTTON-PRESSED" trigger,
write and compile trigger.
Hands-On 08(Forms)-Sizing
, Layout appearances
Learn how to size your canvas,
change the horizontal toolbar canvas.
Hands-On 09(Forms)-Trigger
(PRE-QUERY), set dynamically properties
Learn how to create
and use pre-query trigger, set dynamically block property on a table's data block and execute the
query using trigger.
Hands-On 10(Forms)-Sequence
object, Trigger (pre-insert)
Learn how to create
sequence object, create and use "PRE-INSERT" trigger.
Hands-On 11(Forms)-Call
form
Learn how to call
another form.
Hands-On 12(Forms)-Global
variable, trigger (when-new-form-instance)
Learn how to use
and assign global variable, pass global variable from one form to another, use global variable to
execute query base on that parameter, create and use "WHEN-NEW-FORM-INSTANCE" trigger.
Hands-On 13(Forms)-Main
menu
Learn how to create or modify
default main menu, use and assign global variable from one form to another, use global variable to
execute query base on that parameter, create and use "WHEN-NEW-FORM-INSTANCE" trigger.
Hands-On 14(Forms)-Pop
up menu
Learn how to create
"pop-up" menu, with following functionality "CUT", "PASTE", and
"COPY."
Hands-On 15(Forms)-Move
objects, Layout appearances
Learn how to move
objects around, create or copy, paste the logo.
Hands-On 16(Forms)-Run
Application from desktop
Learn how to run
your application from desktop.
Hands-On Report Builder
(Internet
Applications Tool)
Hands-On 01(Reports)-Tabular
Learn how to use report wizard, use
object navigator, use report builder, save report, use “data model”, use property palette, work
on query and group box, see report style, use tabular style, navigating through report’s record,
change the format mask for dollar, numeric and date items.
Hands-On 02(Reports)-Group
left
Learn how to use report wizard, use
report style “group left”, use template, use pre-viewer, use zoom in and out, use the body
section in the layout model in the object navigator, change repeating object’s property palette.
Hands-On 03(Reports)-Mailing
Label
Learn how to use report style
“mailing label,” use the “query builder,” generate three columns label, change the font and
size, change it to two columns label, use handlers on the layout model.
Hands-On 04(Reports)-Matrix
Learn how to use query builder, set
table relationship, change properties from property palette, use report style matrix, make subtotal
for rows and columns, use the “select parent frame” icon, create grid, use the conditional
formatting.
Hands-On 05(Reports)-Form
Letter
Learn how to use the report style
“Form Letter,” use the “query builder,” set table relationships, define column from the
“query builder,” use sub-query, use of data model, layout model, use of boilerplate, write the
letter and pass the column to the letter.
Hands-On 06(Reports)-Group
above
Learn how to use a master-detail
report, build a new report manually, create multiple “sql query,” create data link, use the
formula column, use the summary column, use the report “group above” style, use object
navigator, layout model, main section, use property palette.
Hands-On 07(Reports)-Template
Learn how to create or modify an
existing template, save the template with new name, change the default, delete the logo, replace the
new logo, save your template.
Hands-On 08(Reports)-Layout
appearances
Learn how to use boilerplate.
Hands-On 09(Reports)-Parameters
Learn how to use the “group
above,” use the “query builder,” set table relationship, create and use binding variable,
calculate total and average shares, delete the object from layout.
Hands-On 10(Reports)-Drill
Down or Push Button report
Learn how to use push button to
execute another report, use or pass parameter, use the “select parent frame” icon, use or open
objects property, compile report, use the boilerplate, write and compile PL/SQL trigger, use
“runtime pre-viewer.”
Hands-On
11(Reports)-LOVs (List Of Values)
Learn how to use parameter, modify parameter properties
using property palette, use query builder, add more parameters to existing parameter Form.
-
|