Hello frd, I am working on my DBMS Project in VB 6.0 that is Tollbooth management system i have to insert one trigger for my project so i had decided to insert time trigger. I have total 3 table UserLogin, Vehice and Vehicle_Data the 3rd table Vehicle data contain the following fields Vehicle_Type, Vehicle_No, Tax_Time, Source, Destination and Tax Now i had done coding for tax when you select Vehicle Type, Source and Destination the Tax Field will automatically fillup and all the data will Saved in Oracle table but now my problem is that i want to create trigger for Tax_Time column When any new data inserted current time will stored in that column I had create one but it gives error create trigger time after insert on vehicle_Data for each row begin insert into Vehicle_Data(Tax_Time) values(to_char(sysdate, 'HH:MI:SSAM DD_MON_YYYY')); end; / Code (markup): here i am attaching screen shot so you got the idea about my project Please Help me i have only 24 hours.. Note: I am Using VB 6.0 and Oracle 10g Express Edition