Can we create trigger on view in oracle?
Answer / kamala k n
yes , we can create triggers on views like instead of triggers
| Is This Answer Correct ? | 0 Yes | 0 No |
How to create a server parameter file?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
Can a formula column be obtained through a select statement ?
How to set up autotrace for a user account?
How to write a query with an inner join in oracle?
What are the different types of partitions in oracle?
How to insert a new row into a table in oracle?
How to manage transaction isolation level?
What is merge statement used for?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
SELECT THE RECORDS FROM 3 TABLES LIKE(T1,T2,T3) AND HOW CAN WE INSERT THAT RECORD IN ANOTHER TABLE LIKE(T4)?
is there a tool to trace queries, like profiler for sql server?