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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

Question Posted / swapna

Answers were Sorted based on User's Feedback



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

Answer / swapna

After compiling procedures,functions and triggers(in new
versions only),Those will be stored in the form of p-code
(after parsing) in SGA(System Global Area).

The advantage of p-code is Since it was there in SGA which
can be shared by all,Whenever you execute procedure or
function,It won't be recompiled.It uses already compiled p-
code.So,time can be saved.

Is This Answer Correct ?    2 Yes 0 No

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

Answer / 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

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

Answer / arup ratan banerjee

But Swapna,,,,
Those codes get stored in ALL_SOURCE tables...
Just check this query out...
Select * from ALL_SOURCE where owner='<OWNER_NAME>'
and type='PROCEDURE'


u WILL GET THE SOURCE CODE FROM HERE

Is This Answer Correct ?    0 Yes 2 No

Post New Answer

More SQL PLSQL Interview Questions

Can you upgrade sql express to full sql?

0 Answers  

Difference between truncate, delete and drop commands?

0 Answers  

How do I run sql?

0 Answers  

explain advantages of myisam over innodb? : Sql dba

0 Answers  

how to convert dates to character strings? : Sql dba

0 Answers  

how to escape special characters in sql statements? : Sql dba

0 Answers  

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

How to order siblings in oracle hierarchy queries?

0 Answers  

How to get unique records from a table?

0 Answers  

What are the disadvantages of file system?

0 Answers  

what is the difference between truncate and delete statement? : Transact sql

0 Answers  

What is parameter substitution in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories