Unix Technical Forum

update statment from sybase to oracle

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 ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-25-2008, 01:52 PM
Teresa
 
Posts: n/a
Default 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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-25-2008, 01:52 PM
Jim Kennedy
 
Posts: n/a
Default Re: update statment from sybase to oracle


"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


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:37 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com