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
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 |
Is grant a ddl statement?
What is cross join sql?
How do I get sql certification?
What is foreign key in sql with example?
what are the advantages of using stored procedures? : Sql dba
Can we rename a column in the output of sql query?
What problem one might face while writing log information to a data-base table in pl/sql?
Which operator is used in query for pattern matching?
How do I start pl sql?
Explain the difference in execution of triggers and stored procedures?
What are the sql commands?
Which is the correct statement about truncate and delete?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)