How to call the function and Procedure in trigger?

Answer Posted / rakesh keshu

With the help of call statement..without semicolon

create or replace trigger tri_call


begin
call p1()



end tri_call;

Is This Answer Correct ?    12 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the most restrictive isolation level? : Transact sql

767


What do you mean by table in sql?

694


Mention what is the function that is used to transfer a pl/sql table log to a database table?

661


Is ms sql traffic encrypted?

680


I need a function for a train ticket reservation please answer it thanks in advance

758






How can you create an empty table from an existing table?

796


How much does a sql dba make? : SQL DBA

666


Does truncate release storage space?

765


how would you get the current date in mysql? : Sql dba

722


What is posting?

776


What are the two parts of design view?

768


Can instead of triggers be used to fire once for each statement on a view?

709


What is mdf ldf and ndf?

744


How insert into statements in sql?

787


How does sql*loader handles newline characters in a record? : aql loader

761