SQL Plus: Difference between revisions

Revision as of 23:05, 4 November 2015

Revision as of 02:43, 5 November 2015

Line 7:

# [[PL/SQL]] blocks

# SQL*Plus internal commands, for example:

##* environment control commands such as SET

##* environment monitoring commands such as SHOW

# Comments

# External commands prefixed by the ! char

Line 20:

where the Oracle user <code>scott</code> has the password <code>tiger</code>. SQL*Plus then presents a prompt with the default form of:

{{samp|SQL&gt;}}

Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example: