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