Set - 3

Question 56 :

How can a text file be attached to a report while creating in the report writer?

Answer :

By using the link file property in the layout boiler plate property sheet.

Question 57 :

How can I message to passed to the user from reports?

Answer :

By using SRW.MESSAGE function.

Question 58 :

Does one need to drop/ truncate objects before importing? (for DBA)

Answer :

Before one import rows into already populated tables, one needs to truncate or drop these tables to get rid of the old data. If not, the new data will be appended to the existing tables. One must always DROP existing Sequences before re-importing. If the sequences are not dropped, they will generate numbers inconsistent with the rest of the database. Note: It is also advisable to drop indexes before importing to speed up the import process. Indexes can easily be recreated after the data was successfully imported.

Question 59 :

How can a button be used in a report to give a drill down facility?

Answer :

By setting the action associated with button to Execute pl/sql option and using the SRW.Run_report function.

Question 60 :

Can one import/export between different versions of Oracle? (for DBA)

Answer :

Different versions of the import utility is upwards compatible. This means that one can take an export file created from an old export version, and import it using a later version of the import utility. This is quite an effective way of upgrading a database from one release of Oracle to the next.
Oracle also ships some previous catexpX.sql scripts that can be executed as user SYS enabling older imp/exp versions to work (for backwards compatibility). For example, one can run $ORACLE_HOME/rdbms/admin/catexp7.sql on an Oracle 8 database to allow the Oracle 7.3 exp/imp utilities to run against an Oracle 8 database.