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

What is keys and its types?

1059

What is pl sql commands?

1020

Can you inner join the same table?

975

What are primary key and foreign key and how they work?

960

what is 'trigger' in sql? : Sql dba

1065

How to run sql functions in pl/sql?

1038

What is sql prepared statement?

966

How do I pipe the output of one isql to another?

989

Can a foreign key be null?

1068

What are the most important characteristics of pl/sql?

1134

what is the difference between truncate and delete statement? : Transact sql

1045

what is text? : Sql dba

1057

what is meant by urlencode and urldocode? : Sql dba

1153

Can we call stored procedure in function?

938

How to connect a sql*plus session to an oracle server?

1111