SELECT a.sql_basics
,b.chapter3
FROM bookshelf
,b.book
WHERE b.chapter3 = 'basic sql constructs'
AND a.sql_basics = 'book that should be read before posting requests like
this';
;o)
-Original Message-
Sent: 05 December 2001 09:55
To: Multiple recipients of list ORACLE-L
And yea, I got the syntax wrong ;o)) Don't point it out to methe bad day
continues...
-Original Message-
Sent: 05 December 2001 11:25
To: '[EMAIL PROTECTED]'
Importance: High
SELECT a.sql_basics
,b.chapter3
FROM bookshelf
,b.book
WHERE b.chapter3 = 'basic sql construc
Roland,
How about
update B
set PRICE = (select NEW_PRICE from A where )
where language_code = 412
Shailesh
-Original Message-
Sent: Wednesday, December 05, 2001 6:35 AM
To: Multiple recipients of list ORACLE-L
Hallo,
How can I update the field PRICE in table B
with price
ha, ha. you got bit by the "null" update thing too, I remember it
well! :)
except for maybe some newfangled oracle8 features, the "ugly" one is
the "traditional" way the manual says to do it (iirc). I have many
many scripts with that kind of code in them since we load mainframe
datafiles into
if it was for one column you could use nvl or decode
update tablea set firstname=nvl((select firstname from tableb where
tablea.id=tablea.id), firstname);
Alex Hillman
-Original Message-
Sent: Wednesday, May 30, 2001 3:56 PM
To: Multiple recipients of list ORACLE-L
Seems like Oracle D
Eric D. Pierce" <[EMAIL PROTECTED]>
> Date: Wed, 30 May 2001 13:02:14 -0700
> Subject: Re: Update Query
>
>ha, ha. you got bit by the "null" update thing too, I remember it
>well! :)
>
>except for maybe some newfangled oracle8 features, the "ugly" one is
Title: RE: update query??? HELP!!!
> -Original Message-
> From: Janet Linsy [mailto:[EMAIL PROTECTED]]
>
> How to do this query, I have three tables:
> SERVICE_LOCATION a, SERVICE_LOC_AREA b, FRANCHISE_AREA
> c.
>
> The relationship between them is:
update SERVICE_LOCATION a set CENTRAL_OFFICE_CODE =
(select FRANCHISE_NAME
from FRANCHISE_AREA c, SERVICE_LOC b where
a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and
b.FRANCHISE_ID = c.FRANCHISE_ID)
At 02:55 PM 11/14/01 -0800, you wrote:
>H
Title: RE: update query??? HELP!!!
> -Original Message-
> From: Janet Linsy [mailto:[EMAIL PROTECTED]]
>
> I got
>
> (select c.franchise_name
> *
> ERROR at line 3:
> ORA-01427: single-row subquery returns more than one
> row
>
> How can I so