For ease of use with SQL*Plus, create a parent folder above this one on your OS, and set that folder as your default startup folder for SQL*Plus. You may wish to create the following file in this top-level folder which has some useful prompt and display column formatting.
Oracle 9i and 10g Parent Folder Script(s)
Generic prompt and display columns script
Oracle 9i and 10g Administration Scripts
Column definitions, used by all scripts
Clear column definitions, used by all scripts
Show CLOB contents
Compare two database schemas
Redo log switch activity
System-wide database links
Real-time database status
List of created database users
DDL locks
System directories
Heterogeneous Service clients
Installed s/w options
Invalid java classes
Invalid database objects
Invalid database objects for currently connected user
Michael Bloomberg has pledged $260m (£196m) to conserve the world's oceans, as major funders including the US and UK scale back science and conservation budgets.