CREATE OR REPLACE TRIGGER TR_BASICS_CREATED
ON TBL_BASICS REFERENCING NEW AS New OLD AS OldFOR
BEGIN
IF :NEW.created_on IS NULL THEN
SELECT SYSDATE
INTO :NEW.created_on FROM DUAL;
end if;
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 INSERTEACH ROWEND TR_BASICS_CREATED;
Thanks.
Note: I am new in this forum and I was not sure where to post my question. Hence, I have posted the same question in the ‘oracle discussion’ category too. Sorry about the redundancy.