|
Manuscripts
for 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.
- Manuscript
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.
- Manuscript
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. - Manuscript
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.
- Manuscript
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. - Manuscript
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.
- Manuscript
Manuscripts
for 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.
-
Manuscript
Hands-On 02(Forms)-Tooltip,
Hint, Format Mask, Properties
Learn how to use and change the Help, Hint, and format
mask of properties. -
Manuscript
Hands-On 03(Forms)-LOVs,
Record Group
Learn how to use the List of Values (LOV), and group
records. -
Manuscript
Hands-On 04(Forms)-Radio
Buttons
Learn how to add and use Radio Buttons.
-
Manuscript
Hands-On 05(Forms)-Display
items, Summary and Function columns
Learn how to display fields, summary and formula
functions.
-
Manuscript
Hands-On 06(Forms)-Triggers
(POST-QUERY)
Learn how to use
the POST-QUERY trigger.
-
Manuscript
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.
- Manuscript
Hands-On 08(Forms)-Sizing
, Layout appearances
Learn how to size your canvas,
change the horizontal toolbar canvas.
- Manuscript
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.
- Manuscript
Hands-On 10(Forms)-Sequence
object, Trigger (pre-insert)
Learn how to create
sequence object, create and use "PRE-INSERT" trigger.
- Manuscript
Hands-On 11(Forms)-Call
form
Learn how to call
another form.
- Manuscript
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.
- Manuscript
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.
- Manuscript
Hands-On 14(Forms)-Pop
up menu
Learn how to create
"pop-up" menu, with following functionality "CUT", "PASTE", and
"COPY."
- Manuscript
Hands-On 15(Forms)-Move
objects, Layout appearances
Learn how to move
objects around, create or copy, paste the logo.
- Manuscript
Hands-On 16(Forms)-Run
Application from desktop
Learn how to run
your application from desktop.
- Manuscript
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.
- Manuscript
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.
- Manuscript
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.
- Manuscript
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.
- Manuscript
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. - Manuscript
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.
- Manuscript
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.
- Manuscript
Hands-On 08(Reports)-Layout
appearances
Learn how to use boilerplate.
- Manuscript
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.
- Manuscript
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.”
- Manuscript
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.
-
Manuscript
|
