iSelfSchooling.com - Copyright © 1999-2007 iSelfSchooling.com  References  Job Openings  |  Secure Login
    Home  | Search more...  |  FREE Online VIDEO Oracle Training  |  Gift Store  |  Bookstore

   Unlimited access!   

    Oracle  Syntax  | Suggestions Your Contribution  |  FREE Legal Forms

 

Email2aFriend Homepage us! |  Bookmark   -  Copyright & User Agreement

Products/Services

 Vision/Mission

 Community Sharing

 Services

  Products

 Biography

 Contact Us

 FAQ

 Current News

 Website Traffic

 Bookstore

 FREE Training

 SQL

 PL/SQL

 Forms 

 Reports

 Other TOOLS

 Fundamentals

 Performance

 OEM

 Application Server

 Grid Control

 Articles

 Prepare for OCP

Oracle SYNTAX

 Oracle Functions

 Oracle Syntax

 Oracle 10g Syntax

  PL/SQL Syntax

UNIX and more...

 UNIX for DBAs

 LINUX for DBAs

 DB using PHP

  A+ Certification

 Basics of JAVA  

 Tips of  SEO

Finance/Jobs

 Financial Aid

 Skilled

 Oracle

 Jobs

  Magazine

More Training

 Q & Answers

 SQL-PL/SQL

 DBA

 Developer

 Important Notes

 Case Studies

 9i New Features

 10g New Features

 10g Qs/As

 Grid Control

 OracleAS # I

 OracleAS # II

  LDAP and OID

  HTTP Server

 Instructor-Led

  Virtual Hosts

 Community Sharing

More to know...

Acknowledgement**

 FREE Legal Forms

 Who is who

 Market Place

 University Directory

 Advisory Articles

 Links...

 

 

Topics:  Hands-On 04 - Developer Tools (Form Builder)

You use Form Builder 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.

In this Hands-On, you learn how to:  Create a Datablock for the “Customer” table, Create a layout, Use “content” canvas, Use “execute query”, Navigate a table, Use next, previous record, Enter query, Manipulate table’s record, Insert, Update, Delete and Save record.

 

More Resources by Google:

Manuscript

Open the "Form Builder" tool.

 

Click on "Cancel."

Highlight "Database Objects."

Choose "File," then "Connect."

 

Login in as “iself” password “schooling,” then click “CONNECT.”

 

Expand "Database Objects," to see all schemas.

 

Highlight module1.

Choose “File,” select “Save as” to store the new object in the “iself” folder and save it as customer data entry. "customer_de."

DE stands for Data Entry.

 

Notice that the “window” object was created by default.

 

Highlight "Data Blocks,” and click on the "create” icon.

 

Use the “Data Block Wizard” and click "OK."

 

Click “NEXT.”

Click “NEXT” again.

Click on “browse.”

Highlight the "customer” table; then click "OK."

 

To choose all columns, click on the two arrow signs.

To choose selected columns, click on the one arrow sign.

Practice this.

And then select all columns, and click “next.”

 

Use the default checkmark radio button, and click "Finish."

 

Click Next.”

 

Select the "new canvas" option.

 

Here are the different types of canvases to select.

Select "content," then click “Next.”

 

Select all the columns.

 

Click “Next.”

 

Change size or prompt if needed.

 

Click “Next.”

 

Select "Form," if you want one record at a time.

Select "Tabular," if you want more than one record at a time.

Then click “next.”

 

Type the "Frame Title" and click "next."

 

Click "Finish."

 

This is the output layout screen.

Make some window adjustments and then run the form.

 

The object module should be compiled successfully before executing the Form.

 

Click on the "Execute Query" icon.

 

Click on the "Next Record" icon to navigate to the next record.

Click on the "Previous Record" icon to navigate to the previous record. 

This is an easy way to navigate through the “Customer” table.

 

Click on the "Enter Query" icon to query selected records.

Query all the customers whom their creditlimits are more than 7000.

 

These are all customers whom their creditlimits are more than 7000 dollars.

 

Query all customers whom their names start with the letter "E."

These are all customers whom their names start with the letter "E."

 

Query all customers whom their names start with the letter "E" and their creditlimits are more than 7000 dollars.

 

You only have one customer.

 

Now, query all customers.

 

Click "Insert Record" to add new customer.

Duplicate the last record, if you don’t want to type all duplication.

Apply the changes.

 

Click "next record" and "previous record" to navigate through the records and the one was added.

 

Click "Save" to commit the insert statement.

 

Click "Remove Record" to delete the record.

The record was deleted.

 

You can also lock the record.

 

Exit the FORM Runtime.

Click “YES” to save changes.

Click “OK” for acknowledgement.

 

Save the Form.

 

Now, you should practice this over and over, until you become a master at it.

Good Luck.

 

 
 
Google
 
Web web site