Oracle vs. MS-SQL dialects

I have about 900 lines of stored procedure code that I wrote in MS-SQL that I need to transfer to run on an Oracle database.

I know there are some things I have to change, in particular:

parameter passing, which have to be explicitly passed as in out or in out

all my SELECT ... FROM sometab INNER JOIN someothertab ON somefield=someotherfield WHERE ...
will have to have the JOIN info put into the WHERE clause using + operators for outer joins etc.

What would replace

DECLARE @val
SET @val=1
select * from tab where sexval=@val

would it be

DEFINE val=1
select * from tab where sexval=&val
UNDEFINE val

or am I missing something?

Thanks,

Jon Received on Wed Dec 05 2001 - 09:51:37 CST