SQL*ASSIST QUESTION ??
From: DEREK KONRAD <KONRAD_at_BMS.COM>
Date: Tue, 28 Jun 1994 14:34:19 -0500
Message-ID: <KONRAD-280694143419_at_bullwinkle.bms.com>
Date: Tue, 28 Jun 1994 14:34:19 -0500
Message-ID: <KONRAD-280694143419_at_bullwinkle.bms.com>
This is question regarding SQL*Assist.
Could someone tell me as to why I was unable to use the 'Decode' function
in SQL*Assist. I was able to run the SQL (select st.) statement perfectly
in
SQL*PLUS. But when I ran the same statement in SQL*ASSIST, it gave me an
error
'missing parameter' followed by
the entire decode statement.
the decode statement was in the if then else format
viz.
decode(table1.comparison,'>=','>='||view1.min,'<=','<='||view1.max,null)
thanks in anticipation Received on Tue Jun 28 1994 - 21:34:19 CEST