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

Which are sql * plus commands?

1122

What is the purpose of my sql?

946

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1057

What are predefined functions in sql?

1042

What does where 1/2 mean in sql?

1064

Differentiate between syntax and runtime errors.

1181

What is the importance of sqlcode and sqlerrm?

1352

what are numeric data types? : Sql dba

1060

What is the difference between delete and truncate statement in sql?

1068

What is compilation error in pl sql?

974

Is sql pronounced sequel or sql?

1260

What is sqlservr exe?

974

What are the constraints available in sql?

1046

What can I use instead of union in sql?

964

What is difference between group by and partition by?

1055