Problem with date/time (DD/MM/YYYY HH24:MI:SS) to copy in different row.
Evening, I got problem with Oracle code below when executed, because giving my field 'a.SAME_TABLE_DATE' null or blank.
I would like to copy a date/time (DD/MM/YYYY HH24:MI:SS) in same table and same field but different row.
UPDATE SAME_TABLE a
SET a.SAME_TABLE_DATE = (SELECT b.SAME_TABLE_DATE FROM SAME_TABLE b WHERE b.SAME_NAME = a.SAME_NAME AND b.SAME_TABLE_DISPLAYNAME = 'ROW_2')
WHERE a.SAME_TABLE_DISPLAYNAME = 'ROW_1';