Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Keywords

sql_statement

INSERT, UPDATE, DELETE, MERGE, or SELECT INTO statement.

RETURNING

Use the RETURNING clause in INSERT, UPDATE, and DELETE statements to obtain data modified by the associated DML statement. This clause allows you to avoid an additional SELECT statement to query the results of the DML statement. For example:

BEGIN
   UPDATE activity SET last_accessed := SYSDATE
   WHERE UID = user_id
   RETURNING last_accessed, cost_center 
   INTO timestamp, chargeback_acct;
attribute

Keyword directly follows last line in SQL statement, without a space. May be:

SQL%ISOPEN

Always returns FALSE for implicit cursors because the cursor is opened implicitly and closed immediately after the statement is executed.

SQL%FOUND

Returns TRUE if one or more rows were inserted, merged, updated, or deleted or if only one row was selected; FALSE if no row was affected.

SQL%NOTFOUND

Returns NULL before the statement; TRUE if no row was selected, merged, updated, inserted, or deleted; FALSE if one or more rows were affected.

SQL%ROWCOUNT

Returns the number of rows affected by the cursor.

SQL%BULK_ROWCOUNT

Pseudo associative array containing number of records modified by FORALL statement (see the “FORALL” entry later in this chapter) for each collection element.

SQL%BULK_EXCEPTIONS

Pseudo associatve array containing number of rows modified by the FORALL statement (see the “FORALL” entry later in this chapter) for each collection element.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page