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

Ex

CREATE OR REPLACE FUNCTION f_t RETURN NUMBER IS
tmpVar NUMBER;
BEGIN
select sum(col2) into tmpVar from t;
RETURN tmpVar;
EXCEPTION
WHEN NO_DATA_FOUND THEN
NULL;
WHEN OTHERS THEN
RAISE;
END f_t;
/

CREATE OR REPLACE TRIGGER L4OC.T_T
AFTER INSERT
ON L4OC.T
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
declare
tmpvar number;
begin
select f_t into tmpvar from dual;
insert into t_t values(:old.col1, tmpvar);
end;
/

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

0 Answers   TCS,

---

How to manage transaction isolation level?

0 Answers  

---

Name the three major set of files on disk that compose a database in Oracle?

0 Answers  

---

How do I learn what codesets are available in oracle?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ================ 1 NULL 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

Display the records between two range?

2 Answers  

---

Explain integrity constraint?

0 Answers  

---

how can we store any pdf file in oracle

0 Answers  

---

what is the bitmap index?

3 Answers  

---

How to list all indexes in your schema?

0 Answers  

---

What is E-R diagram ?

2 Answers   CGI, Keane India Ltd,

---

What is rich query?

0 Answers  

---