What version of Oracle? I believe 9i supports the inner and outer join
syntax.
Jim
"Jon Waterhouse" <jonwaterhouse_at_mail.gov.nf.ca> wrote in message
news:3c0e423c.0_at_209.128.1.3...
> 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 - 10:28:25 CST
