SQL Server sql to Oracle sql

DonnieBrasco · 2008-11-18 15:39:30

Hi, Can someone translate this into an ORACLE compliant sql statement. update TABLE3 set code = ltrim(rtrim((select Col003 from TABLE2 where ID = a.ID and Col002 = 1))) from TABLE3 a I cant for the life of me produce the results the sql svr guy is getting. cheers db

18-11-2008 04:39PM

#1

DonnieBrasco

Registered Users, Registered Users 2 Posts: 169 ✭✭

Join Date: September 2005

Posts: 111

Hi,

Can someone translate this into an ORACLE compliant sql statement.

update TABLE3
set code = ltrim(rtrim((select Col003
from TABLE2
where ID = a.ID and Col002 = 1)))
from TABLE3 a

I cant for the life of me produce the results the sql svr guy is getting.
cheers
db

0

Comments

#2 18-11-2008 05:05PM

lynchie

Registered Users, Registered Users 2, Paid Member Posts: 2,033 ✭✭✭

Join Date: November 2001

Posts: 1914

Is the equivalent of ltrim(rtim()) not the same as the trim() function in oracle?

i.e.

update TABLE3
set code = ( select trim(Col003)
from TABLE2
where ID = a.ID and Col002 = 1)
from TABLE3 a

my oracle is very rusty!!

0
#3 18-11-2008 05:47PM

Tom Dunne

Registered Users, Registered Users 2 Posts: 23,202 ✭✭✭✭

Join Date: May 2001

Posts: 21043

I would say drop the 'from TABLE3 a' bit.

Handy link: Oracle SQL reference.

0
#4 18-11-2008 06:09PM

DonnieBrasco

Registered Users, Registered Users 2 Posts: 169 ✭✭

Join Date: September 2005

Posts: 111

cheers.
my source data in both systems was not matching which didnt help!

0