for function select package.funtname(parameter) from dual/table; for

How to get the procedure's, function's name from a package
if it is wrapped(both spec & body).

Question Posted / kart

Answer Posted / kart

for function

select package.funtname(parameter) from dual/table;

for procedure

exec packagename.procedurename(parameter);

u cant call the trigger

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do temporal tables work?

907

What is break?

1139

Why stored procedure is faster than query?

946

What is nosql db?

923

What normalization means?

902

how can we destroy the cookie? : Sql dba

955

What does joining a thread mean?

972

What are the types of views in sql?

1036

what is the difference between join and union? : Sql dba

1025

What is record in pl sql?

1008

Does truncate need commit?

889

How do you drop a trigger?

922

What is query syntax?

912

What are different methods to trace the pl/sql code?

1046

How many aggregate functions are available there in sql?

926