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

Answer Posted / swapna

PAckage Name.ProcedureName(Parameter List)

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the use of anchoring object? what r the difference between anchoring object & enclosing object? can any one tell me all the details?

2001


What is procedure explain with example?

530


Does sql profiler affect performance?

549


What is the difference between function and procedure in pl/sql?

531


How many primary keys can a table have?

526






How do I add a database to sql?

567


What is dml with example?

511


how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc

3228


Explain the the update statement in sql?

562


Is sql microsoft?

539


Explain the rollback statement?

570


What is sql data?

542


what is user defined functions? : Sql dba

543


Can pl sql procedure have a return statement?

546


How do sql triggers work?

546