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 |
Please let me know if UNION ALL and Natural Join does the same operation and are same...
What is an intersect?
What is trigger types of trigger?
what is the difference between implicit and explicit trigger
What is the purpose of the sql select top clause?
What is where clause in sql?
How do I send sql query results to excel?
What are the methods of filing?
What is bulk compiling in pl/sql.?
What is diff between bulk collect and forall
What is difference between table and view?
Difference between truncate, delete and drop commands?
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)