Hi All,
I have an IG based on a table. I need to have creation_date with date time as one of the unique key.
Hence I used date as a display field and in the default value I based it on a function that returns date time.
return TO_CHAR(SYSDATE, 'MM/DD/YYYY HH:MI:SSPM') ;
This works for the first record. However for the second record, it creates the same date time value even if I create the record after 2 mins. I have tried removing the Duplicate Copies Existing Value. However it did not help.
Any thoughts?
Thank you
Alex