Yes u r correct Swapna,But if we want 2 get the source code of stored proc

In packages the source code is compiled into p code ? how
do we describe the p code

Question Posted / srinu

3 Answers
7265 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

Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and left join?

1034

What is application trigger?

1048

What is record type in pl sql?

1025

What is the difference between delete and truncate statement in sql?

1117

What is an inconsistent dependency?

1078

What are field types?

1047

Which operator is used in query for pattern matching?

1125

What are aggregate and scalar functions?

1081

What are keys in sql?

1038

Explain the difference between rename and alias?

1061

What is execution plan in sql?

1087

What are the types of optimization?

1006

List the ways to get the count of records in a table?

940

Is trigger a stored procedure?

974

What are sql queries used for?

1064