Problem with date/time (DD/MM/YYYY HH24:MI:SS) to copy in different row.

Wenggo · December 5th, 2013, 07:42 AM

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';

Anybody help...

Wenggo · December 10th, 2013, 09:32 PM

Quote:

Originally Posted by Wenggo

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';

Anybody help...

World pls help me...i am stuck here..