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
what is row? : Sql dba
Name three sql operations that perform a sort.
What is a primary key example?
what is the difference between truncate and delete statement? : Transact sql
What is pl sql record in oracle?
How many times can we commit in a loop?
Why is sql better than hql?
Is left join inner or outer?
Why do we need unique key in a table?
Define commit, rollback and savepoint?
ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..
what are the type of locks ? : Sql dba
What mean sql?
How do I run sql profiler?
what is user defined functions? : Sql dba