1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / swapna

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

How do I save a stored procedure?

0 Answers  

what is the difference between where clause and having clause? : Sql dba

0 Answers  

I Defined SP1, Sp2 (sp=StoreProcedures)In Package Specification but I Implemented Sp1, sp2, sp3, sp4, sp5 then What type of Error You will find????

3 Answers   Infosys,

What are the sql commands?

0 Answers  

How do you change a value in sql?

0 Answers  




what is called after appearing where clause

3 Answers  

Which tcp/ip port does sql server run?

0 Answers  

Can a foreign key be null?

0 Answers  

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

Is sql a dbms?

0 Answers  

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

What are field types?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories