SQL Plus - Escape

Card Puncher Data Processing

About

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

Syntax

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

Management

Character

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