SQL Plus - Special Characters

Card Puncher Data Processing


Useful command in sqlplus.




The At & character is the default character that define a substitution variable. You can change it with the define system variable.


How you can use a bind variable in SQLPlus



The slash command (/):

  • is an end of statement character for a PL/SQL block in a script
  • is an alias for the run command. It runs the last query : /

Exclamation mark

The exclamation mark is an alias of the HOST command on Unix system. It permits to send an shell command.

SQL> !pwd


See SQL Plus - (Arobase|At) (@ and @@)


; is:

  • the end of a SQL command in a script
  • an alias to the LIST command



The anti-slash (\) is the default escape character

Environment Variable

Question mark

The question mark is the equivalent of the ORACLE_HOME directory when using the start command.

Example: to start the compilation script utlrp.sql




The Period is the default character of concat

Discover More
Card Puncher Data Processing
(SQL Plus|SqlCl) (Oracle Database Console)

SQLPlus is the first client of the Oracle Database. On windows, there is two versions of SQLPlus : a GUI one (sqlplusw.exe) Officialy deprecated in the next release of Oracle.Documentation...
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Card Puncher Data Processing
SQL Plus - Command Reference

Commands Description @ @@ / ACCEPT APPEND ARCHIVE ATTRIBUTE BREAK BTITLE CHANGE CLEAR COLUMN COMPUTE CONNECT COPY Copies data from a query to a table in the same or another...
Card Puncher Data Processing
SQL Plus - Start Command

Runs the SQLPlus statements in the specified script. The script can be called from the local file system or a web server. where: url supports HTTP and FTP protocols in the form: ...

Share this page:
Follow us:
Task Runner