Category: SQLPlus

SQLPlus vs SQL

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...

SQLPlus commands

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...

SQLPlus Substitution variables

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...

SQLPlus

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...

SQLPlus Whenever Sqlerror

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; /...