sqlplus bind variable question

From: Chuck <chuckh1958_nospam_at_gmail.com>
Date: Wed, 29 Sep 2010 11:53:11 -0400
Message-ID: <i7vnd7$cvi$2_at_news.eternal-september.org>

Recently on an SR, Oracle asked me to run a SELECT that included bind variables named :1 and :2. Is it even possible to do that in sqlplus? The only way I know of to make it work is to change the variable names so that they start with a letter (eg :b1 and :b2). Is there a way to do it without changing the names?

example:

var 1 varchar2(20)
exec :1 := 'abc';

That doesn't work, but this does...

var b1 varchar2(20)
exec :b1 := 'abc';
print b1 Received on Wed Sep 29 2010 - 10:53:11 CDT