Answer / rakesh keshu

With the help of call statement..without semicolon

create or replace trigger tri_call


begin
call p1()



end tri_call;

Answer / pranabesh

Procedures can be called directly by name with parameters
[if any] in the trigger

ex:
suppose i have a procedure pro1(var1 in number, var2 in
number) which i want to call from trigger trig1

CREATE OR REPLACE TRIGGER TRIG1
AFTER UPDATE OF SAL ON EMP
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
DECLARE

L_VAR1 NUMBER;
...
...
BEGIN
...
...
-- CALLING THE PROCEDURE

pro1(10,20);
END

Answer / pradeep aryan

hi this is Sql server Statement:

Create table findSalary(salay int)

-- create procedure
Create proc stp_testdata
as
begin
select * from findsalary
end
-- Create function
create function Function4()
returns varchar
as
begin
return 'test data'
end
-- insert command
insert into findsalary values (89)


this is working fine

What is AUTH_ID and AUTH_USER in pl/sql ?

0 Answers   INDUS,

---

How to write html code in pl sql?

0 Answers  

---

Is a foreign key always unique?

0 Answers  

---

what are tables and fields? : Sql dba

0 Answers  

---

What is procedure explain with program?

0 Answers  

---

Is sql similar to python?

0 Answers  

---

What is the difference between local and global temporary table?

0 Answers  

---

When do we use triggers?

0 Answers  

---

HP Interview -2016 Unix 1) grep command in unix 2) what is set command

1 Answers   HCL,

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

How to create a menu in sqlplus or pl/sql?

0 Answers  

---

What is sql entity?

0 Answers  

---