Some Oracle Commands
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Some Oracle Commands as PDF for free.
More details
- Words: 70
- Pages: 1
A nested select in the where clause, update table1 set column1= 'Canceled' where table1.id in (select table1.id from table1, table2 where table1.id=table2.id) ````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````` ````````````````````````````````````````````
UPDATE [schema.]{table | view | subquery}[@dblink] SET { (column [, column] ...) = (subquery) | column = { expr | (subquery) } } [, { (column [, column] ...) = (subquery) | column = { expr | (subquery) } } ] ... [WHERE condition] ````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````` `````````````````````````````````````````````
UPDATE [schema.]{table | view | subquery}[@dblink] SET { (column [, column] ...) = (subquery) | column = { expr | (subquery) } } [, { (column [, column] ...) = (subquery) | column = { expr | (subquery) } } ] ... [WHERE condition] ````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````````` `````````````````````````````````````````````
Related Documents
Some Oracle Commands
October 2019 21
Some Useful Linux Commands
November 2019 20
Some Useful Run Commands
May 2020 15
Oracle Db Basic Commands
April 2020 6
Useful Oracle Commands
May 2020 8