Sql date updating

by  |  29-Dec-2019 04:08

The Oracle UPDATE statement is used to update existing records in a table in an Oracle database.

There are 2 syntaxes for an update query in Oracle depending on whether you are performing a traditional update or updating one table with data from another table.

Requires membership in the db_owner fixed database role or permission to view the metadata for the table or indexed view.

sql date updating-46

USE THIS QUERY : SELECT DUEDATE, OLDDATE FROM FACTORYORDER; 2.

CHECK THE DATATYPE OF THIS TWO FIELDS AND THEN CHECK THE DATE FORMAT FOR THESE FIELDS. NOW USE THIS QUERY FOR UPDATE: UPDATE FACTORYORDER SET DUEDATE='30-JUL-2001' WHERE OLDDATE='06-JAN-2004'; NOTICE : ABOVE QUERY WILL UPDATE ALL THE RECORDS HAVING OLDDATE AS '06-JAN-2004'.

Specifies the temporary named result set or view, also known as common table expression (CTE), defined within the scope of the UPDATE statement.

The CTE result set is derived from a simple query and is referenced by UPDATE statement.

Any characters not found in this code page are lost.

Community Discussion