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 do you break a loop in pl sql?

984


Can delete statement be rollbacked?

930


What is on delete set null?

1034


Is inner join same as self join?

1059


What is scope and visibility in PL/SQL?

1110


What are the two different parts of the pl/sql packages?

1023


Explain aggregate functions are available there in sql?

938


What is trigger in sql? Explain

940


What is the difference between the conventional and direct path loader? : aql loader

1109


Which language is used in sql?

986


when MSQL8.0 is in market

2012


Explain locks? : Transact sql

949


What is record in pl sql?

1008


how to convert dates to character strings? : Sql dba

1069


Is trigger a stored procedure?

884