oracle - Single query: Bind Variables vs Literals -


i executing 1 query. of 2 queries, given below, take more time execute?

select column2 sometable column1 = 'some value' 

and

declare   var1 varchar2;   var2 varchar2; begin   var2 := 'some value';   select column2 var2 sometable column1 = :var1 end; 


Comments

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

linux - disk space limitation when creating war file -