In packages the source code is compiled into p code ? how
do we describe the p code
- 3 Answers
- 6362 Views
- I also Faced
- E-Mail Answers
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 difference between function and trigger?
what is commit? : Sql dba
Is natural join and inner join same?
What are the syntax and use of the coalesce function?
Why join is faster than subquery?
What is character functions?
In what condition is it good to disable a trigger?
Write the command to remove all players named sachin from the players table.
What is sql exception?
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 tables and fields?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
How many row comparison operators are used while working with a subquery?
how mysql optimizes distinct? : Sql dba
what is single byte over head in oracle..?
