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

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / swapna

PAckage Name.ProcedureName(Parameter List)

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL PLSQL Interview Questions

What is null in pl/sql?

0 Answers  


What are the different types of constraints?

0 Answers  


What are the blocks in stored procedure?

6 Answers   Microsoft,


What is difference between TRUNCATE & DELETE?

16 Answers   Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,


What is a database trigger?

0 Answers  






How do I run pl sql in sql developer?

0 Answers  


State the difference between implict and explict cursor's?

7 Answers   CTS,


write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000

6 Answers  


What is sql mysql pl sql oracle?

0 Answers  


What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,


which command using query analyzer will give you the version of sql server and operating system? : Sql dba

0 Answers  


What is date functions?

0 Answers  


Categories