Updating oracle database
Because the physical and logical structures are separate, the physical storage of data can be managed without affecting the access to logical storage structures.” You can access an Oracle Database only through a client program, and the SQL language is that client program’s interface to the Oracle Database.
It’s no secret that today’s businesses cannot function without data.
Think about all the questions you ask yourself at work on a regular basis, “What are my sales so far this month? ” All of these questions are answered by data, and can provide insights that make the difference between a failing company and a successful business.
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'.