Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How can i use decode to deside a boolean variable?

477025Feb 24 2006 — edited Feb 27 2006
declare
c1 varchar2(200);
b1 boolean;
begin
b1=true;
select decode(b1,true,'1111111111','3333333333') into c1 from dual;
dbms_output.put_line(c1);
end;

error message:
ora-06550
PLS-00103

3Q.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2006
Added on Feb 24 2006
4 comments
9,297 views