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

Explain the PL/SQL compilation process.

Question Posted / nashiinformaticssolutions

Answers were Sorted based on User's Feedback



Explain the PL/SQL compilation process...

Answer / nashiinformaticssolutions

The PL/SQL compilation process involves:
• Parsing: The PL/SQL code is checked for syntax errors.
• Compilation: The code is converted into a format the Oracle Database can execute.
• Storage: The compiled code is stored in the database.
• Execution: When the PL/SQL code is called, it is executed by the database engine.

Is This Answer Correct ?    0 Yes 0 No

Explain the PL/SQL compilation process...

Answer / glibwaresoftsolutions

The PL/SQL compilation process involves:
• Parsing: The PL/SQL code is checked for syntax errors.
• Compilation: The code is converted into a format the Oracle Database can execute.
• Storage: The compiled code is stored in the database.
• Execution: When the PL/SQL code is called, it is executed by the database engine.

Is This Answer Correct ?    0 Yes 0 No

Explain the PL/SQL compilation process...

Answer / hr@tgksolutions.com

The PL/SQL compilation process involves:
• Parsing: The PL/SQL code is checked for syntax errors.
• Compilation: The code is converted into a format the Oracle Database can execute.
• Storage: The compiled code is stored in the database.
• Execution: When the PL/SQL code is called, it is executed by the database engine.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Why join is faster than subquery?

0 Answers  

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

Does normalization improve performance?

0 Answers  

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

What is user in sql?

0 Answers  

select sal from emp group by sal

3 Answers   TCS,

What is sql deadlock?

0 Answers  

Where is sql database stored?

0 Answers  

what is the use of double ampersand (&&) in sql queries?

0 Answers  

Is it possible to create the following trigger: before or after update trigger for each row?

0 Answers  

What is a unique key and primary key and foreign key?

0 Answers  

Why partition by is used in sql?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories