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 to decrement dates by 1 in mysql? : Sql dba

1022

How many triggers can be applied to a table?

1068

what is data control language? : Sql dba

1030

Enlist the data types that can be used in pl/sql?

1073

What is the use of sqlerrd 3?

944

Why stored procedure is better than query?

950

Can you skip header records while loading? : aql loader

1057

Can we use loop in sql?

972

what is the stuff function and how does it differ from the replace function? : Sql dba

1062

Explain architecture of sql server notification services?

1065

what is user defined functions? : Sql dba

1037

What is the most restrictive isolation level? : Transact sql

1087

What is data type in sql?

969

Are stored procedures faster than dynamic sql?

1047

What is trigger price?

999