SQL Plus - Escape

Card Puncher Data Processing


Escape is a system variable that:

  • defines the character you enter as the escape character.
  • turn the Escape Mode as On or Off

See also concat


SET ESC[APE] {\ | c | ON | OFF} 



show escape
escape "\" (hex 5c)

Discover More
Card Puncher Data Processing
SQL Plus - Special Characters

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. The slash command (/): ...
Card Puncher Data Processing
SQL Plus - System Variable (Configuration)

System Variables Description APPI[NFO]{ON | OFF | text} Sets automatic registering of scripts through the DBMS_APPLICATION_INFO package. arraysize Sets the number of rows, called a batch, that SQLPlus...

Share this page:
Follow us:
Task Runner