Hi Guys,

I have a table

table_for_example
------------------------
column1      number
column2      varchar2(100)
column3      long



now my query is ,

select decode(mod(column1,2),0,column2,column3) from dual;

It simply fails, why??

What is the way to achieve the desired result?


Br,
Sonty


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to