René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

prompt [SQL*Plus]

prompt some arbitrary string
prompt &var
Prints a string. If the string contains variable (indicated with a leading ampersand [&]), it prints the variables value. The variable's value can be set with define.

Storing settings across sessions

Settings (such as prompt) can be stored accross sessions with the glogin.sql and/or login.sql file.