pb sqlserver to oracle

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 - 03:26:41 CST