SQL Plus - Run (the SQL Buffer)

Card Puncher Data Processing

About

Lists and executes the most recently executed SQL command or PL/SQL block which is stored in the SQL buffer.

Example

>select 'test' from dual;
'TES
----
test

>/
'TES
----
test

>r
1* select 'test' from dual

'TES
----
test





Discover More
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 - SQL Buffer

The SQL Buffer contains the most recently executed: SQL command or PL/SQL block The buffer has no command history list and does not record SQLPlus commands. at the beginning, just use 0...
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 (/): ...



Share this page:
Follow us:
Task Runner