Can we call a trigger inside a function and function inside a
trigger? Give example.
Answer / manikandan. s
triggers can't be called. They will be fired automatically
during certain operations like insert, delete, etc..
Inside a trigger we can call function
CREATE OR REPLACE FUNCTION f_t RETURN NUMBER IS
select sum(col2) into tmpVar from t;
WHEN NO_DATA_FOUND THEN
WHEN OTHERS THEN
CREATE OR REPLACE TRIGGER L4OC.T_T
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
select f_t into tmpvar from dual;
insert into t_t values(:old.col1, tmpvar);
|Is This Answer Correct ?||9 Yes||5 No|
When do we use group by clause in a sql query?
How to rebuild an index in oracle?
How to assign query results to variables?
what is the exact diiference between DBMS and RDBMS
What is Java Pool in Oracle?
How to get a list of all tables in the database?
What a SELECT FOR UPDATE cursor represent.?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What do you understand by database schema and what does it hold?
5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.
Explain parameter file in oracle.
What is an Index Segment ?