An environmental variable is set for the duration of a session using the SET command or as a default. The SET command changes the value of an environmental variable, and the SHOW command displays its value. An escape character allows a command-level character to be used without executing its...
An escape character allows a command-level character to be used without executing its inherent command. ESCAPE ON sets the default, a backslash. PAUSE command only works in SQL*Plus and performs the same type of function as the PAUSE or MORE command in various operating systems. It is ...
Sets the column separator character printed between columns in output. If the COLSEP variable contains blanks or punctuation characters, you must enclose it with single quotes. The default value for text is a single space. In multi-line rows, the column separator does not print between columns t...