Re: Can this SQL works on Oracle7
From: Brian Dick <bdick_at_home.com>
Date: Fri, 16 Nov 2001 14:14:53 GMT
Message-ID: <xb9J7.11317$Xb7.69188_at_news1.wwck1.ri.home.com>
Date: Fri, 16 Nov 2001 14:14:53 GMT
Message-ID: <xb9J7.11317$Xb7.69188_at_news1.wwck1.ri.home.com>
update sessions a
set title = (select 'Day ' || race_day || ' ' || b.type from races b where
a.id = b.session_id)
"David" <oracledba_at_eastmail.com> wrote in message
news:15b372c2.0111151843.41dafabc_at_posting.google.com...
> I'd like to do sth like follow:
>
> UPDATE SESSIONS SET TITLE = 'Day '||b.RACE_DAY||' '||b.type
> FROM SESSIONS a,RACES b
> Where a.id=b.session_id
>
> SQL7 support this function. But oracle7 does not allow me to do it.
> Is any another way?
>
> David
Received on Fri Nov 16 2001 - 15:14:53 CET