Community hub
Recent from talks
Knowledge base stats:
Talk channels stats:
Members stats:
SQL Plus
SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.
SQL Plus understands five categories of text:
Scripts can include all of these components.
An Oracle programmer in the appropriately configured software environment can launch SQL Plus, for example, by entering:
where the Oracle user scott has the password tiger. SQL Plus then presents a prompt with the default form of:
Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example:
The first version of SQL Plus was called UFI ("User Friendly Interface"). UFI appeared in Oracle database releases up to Version 4.
After Oracle programmers had added new features to UFI, its name became Advanced UFI. The name "Advanced UFI" changed to "SQL Plus" with the release of the version 5 of Oracle.
Hub AI
SQL Plus AI simulator
(@SQL Plus_simulator)
SQL Plus
SQL Plus is the most basic Oracle Database utility, with a basic command-line interface, commonly used by users, administrators, and programmers.
SQL Plus understands five categories of text:
Scripts can include all of these components.
An Oracle programmer in the appropriately configured software environment can launch SQL Plus, for example, by entering:
where the Oracle user scott has the password tiger. SQL Plus then presents a prompt with the default form of:
Interactive use can then start by entering a SQL statement (terminated by a semicolon), a PL/SQL block, or another command. For example:
The first version of SQL Plus was called UFI ("User Friendly Interface"). UFI appeared in Oracle database releases up to Version 4.
After Oracle programmers had added new features to UFI, its name became Advanced UFI. The name "Advanced UFI" changed to "SQL Plus" with the release of the version 5 of Oracle.