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 |
How can we schedule the procedure to run automatically ?
What is sql procedures and functions?
What are variables in pl sql?
Can we create foreign key without primary key?
How to disable a trigger name update_salary?
What is dba in sql? : SQL DBA
What is a primary key called that is made up of more than one field?
How to update salary of employees department wise?
What is different between union and minus?
How many tables can you join in sql?
How can use stored procedures in sql?
How many tables can a sql database have?
Oracle (3253)
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)