Re: pb sqlserver to oracle

Oracle will give errors since this is procedural SQLServer code and not a SQL statement.

just

run
SELECT
UNION
SELECT otherwise it's down to the PL/SQL Users Guide and write a stored procedure to correspond to the one you are using in SQLServer.

HTH
"slashes" <slashes_at_oreka.com> wrote in message news:f2d1fb36.0301300127.42464cf5_at_posting.google.com...
> Hello,
>
> I'm newbie in Oracle and I'd would like to transform my SQL Server
> statement to Oracle statement. I don't know how transform my SQl
> statement (oracle gives errors).
>
> Here is my code:
>
>
> IF((select count(*) from Acteurs) != 0)
> BEGIN
> select ...
> union
> select ...
> END
> ELSE
> BEGIN
> select ...
> END
>
> If anyone could help me;
>
> Thanks a lot,
>
> Jerome
Received on Thu Jan 30 2003 - 05:29:23 CST