GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  PL/SQL
Go To First  |  Previous Question  |  Next Question 
 PL/SQL  |  Question 189 of 241    Print  
Which type of binding does PL/SQL use?

  
Total Answers and Comments: 6 Last Update: October 16, 2008     Asked by: narayani 
  
 Sponsored Links

 
 Best Rated Answer
Submitted by: Sudeshna
 
It uses early binding

Above answer was rated as good by the following members:
kperumal75, sojimonsn, johnraju
July 20, 2007 09:02:36   #1  
askvenki Member Since: July 2007   Contribution: 18    

RE: Which type of binding does PL/SQL use?
it uses latebinding so only we cannot use ddl staments directly
it uses dynamicbinding

 
Is this answer useful? Yes | NoAnswer is useful 0   Answer is not useful 2Overall Rating: -2    
September 01, 2007 16:04:01   #2  
Sudeshna        

RE: Which type of binding does PL/SQL use?
It uses early binding
 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
October 10, 2007 20:46:30   #3  
Shweta_faqs Member Since: October 2005   Contribution: 22    

RE: Which type of binding does PL/SQL use?
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.
 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    
October 13, 2007 02:37:51   #4  
amahanit Member Since: October 2007   Contribution: 13    

RE: Which type of binding does PL/SQL use?
EARLY BINDING
 
Is this answer useful? Yes | NoAnswer is useful 2   Answer is not useful 0Overall Rating: +2    
January 31, 2008 22:11:22   #5  
g_sidhu Member Since: August 2007   Contribution: 122    

RE: Which type of binding does PL/SQL use?
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.


 
Is this answer useful? Yes | NoAnswer is useful 3   Answer is not useful 0Overall Rating: +3    
October 16, 2008 12:28:22   #6  
nalini07.mca Member Since: October 2008   Contribution: 1    

RE: Which type of binding does PL/SQL use?
late binding


 
Is this answer useful? Yes | NoAnswer is useful 1   Answer is not useful 0Overall Rating: +1    


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape