GeekInterview.com
Series: Subject: Topic:
Question: 195 of 490

Which type of binding does PL/SQL use?

Asked by: Interview Candidate | Asked on: Jul 19th, 2007

Editorial / Best Answer

Answered by: g_sidhu

Answered On : Jan 31st, 2008

Before a PL/SQL program can be executed, it must be compiled. The PL/SQL compiler resolves references to Oracle objects by looking up their definitions in the data dictionary. Then, the compiler assigns storage addresses to program variables that will hold Oracle data so that Oracle can look up the addresses at run time. This process is called binding.


How a database language implements binding affects runtime efficiency and flexibility. Binding at compile time, called static or early binding, increases efficiency because the definitions of database objects are looked up then, not at run time. On the other hand, binding at run time, called dynamic or late binding, increases flexibility because the definitions of database objects can remain unknown until then.

Showing Answers 1 - 10 of 10 Answers
askvenki

Answered On : Jul 20th, 2007

View all answers by askvenki

It uses latebinding so only we cannot use ddl staments directlyit uses dynamicbinding

  
Login to rate this answer.
Sudeshna

Answered On : Sep 1st, 2007

It uses early binding

Yes  2 Users have rated as useful.
  
Login to rate this answer.

PL/SQL uses early binding which makes the execution of block because as fast as possible as the database objects are already verified by the compiler.

Yes  1 User has rated as useful.
  
Login to rate this answer.

EARLY BINDING

Yes  2 Users have rated as useful.
  
Login to rate this answer.
g_sidhu

Answered On : Jan 31st, 2008

Before a PL/SQL program can be executed, it must be compiled. The PL/SQL compiler resolves references to Oracle objects by looking up their definitions in the data dictionary. Then, the compiler assigns storage addresses to program variables that will hold Oracle data so that Oracle can look up the addresses at run time. This process is called binding. How a database language implements binding affects runtime efficiency and flexibility. Binding at compile time, called static or early binding, increases efficiency because the definitions of database objects are looked up then, not at run time. On the other hand, binding at run time, called dynamic or late binding, increases flexibility because the definitions of database objects can remain unknown until then.

Yes  7 Users have rated as useful.
  
Login to rate this answer.
nalini07.mca

Answered On : Oct 16th, 2008

View all answers by nalini07.mca

Late binding

Yes  1 User has rated as useful.
  
Login to rate this answer.
ajit malik

Answered On : Sep 2nd, 2010

View all answers by ajit malik

Late Binding

  
Login to rate this answer.
gwilson5

Answered On : Sep 4th, 2010

View all answers by gwilson5

When you bind, you associate values from your program(host variables) with placeholders inside your SQL statement.  With static SQL, the PL/SQL, engine itself performs these binds.  With dynamic SQL, you must explicity request a binding of variable values.

  
Login to rate this answer.
pramodh holla

Answered On : Sep 21st, 2010

View all answers by pramodh holla

It uses deferred binding...in the sense it uses both static and dynamic binding.

  
Login to rate this answer.
Art11

Answered On : Sep 24th, 2011

View all answers by Art11

This is the best answer I found:

Early binding is checking for existence of objects referred in the program unit during the compilation phase. Late binding will not check the existence of objects till the runtime

  
Login to rate this answer.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Related Open Questions

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.