CREATE OR REPLACE TRIGGER TR_BASICS_CREATED
ON TBL_BASICS REFERENCING NEW AS New OLD AS OldFOR
IF :NEW.created_on IS NULL THEN
INTO :NEW.created_on FROM DUAL;
I use Toad to query records from the oracle table. When a new record is inserted the database uses the following trigger to insert the created on date. On retrieving the records from the table, I see the time portion is displayed only for certain records eventhough the same trigger is used for all the inserts. Does it depend on any TOAD settings? If so, what is it?
BEFORE INSERT EACH ROW