Which of the following is used to execute a SQL statement from the SQL buffer?
A SQL statement or a PL/SQL block can be executed by entering a semicolon (;) or a slash (/), or by using the RUN command at SQL prompt.
When a semicolon (;) is entered at the end of a command, the command is completed and executed.
When a slash (/) is entered, the command in the buffer is executed. It can also be used to execute a PL/SQL block.
The RUN command is used to execute a command in the buffer.
Note: The SQL buffer stores the most recently used SQL commands and PL/SQL blocks. It does not store SQL* Plus commands. It can be
edited or saved to a file.
Note: A SQL command can be saved in the buffer by entering a blank line.
'Understanding SQL COMMAND Syntax'
Currently there are no comments in this discussion, be the first to comment!