O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

10g SQL*Plus Enhancements

The Oracle 10g Database offers several new features for SQL*Plus. The two main new features introduced with 10g are the new DEFINE variables and the enhanced SPOOL command.

DEFINE Enhancements

Starting with Oracle 10g, the DEFINE command has three new predefined variables:

  • _USER. This Contains the user name that is supplied by the user to make the current connection. The result here is the same as the output from the SHOW USER command.

  • _DATE. This contains the current date or a user-defined fixed string. By default, _DATE displays the current date and is dynamic. _DATE uses the date format as shown with NLS_DATE_FORMAT.

  • _PRIVILEGE. This contains the privilege level of the current connection. The value for _PRIVILEGE ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required