Sunday, February 22, 2004, 12:06:50 AM, John Flack (JohnF@xxxxxxxx) wrote: JF> But, then you have to get the bind variable into a JF> substitution variable. I liked the addition of bind JF> variables to SQL*Plus, but they can confuse the JF> uninitiated. I wish there was only one kind of variable. The root problem is that SQL*Plus was never *designed*. Features were just added willy-nilly as people wanted them. Whoever it was who first needed bind variables obviously did not need to interact with substitution variables, and there you have it. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:jonathan@xxxxxxxxxxx Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to Oracle-article-request@xxxxxxxxxxx and include the word "subscribe" in either the subject or body. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------