You can take any example ..
i just want to know how to use bind variables in TOAD
VARIABLE A NUMBER;
When i declare a bind variable in TOAD its not recognizing it ..giving error ORA-0900 INVALID SQL STATEMENT
ya i know that ..it just to vertify weather bind variables can be used in toad or not.
when i compiled this statement variable a number;
i got error invalid sql statement .thats the reason i got posted. now i came to know F5 is the magic. and my friend is using old version of toad 6. still she is having problem with declaring bind variables.