Hi all ,
select merchant_name , amount from transctions
where tran_date = '20020210' ;
select merchant_name , amount from transctions
where tran_date = '20020325' ;
1) Is these two statements identical or needs separate
parsing in the shared pool.
2) If these two statements are not identical what is a
real life scenario of two statements being identical and
shares the same parse execution plan ?
3) what is meant by using bind variables and making
statements identical. How is it done in the above case
Thanking in advance
Regards
George
Oracle DBA
National Bank Of Kuwait