Answers to Chapter 4
 | Reviewing It |
| 1: | Why does the author recommend using a prefix on all the application database objects? |
| A1: | To quickly identify related application objects when querying DBA_OBJECTS |
| 2: | Why does the author use a database trigger to maintain the data in the INSERT_USER, INSERT_DATE, UPDATE_USER, and UPDATE_DATE? |
| A2: | To automatically maintain the data in these fields no matter what tool is used to insert or update these objects |
| 3: | Why does the author spool a .log file out of the INSTALL scripts? |
| A3: | To capture any error and/or warning statements issued during the execution of the script |
| 4: | What is the ST_INV_SEQ useful for? |
| A4: | To help ... |
Get Oracle9i™ Development by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
