This is a discussion on update statment from sybase to oracle within the Oracle Database forums, part of the Database Server Software category; --> hello all I have an update statment that currently works in sybase but I would like to use the ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| ||||
| "Teresa" <tpreto7@sapo.pt> wrote in message news:1164245647.127560.184680@m7g2000cwm.googlegro ups.com... > > 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 > What does the @column mean? Jim |