Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> SELECT statement issue
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Sep 14 2006 - 13:49:12 CDT
![]() |
![]() |