PL/SQL - Can we create trigger on SELECT statement? If we can create, how?

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 8 of 166

Can we create trigger on SELECT statement? If we can create, how?

Total Answers and Comments: 9

Last Update: September 07, 2007 Asked by: SumanNaidu.S

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 30, 2005 01:38:01

nandam143

Member Since: November 2005 Contribution: 2

RE: Can we create trigger on SELECT statement? If we c...

i think we cannot. it should have a create statement

Is this answer useful? Yes | No

December 20, 2005 08:11:48

Archana Patil

RE: Can we create trigger on SELECT statement? If we c...

No we cannot create trigger on select statement we can create trigger only on insert / update / delete

Also check Syntax for trigger

Create or replace trigger <trigger_name>

before/after insert/update/delete

This shows only after insert update or delete trigger will get fire not on select statement.

Is this answer useful? Yes | No

February 06, 2006 06:47:08

chandrika

RE: Can we create trigger on SELECT statement? If we c...

by using triggers we cannot trigger.by using attributes like found 0r rowcount we can trigger a select statement

Is this answer useful? Yes | No

April 23, 2006 03:35:05

Divesh

RE: Can we create trigger on SELECT statement? If we c...

Triggers are always created on DML statements i.e Insert/update/delete only .. not on the select statement

Is this answer useful? Yes | No

April 27, 2006 08:24:53

Anand

RE: Can we create trigger on SELECT statement? If we c...

Hello

No its Possible to have a DDL commands in a Trigger but this has been included from Oracle 8i version prior to this you can only have DML Commands placed inside the Trigger Block.

As far as Select is concerned there is no good reason to prohibit the user or put constraints while viewing the data and if so the views are used for very well that purpose only.

Is this answer useful? Yes | No

June 19, 2007 02:33:44

kiranxl

RE: Can we create trigger on SELECT statement? If we c...

Yes we can create trigger like functionality on select statement like which user has select which table and most importantly what sql query issued by using dbms_fga built in package. just check it out.

Is this answer useful? Yes | No

August 27, 2007 01:31:15

jiten

RE: Can we create trigger on SELECT statement? If we c...

Hello

Someone has given answer that use dbms_fga
but it's not a write answer becoz it's used for keeping the track
which user has applied select operation on table.

It's one king of policy that is used for security purpose.

We can create trigger for DDL and DML statements.

Is this answer useful? Yes | No

September 06, 2007 07:42:18

chowdary

RE: Can we create trigger on SELECT statement? If we c...

We can create trigger on DML DDL transaction but it is not possible to create on Select statement one point we can create triggers on database system events like logon shutdown also

Thanq friends

Is this answer useful? Yes | No

September 07, 2007 04:59:24

Andrew

RE: Can we create trigger on SELECT statement? If we c...

May be it is better to trace a select statment with on logon trigger.
like:

CREATE OR REPLACE TRIGGER SYS.ON_LOGON_ALL

AFTER LOGON ON DATABASE

WHEN (

USER 'MAX'

)

BEGIN

EXECUTE IMMEDIATE 'ALTER SESSION SET SQL_TRACE TRUE';

--EXECUTE IMMEDIATE 'alter session set events ''10046 trace name context forever level 12''';

EXCEPTION

WHEN OTHERS THEN

NULL;

END;

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank