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