In my attempt to add a default value to a column of a pseudo-column ‘systimestamp’, I was successfull in utilizing:
Because the ‘defaultValueDate’, does not add quotes around the systimestamp, allowing the system to set it properly. However, when trying to utilize the pseudo-column ‘user’ in another column, I have been unsuccessful.
I realize the work around here, would just be to have an SQL block that adds my 3 audit columns, however, it would be nice if there was a way to use this. Using ‘user’ on a defaultValue (adds single quotes around it), and defaultValueDate - which realizes it isn’t a date.
Am I missing something I haven’t tried?