Home -> Usenet -> comp.databases.oracle -> Why it doesn't work??

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 






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












Original text of this message