Re: Why it doesn't work??
From: Gerard H. Pille <ghp_at_infosoft.be>
Date: 1996/03/05
Message-ID: <4hi3gl$oed_at_news.Belgium.EU.net>#1/1
begin
select decode(:a, 0, 'XXX', :a), decode(:b, 0, 'YYY', :b) from dual;
end; Received on Tue Mar 05 1996 - 00:00:00 CET
Date: 1996/03/05
Message-ID: <4hi3gl$oed_at_news.Belgium.EU.net>#1/1
In article <4hhlb9$evs_at_tst.hk.super.net>, chichung_at_news.hk.super.net
says...
!>
!>Hello,
!>
!> I have try the following statements in sqlplus but it can't run
!>successfully. Sqlplus complains that "Variable not bound!!!"
!>
snip (as they say)
!>
!>Chi-Chung
!>
I'm afraid you need a PL/SQL block to work with bind variables, as in :
var a number
var b number
.... .... some data manipulation for a & b ....
begin
select decode(:a, 0, 'XXX', :a), decode(:b, 0, 'YYY', :b) from dual;
end; Received on Tue Mar 05 1996 - 00:00:00 CET