Answer Posted / santosh pachauri
Triggers are the precompiled statement stored in the
database and fired by the server when you want to
insert,delete,update record.
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How to run sql statements with oracle sql developer?
How does cross join work in sql?
Is sqlexception checked or unchecked?
Why do we use function in pl sql?
What is native sql query?
define data blocks ? : Sql dba
What is your daily office routine?
Can a primary key be a foreign key?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
When do we use triggers?
What are properties of the transaction?
How do you use join?
how do you control the max size of a heap table? : Sql dba
What is scalar function?
Define join and name different types of joins?