SQL Plus - Variable

Card Puncher Data Processing


VARIABLE is a function that:

  • declares a bind variable that can be referenced in SQL and PL/SQL
  • lists the current display characteristics for a single variable or all variables.

SQLPLUS can manage two types of variable:

See also the reserved variable name


VAR[IABLE] [variable [type]]

where type represents one of the following:

  • CHAR
  • CHAR (n [CHAR|BYTE])
  • NCHAR (n)
  • NVARCHAR2 (n)
  • CLOB


For management of bind variables, see the bind variable page

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
How you can use a bind variable in SQLPlus

This page is specifically about the usage of SQL bind variable in SQLPlus.
Card Puncher Data Processing
Oracle Database

Documentation about the Oracle database
Card Puncher Data Processing
SQL Plus - (EXIT|QUIT) command

Commits or rolls back all pending changes, logs out of Oracle, terminates SQLPlus and returns control to the operating system. where: the first block [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable]...
Card Puncher Data Processing
SQL Plus - ACCEPT command (Console Interaction)

The accept command reads a line of input and stores it in a given substitution variable. where: variable is the variable command prompt is the prompt command HIDE will hide the input For...
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

Performs the specified action (exits SQLPlus by default) if an operating system error occurs (such as a file writing error). In iSQLPlus, performs the specified action (stops the current script by default)...

Share this page:
Follow us:
Task Runner