Sql date updating
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.
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.