Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jamuna
triggeres are databbase objects this are stored inthe
data base same as the procedures but procedures executed
explicitely byt triggers executed implicitely when
trigger event occures
triggere event means DML OPERATIONES (INSERT,UPDATE,DELETE)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is oracle a programming language?
How to start an oracle instance?
How do I limit the number of rows returned by an oracle query after ordering?
How to invoke the data pump export utility?
In what script is snap$ created? In what script is the scott/tiger schema created?
How many categories of data types?
What is MTTR advisor in Oracle?
How to store only time; not date and time?
Differentiate between translate and replace?
How to create a temporary table in oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
How to loop through data rows in the implicit cursor?
Can we store images in oracle database?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to retrieve data from an explicit cursor?
