Interested to Buy Any Domain ? << Click Here >> for more details...
what is trigger?
- 6 Answers
- 10930 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashish
Triggers are stored procedures created in order to enforce
integrity rules in a database. A trigger is executed every
time when database modification done.
Triggers are executed automatically on occurance of one of
the data-modification operations.
A trigger is a database object directly associated with a
particular table. It fires whenever a specific
statement/type of statement is issued against that table.
The types of statements are insert,update,delete and query
statements.
| Is This Answer Correct ? | 11 Yes | 0 No |
Answer / dsr
trigger is like as procedure.this procedure will call at
some events occuring.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / abhisek pattnaik
Trigger is a type of programme which is automatically
executed when ever a DML operation is made on a perticular
table.
Trigger is identical with procedure but the basic
difference between them is procedure is explicitly created
& executed by the user where as trigger is explicitly
created but implicitly fired or executed when ever a DML
operation is made.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / aysh
A database trigger is procedural code that is automatically
executed in response to certain events on a particular
table or view in a database.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / dhanalakshmi parthasarathy
Triggers are simply stored procedures that are ran
automatically by the database whenever
some event (usually a table update) happens. We won’t spend
a great deal of time talking
about how to write triggers, because if you know how to
write stored procedures, you already
know how to write triggers. What we will discuss is how to
set them up to be executed whenever something happens to
the table.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / felin dhivya
Trigger is an activity that takes place due to more energy
| Is This Answer Correct ? | 0 Yes | 2 No |
Explain mutating triggers.
What are privileges and grants?
Explain the truncate in oracle?
What are the oracle differences between nvl and coalesce
How to open a cursor variable?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
WHAT IS ecc 6.0
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
create or replace procedure show_tab_rec ( P_tab VARCHAR2 ) IS cmd varchar2(50); begin cmd := 'select * from '|| P_tab; for int in ( execute immediate cmd ) loop dbms_output.put_line ( int.ename||' '||int.deptno); end loop; end; when i m compling this procedure i m getting this error PLS-00103: Encountered the symbol "IMMEDIATE" when expecting one of the following: . ( ) , * @ % & | = - + < / > at in is mod remainder not range rem => .. <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_ LIKE4_ LIKEC_ between || multiset member SUBMULTISET_ PLZ solve this error give this question answer asap Thanks advance.......
What are nested tables?
What do you mean by merge in oracle?
Define 'view' advantage ?
Oracle General 
