3.18 SQL

Purpose

Use the SQL command to execute SQL commands and PL/SQL procedures. This command is easier to use than in Oracle Database 11.2 and earlier releases, because the SQL command does not need to be enclosed in quotation marks and does not need to be prefixed with "SQL". For the original syntax, see SQL (Quoted).

See Also:

Oracle Database SQL Language Reference

Prerequisites

None

Syntax

sqlcommand::=

Description of the illustration sqlcommand.eps

(sqlKeyword::=, allSqlKeywords::=

sqlKeyword::=

Description of the illustration sqlkeyword.eps

allSqlKeywords::=

Description of the illustration allsqlkeywords.eps

sqlKeyword::=

Semantics

sqlcommand::=

Syntax Element	Description
SQL CATALOG	Executes the SQL command in the catalog database.
SQL CHANNEL 'channel_id'	Executes the SQL command over the named channel.
TARGET	Executes the SQL command in the target database.
sql syntax	The appropriate SQL syntax for the specified keyword, which RMAN sends to SQL for processing.
BEGIN	Indicates the body of a PL/SQL block.
DECLARE	Indicates a declarative part of a PL/SQL block.
plsql statement	A PL/SQL statement or block, which RMAN sends to SQL for processing. Bind variables are not supported and cause execution errors. Any output cannot be viewed.
lone /	A single slash (/) as the first and only character on a line.

sqlKeyword::=

The sqlkeyword clause lists the SQL commands that you can execute in RMAN. For the SQL syntax, see the Oracle Database SQL Language Reference. The exceptions are described in the following table.

Syntax Element	Description
ALTER	Replaces the RMAN ALTER DATABASE command and provides the full functionality of the SQL ALTER command.
DELETE FROM	Requires the FROM keyword to execute the SQL DELETE command; otherwise, executes the RMAN DELETE command.
DROP DATABASE	Executes the RMAN DROP DATABASE command.
FLASHBACK	Executes the RMAN FLASHBACK DATABASE command.
SELECT	Uses these column widths to display the returned rows: Numbers: 10 characters Characters: Maximum length Long: 80 characters Use the SQL SET command to change the display size of number and long columns. No other commands or options are available for formatting the output. Bind variables are not supported and cause execution errors. INTO clauses are ignored.

allSqlKeywords::=

The allSqlKeywords clause is preceded by the SQL keyword, which eliminates the ambiguity between SQL and RMAN commands.

Syntax Element	Description
DELETE	Executes the SQL DELETE command.
DROP DATABASE	Executes the SQL DROP DATABASE command.
FLASHBACK DATABASE	Executes the SQL FLASHBACK command.
FLASHBACK PLUGGABLE DATABASE	Executes the SQL FLASHBACK PLUGGABLE DATABASE command.

Examples

Example 3-67 Adding a Data File

This example adds a data file to the USERS tablespace:

RMAN> ALTER TABLESPACE users ADD DATAFILE '/disk1/oradata/users02.dbf' SIZE 1M AUTOEXTEND ON NEXT 10K MAXSIZE 2M;
 
Statement processed

Example 3-68 Querying a Table

This example selects a column from the V$DATABASE dynamic performance view:

RMAN> SELECT dbid FROM v$database;
 
using target database control file instead of recovery catalog
      DBID
----------
3152825380

Example 3-69 Creating a Directory

This example creates the DEST_DIR directory:

RMAN> CREATE DIRECTORY dest_dir AS '/usr/admin/destination';
 
Statement processed