SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-25-2008, 01:52 PM
| ||||
| ||||
 update statment from sybase to oracle 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      |
|
02-25-2008, 01:53 PM
| ||||
| ||||
| 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@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
Linear Mode
