SQL*Plus Release 8.1.6 Enhancements

To fully exploit SQL*Plus Release 8.1.6, you need Oracle8i. SQL*Plus release 8.1.6 gives you the following additional capabilities:

• SQL*Loader is no longer used to install the SQL*Plus command line help system. The help system is now installed by running SQL*Plus scripts. See the Installation Guide for your operating system for instructions on how to install the help system. A SQL*Plus script is also provided to enable the removal of the help system.

• The SQLPLUS command now has a -RESTRICT option. -RESTRICT allows certain commands that interact with the operating system to be disabled. Compared to disabling the same commands with the Product User Profile (PUP) table, commands disabled with -RESTRICT can be disabled when there is no connection to a server, and remain disabled until SQL*Plus terminates.
• The SQLPLUS command now has a -MARKUP option. -MARKUP allows the use of server-side CGI scripts to create HTML reports for access on the web. You can use the SQLPLUS -MARKUP command to create web reports from existing SQL scripts. SQLPLUS -MARKUP options have the same effect as the new SET MARKUP command options.
• The SET command now has a MARKUP clause. During a SQL*Plus session, SET MARKUP allows the interactive creation of HTML reports for access on the web.
• SHOW MARKUP displays the status of MARKUP options.