Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to convert Sybase update to suite Oracle ???

How to convert Sybase update to suite Oracle ???

From: vipra <gandrakota_at_mailcity.com>
Date: Fri, 01 Jul 2005 14:16:09 -0400
Message-ID: <3bcfc124c8fb3b6cc08700cb892dde94@localhost.talkaboutdatabases.com>


Hi, what is the equivalent oracle DML for the below mentioned sybase one,

update	Table1
set  	a.column3 = b.value3, 
	a.column4 = b.value4, 
	a.column5 = b.value5, 
	a.column6 = b.value6
from 	Table1		 	a,
	Table2		 	b
where	a.column1		= b.column1
and 	a.column2		= 1
and 	b.column2 		> '28-APR-05'
and 	b.column2   		< '01-MAY-05'

Works fine in Sybase but errors out in Oracle. Received on Fri Jul 01 2005 - 13:16:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US