SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

can we create trigger on select statement ?

bootstrapOct 7 2010 — edited Oct 11 2010

Hi,
i have Oracle 10g. I want to create a trigger on select statement .But i think oracle does not support trigger on select statement.I have written script like this. Is it possible to create such a trigger ?

create trigger count_view_posts
on select
on t_gkm_query
declare
x int(5):=0;

begin

 select GKQ_NUMBER_OF_VIEW into x  from t_gkm_query where GKQ_QUERY_ID='112122';
 dbms_output.put_line(x);


end count_view_posts

Edited by: user12222356 on Oct 7, 2010 6:57 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 8 2010

Added on Oct 7 2010

10 comments

32,298 views