Category: SQLPlus

The differences between SQL * Plus commands and SQL commands SQL SQL * Plus It is a language of communication with your Oracle server for accessing data. Recognize SQL statements and their transfer to your Oracle server. Is based on the...

The most important commands available in SQL * Plus are: ACCEPT – used to read a variable input DEF (DEFINE) – allow you to declare a variable DESC (DESCRIBE) – lists the attributes of objects EDIT – opens an editor EXIT...

Substitution variables are used to store temporary values. For variables of type character or date is mandatory quoting. Substitution variables can occur in a condition WHERE, in the ORDER BY clause, in the name of a table. Syntax SELECT &column FROM...

SQL * Plus is a tool that allows you to interact directly with the Oracle database. SQL * Plus is an Oracle command line utility that allows users to interactively execute SQL and PL/SQL commands. SQL * Plus enables you to...

WHENEVER SQLERROR Command Syntax: WHENEVER SQLERROR {EXIT [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable] [COMMIT|ROLLBACK]|CONTINUE [COMMIT|ROLLBACK|NONE]} WHENEVER SQLERROR Command Examples: WHENEVER SQLERROR EXIT SQL.SQLCODE select no_column from dual; WHENEVER SQLERROR EXIT SQL.SQLCODE Begin SELECT NO_COLUMN FROM DUAL; End; /...