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 |
What is null in pl/sql?
What are the different types of constraints?
What are the blocks in stored procedure?
What is difference between TRUNCATE & DELETE?
16 Answers Ahn Infotech, CitiGroup, ICICI, PreVator, Saama Tech, SkyTech, TCS,
What is a database trigger?
How do I run pl sql in sql developer?
State the difference between implict and explict cursor's?
write a query to find out the no. of employees whose age is less than 25 and max of salary for the employees belonging to a particular department is less than 20000
What is sql mysql pl sql oracle?
What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..
1 Answers Metric Stream, Polaris,
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is date functions?