You can specify the returning statement in the DML Statement of oracle. The use of returning statements can simplify PL/SQL programming in many cases.
It is not intended to explain the use of the returning statement (in fact, it is very simple to
How to Use the oracle RETURNING clause, oraclereturning
RETURNING is usually used in combination with DML statements. (Insert update delete)
Usage:
UPDATE table_name SET expr1RETURNING column_nameINTO xxx
INSERT: returns the added value.UPDATE:
Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies. One of the most
Returning itself is often used in conjunction with DML statements. (INSERT UPDATE DELETE)
How to use:
UPDATE table_name SET EXPR1
returning column_name into
xxx
INSERT: Returns the value that is addedUpdate: The updated value when
I am using the large object field storage feature of Oracle in the Process of Oracle development using ado.net, but encountered a lot of trouble during the process,
Share it with you.
Adding columns containing large object fields to the server is
Basic Update Statements
The Oracle UPDATE statement processes one or more rows in a table and sets one or more columns to the values of you specify.
Update All records
UPDATE SET =
CREATE TABLE Test
The returning into statement is used to return the value returned after the statement is executed, returning the result before or after the execution, as described below:The returning into statement of the DELETE statement returns the result before
The returning into statement can be specified in an Oracle DML statement. The use of the returning into statement can in many cases simplify PL/SQL programming and one less SELECT INTO statement.Delete operation: Returning returns the result before
[Www.InnovateDigital.com Finishing]
Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of
oracle| optimization
Over the past decade, Oracle has become one of the most professional databases in the world. For IT professionals, it is important to ensure that Oracle's powerful features are used to improve the productivity of their companies.
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.