Why it doesn't work??
From: Mr Chung Chi Wong <chichung_at_news.hk.super.net>
Date: 1996/03/05
Message-ID: <4hhlb9$evs_at_tst.hk.super.net>#1/1
Date: 1996/03/05
Message-ID: <4hhlb9$evs_at_tst.hk.super.net>#1/1
Hello,
I have try the following statements in sqlplus but it can't run
successfully. Sqlplus complains that "Variable not bound!!!"
var a number
var b number
....
.... some data manipulation for a & b
....
select decode(:a, 0, 'XXX', :a), decode(:b, 0, 'YYY', :b)
from dual;
^^^^^^
this select statement doesn't work!!
Chi-Chung Received on Tue Mar 05 1996 - 00:00:00 CET