@ saurabh...... you just change the table name from dual to table_for_example which you have given below......... example: select decode(mod(deptno,2),0,dname,loc) from dept;
All d best... karthic M On Fri, Jun 26, 2009 at 4:15 PM, sonty <saurabh.zen...@gmail.com> wrote: > > 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 > > > > > -- karthic.M --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
