Hi, I would like to add to the following select statement (unless a better way is provided) to update the column with a different date. Here's the select statement, I am unclear on how to 'set' new date value in column. Thank you anybody!
select * from TABLE
where (TABLE.COLUMN = to_date('01/01/1999','DD/MM/YYYY') and (TABLE.COLUMN = 'VALUE'));