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
Can we join more than 2 tables in sql?
What does stand for in sql?
What are sql queries used for?
Does sql between include endpoints?
Can a commit statement be executed as part of a trigger?
what is commit? : Sql dba
What do we need to check in database testing?
What is a pragma statement?
Which certification is best for sql?
When can we use the where clause and the having clause?
Explain the working of primary key?
Why do we use procedures in sql?
Explain the types of joins in sql?
How is a PL/SQL code compiled?
what are all the different normalizations? : Sql dba