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 are the dml statements?

682

How to execute a stored procedure?

558

How do you remove duplicates without using distinct in sql?

499

Define a temp table?

550

What does the file extension accdb stand for?

545

What are local and global variables and their differences?

580

What is identity column in sql server?

525

Is there a way to automate sql execution from the command-line, batch job or shell script?

551

What does the acronym acid stand for in database management?

540

Is t sql a programming language?

539

Can we use joins in subquery?

531

How does one use sql*loader to load images, sound clips and documents? : aql loader

668

Is sql similar to python?

532

Name three sql operations that perform a sort.

582

What does trigger mean in slang?

521