In packages the source code is compiled into p code ? how
do we describe the p code
Answer Posted / srinu
Yes u r correct Swapna,But if we want 2 get the source code
of stored procedure,function,trigger or package ten the
query is......
SELECT text
FROM USER_SOURCE
WHERE NAME='PROCEDURE_NAME/FUNCTION_NAME/TRIGGER_NAME';
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to check if a column is nullable before setting to nullable?
What is pl/sql table? Why it is used?
What is the order of sql select?
What are the different types of a subquery?
What is dynamic sql in pl sql?
What is sql partition?
Why are cursors used?
What is a recursive join sql?
What is having clause in sql?
What is a unique key?
What is memory optimized table?
What is %rowtype in pl sql?
Explain the the delete statements in sql?
What is union and union all keyword in sql and what are their differences?
Explain raise_application_error.