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 sql rowcount?

0 Answers  

---

What is difference between pls_integer and integer?

0 Answers  

---

Which data type is a composite type?

0 Answers  

---

Why do we need unique key in a table?

0 Answers  

---

What are the two parts of design view?

0 Answers  

---

what is the sql query to display current date? : Sql dba

1 Answers  

---

Is join and inner join the same?

0 Answers  

---

write a qurey for finding the length of the sting.

6 Answers   Infosys, TCS,

---

what is a tablespace? : Sql dba

0 Answers  

---

what is csv? : Sql dba

0 Answers  

---

how do you login to mysql using unix shell? : Sql dba

0 Answers  

---

How can we Get the Updated Rows? ie, There is 100s of Rows i updated the Rows who have salary 5000. then i want to select the Updated Rows. How can we achieve it?

4 Answers   Fidelity, KCP,

---