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 do you break a loop in pl sql?
Can delete statement be rollbacked?
What is on delete set null?
Is inner join same as self join?
What is scope and visibility in PL/SQL?
What are the two different parts of the pl/sql packages?
Explain aggregate functions are available there in sql?
What is trigger in sql? Explain
What is the difference between the conventional and direct path loader? : aql loader
Which language is used in sql?
when MSQL8.0 is in market
Explain locks? : Transact sql
What is record in pl sql?
how to convert dates to character strings? : Sql dba
Is trigger a stored procedure?