RUN AN ORACLE FORM

1
Section 1

• RUN AN ORACLE FORM
• ????Oracle ??
• SECTION 1 OBJECTIVES
• 1,??
• Describe the features and identify the
  components of Oracle Forms.
• ??Oracle ????????Oracle?????.
• Run an Oracle Form application as an operator.
• ????????????Oracle ??????.
• Retrieve data with an Oracle Form application.
• ?????
• Insert, update, and delete data with an Oracle
  Form application.
• ????Oracle ????????,??,?????
• Commit or rollback changes to data with an
  Oracle Form application.
• ????Oracle ??????????????????.

2
STEPS TO OPERATE A FORM

• ?????????
• 1. Run an existing application..
• ????????????
• 2. Navigate through the form.
• ??????
• 3. Respond to displayed messages.
• ???????
• 4. Retrieve all records.
• ??????
• 5. Retrieve records that match specified search
  criteria.
• ?????????????

3
STEPS TO OPERATE A FORM

• ?????????
• 6. Change an existing record.
• ?????????
• 7. Create a new record.
• ???????
• 8. Remove an existing record.
• ??????????
• 9. Save changes in the form data to the database.
  ???????????
• RUN AN ORACLE FORMS APPLICATION
• ????Oracle??????
• Invoke an Oracle Forms application by clicking on
  the appropriate icon
• ???????????Oracle??????

4
Example

• Invoke application in Microsoft Windows by
  clicking on the Form 4.0
• ??' Form 4.0 Runtime'????Windows??????.??Oracle???
  ?????????.
• Runtime icon. Note that Oracle Forms will prompt
  for username and password.
• STEPS FOR RETRIEVING ALL RECORDS
• ?????????
• 1. Press the Execute Query key or select the
  Query, Execute option from the menu.
• ?Execute Query?????????,????
• 2. Display the next record by pressing Next
  Record or selecting the Record, Next option from
  the menu. Display the previous record by
  pressing previous Record or selecting the
  Record, Previous option from the menu.
• ?Next Record??????????????Record,
  Next.?previous Record???????'Record,
  Previous'?????????.

5
RESULTS

• ??
• The status of the retrieved records is set to
  query.
• ????????????????
• NAVIGATE A FORM
• ??????

6
Perform and navigate user operations in a
bit-mapped environment using the mouse.
???????????????????????

• 1. Navigate to a different item.
• ?????????.
• 2. Select a choice from a menu
• ?????????
• 3. Choose a record from a LOV.
• ?LOV??????
• 4. Set a check box on or off.
• ?????????
• 5. Press a button.
• ???

7
continue.......

• 6. Choose a button in a radio group.
• ???????????
• NAVIGATE (continued)
• 7. Switch to an open window.
• ????????
• 8. Respond to an alert box.
• ???????box
• 9. Scroll records using a block scroll bar.
• ????????????
• 10. Scroll lines using an item scroll bar.
• 11. ??????????

8
MODES??

• Oracle Forms has two modes of operation Normal
  Mode and
• Enter-Query mode.
• Oracle ?????????,?????Enter-Query??
• In Normal Mode, you may
• ?????,???
• 1. Insert new records.
• ?????
• 2. Delete records.
• ????
• 3. Update records.
• 4. Retrieve all records.
• ??????
• 5. Commit records.
• ????

9
In Enter-Query Mode, you may?Enter-Query??,???

• 1. Retrieve records using selection criteria.
• ???????????
• 2. Retrieve records using the Query Where dialog
  box.
• ????????????
• 3. Obtain the number of records that will be
  retrieved before fetching them from the database
  using Count Query Hits.
• ??' Count Query Hits'?????????????????????????
• 4. Retrieve all records.
• ??????
• RETREIVE SPECIFIC RECORDS
• ??????

10
Steps for Entering Complex Criteria?????????

• 1. Press the Enter Query key or select the
  Query, Enter option from the menu.
• ?Enter Query?,????????Query, Enter??.
• 2. Enter a colon() followed by a variable in one
  or more items, which acts as a placeholder.
• ????????????????????.
• 3. Press the Execute Query key or select the
  Query, Execute option from the menu. The
  Query/Where dialog box appears.
• ??Execute Query?????????Query, Execute??.
  Query/Where??????.
• 4. Enter search criteria using variables in
  logical conditions in the dialog box.
• ???????????????????
• 5. Press the Execute Query key or select the
  Query, Execute option from the menu, to retrieve
  all records that satisfy the search criteria
  specified.
• ?Execute Query????????' Query,
  Execute'????????????????????

11
UPDATE A RECORD????---Steps for Updating a
Record???????

• Press the Enter Query key or select Query,
  Enter from the menu.
• ?Enter Query????????' Query, Enter'??
• Enter the search criteria to retrieve the
  appropriate record.
• ?????????????
• Press the Execute Query key or select Query,
  Execute from the menu to retrieve all records
  that satisfy the search criteria specified.
• ?Execute Query????????' Query,
  Execute'????????????????
• Move the cursor through the records, stopping
  at the record to be changed.
• ????????,?????????????.
• Update the information.
• ??????
• Commit changes to the database.?????????

12
RESULTS

• The record on the screen changes.
• ??????????
• The record is marked as changed in Oracle
  Forms.
• ?????????Oracle???????
• A row-level lock is issue on the corresponding
  row in the database.
• ??row-level??????????????.

13
CREATE A NEW RECORD---Steps for Creating a New
Record

• Press Insert Record or select the Record,
  Insert option from the menu.
• ?Insert Record????????' Record, Insert'??
• Enter the information.
• ????
• Commit the insert into the database.
• ???????????.

14
RESULTS

• The record on the screen is displayed
• ????????????
• The record is marked as inserted in Oracle
  Forms.
• ????Oracle ?????????

15
DELETE A RECORD---Steps for Deleting a Record

• Navigate to the record for deletion.
• ?????????
• Press Delete Record or select the Delete,
  Record option from the menu.
• ?Delete Record????????' Delete, Record'??
• Commit the deletion to the database.
• ????????????

16
RESULTS

• The record is removed from the screen.
• ????????
• The record is marked as deleted in Oracle
  Forms.
• ???????? Oracle?????
• A row-level lock is issued on the corresponding
  row in the database.
• ??row-level?????????????

17
COMMIT OR ROLL BACK CHANGES---???????

• Commit form data to the underlying tables.
• ????????????(????????????????,?faint)
• Steps for committing a Record
• ?????????
• Press the Commit key or select the Action or
  Commit option from the menu.
• ?Commit?,???????' Action or Commit'??

18
RESULTS

• Oracle Forms checks the validity of the data.
• Oracle??????????
• The database checks the validity of the data.
• ???????????
• The changes are written to the database.
• ?????????
• All database locks are released.
• ?????????
• The new information is available for others.
• ?????????????.
• RUN AN ORACLE FORM
• ????Oracle Form

19
SUMMARY

• Query, insert, update, and delete data to the
  database with an Oracle Form.
• ??????Oracle Form??,??,???????
• Run an Oracle Form
• ????Oracle Form
• Run an existing application by clicking on an
  icon or issuing an operating system command.
• ???????????????????????????????
• Navigate through a form with functions keys, a
  menu, or a mouse.
• ?????,??,??????????

20
continue......

• Respond to messages displayed in an alert box.
• ???????????????
• Interact with a check box, a radio group, and a
  list item.
• ??????,???,???????????
• Utilize buttons to initiate actions.
• ??????????.

21
SUMMARY (continued)

• Perform qualified and unqualified queries.
• ?????,????????
• Utilize the Query Where dialog box and the
  Count Query Hits function.
• ??' Query Where'????????????
• Insert, update, or delete records.
• ??,??,??????
• Utilize a pop-up editor to edit data.
• ???????????????
• Select valid values from a List of Values (LOV)
• ?????????
• Commit or rollback changes to the form data.
• ???????????