Re: update statment from sybase to oracle

Teresa wrote:
> hello all
>
> I have an update statment that currently works in sybase but I would
> like to use the same into oracle, but not sure how to.... this is 10GR
> 1 on 5.8 solaris and works on sybase 12.0
>
> update mytable sert my_table ='Yes'
> where mycolumn=@column(@colum,34,1) <> 0x00
>
>
> how can i get this to work in oracle?
>
> Any help would be great!
>
> Teresa

You can not. Oracle is not Sybase. You must write SQL in Oracle using the appropriate syntax.

http://www.psoug.org
click on Morgan's Library
click on UPDATE STATEMENTS

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org