SELECT statement issue

From: "Harvinder Singh" <Harvinder.Singh@xxxxxxxxxxxxx>
To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 14 Sep 2006 14:49:12 -0400

Hi,

 

We are porting the application from SQL Server to Oracle, we have lot of
queries in the xml file and the application read the queries from the
file.

In some scenarios we have following construct in sql server where we are
checking the value and depending upon it running one of the 2 sql's:

If (values = 'xyz')

Begin 

Select....

End

Else

begin

Select.....

End

 

Oracle somehow don't like this construct and giving error : ORA-00900:
invalid SQL statement

 

What is the way to port this to oracle?

 

Thanks

--Harvinder

Follow-Ups:

Re: SELECT statement issue
From: Ganesh Raja

Re: SELECT statement issue
From: Mark Brinsmead

SELECT statement issue

Other related posts: