SQL Plus - Special Characters

Card Puncher Data Processing

About

Useful command in sqlplus.

Characters

Variables

&

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

Command

Slash

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
/home/oracle

Arobase

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

;

; is:

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

Escape

Anti-Slash

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

@?/rdbms/admin/utlrp.sql

Others

.

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