Setting bind variables in sql*plus

variable b1 varchar2(6) ;
exec :b1 := '2009'

Used mainly for sql tuning rather than in real code.

Leave a Reply