hai friends.iam making an web sites in that i have a doubt.in oracle i had created a table name swa when ever i insert values in it,it has to update the table plus what i had inserted in the table ie the values are to be entered in text document automatically is it possible.please reply soon if you cant understand my doubt please reply i will explain.if you know please send me code
did you means create some kind of log? maybe you can use trigger on your table
CREATE OR REPLACE TRIGGER trigger_name after update on table_name for each row begin -- do something here insert into your_table_log(dateupdate,oldvalue,newvalue) values(sysdate, ld.your_column,:new.yourcolumn) end; /
CREATE OR REPLACE TRIGGER trigger_name after update on table_name for each row begin -- do something here insert into your_table_log(dateupdate,oldvalue,newvalue) values(sysdate, ld.your_column,:new.yourcolumn); commit; end; /
Barry's not gonna like this. Barry's not gonna like this one bit. What is Barry's deal with tiny ads?
a bit of art, as a gift, the permaculture playing cards