SQL Plus: Difference between revisions

Revision as of 14:13, 13 September 2013

Revision as of 05:54, 25 September 2013

Line 16:

An Oracle programmer in the appropriately configured software environment can launch SQL*Plus, for example, by entering:

:{{code| $ sqlplus scott/tiger|lang=oracle8}}

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:

: {{samp|SQL&gt;}} {{code|select 'Hello world' as example from dual;|lang=oracle8}}

: {{samp|EXAMPLE}}

: {{samp|--------------------------------}}

: {{samp|Hello world}}

== History ==