Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

How to check if a column is nullable before setting to nullable?

1124


What is pl/sql table? Why it is used?

1036


What is the order of sql select?

1041


What are the different types of a subquery?

1047


What is dynamic sql in pl sql?

1033


What is sql partition?

1105


Why are cursors used?

1122


What is a recursive join sql?

1069


What is having clause in sql?

963


What is a unique key?

1054


What is memory optimized table?

1043


What is %rowtype in pl sql?

989


Explain the the delete statements in sql?

1062


What is union and union all keyword in sql and what are their differences?

1105


Explain raise_application_error.

1091