Re: case inside a select statement..how to deal wit it??

From: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Fri, 6 Jul 2007 21:01:47 +0100
Message-ID: <CyzwVnUr+pjGFwoG_at_jimsmith.demon.co.uk>

In message <1183720313.309036.160180_at_e9g2000prf.googlegroups.com>, Shishir <shishir456_at_gmail.com> writes
>no it dint work before i modified also..
>basically what i want to achieve is to check the status of IsActive
>column which holds binary 0 or 1..i expect this procedute to display
>"active" when its one and inactive if 0..tats why case statement has
>been used..
>

As others have pointed out the problem is with a semicolon in the middle of a sql statement.
If the migration workbench generated this code then you should report it as a bug, either in metalink or in the migration workbench forum.

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>

Received on Fri Jul 06 2007 - 22:01:47 CEST

This message: [ Message body ]
Next message: papalphaus_at_yahoo.com: "Re: Attaching form library to another form library in 10g"
Previous message: Frank van Bortel: "Re: Attaching form library to another form library in 10g"
Maybe in reply to: Shishir: "case inside a select statement..how to deal wit it??"
In reply to Shishir: "Re: case inside a select statement..how to deal wit it??"
Next in thread: sybrandb_at_hccnet.nl: "Re: case inside a select statement..how to deal wit it??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message