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

Home -> Community -> Usenet -> c.d.o.server -> Re: tricky SQL SELECT - help!

Re: tricky SQL SELECT - help!

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 31 Jan 2003 09:23:13 -0800
Message-ID: <3E3AB101.1E7015A9@exesolutions.com>


Norman Dunbar wrote:

> This is horrible !
>
> SELECT NAME FROM people
> WHERE INSTR((SELECT people_ids FROM pets WHERE pet =
> 'Rat'),';'||TO_CHAR(ID)||';
>
> NAME
> --------------------------------------------------
> John
> Wilma
> Dick
> Mike
>
> 4 rows selected
>
> Can you imagine having to do that with a join to another table on the
> poeople id ?
> Yeuch !
>
>
> Cheers,
> Norman
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: Norman Dunbar
> Posted At: Friday, January 31, 2003 4:11 PM
> Posted To: server
> Conversation: tricky SQL SELECT - help!
> Subject: tricky SQL SELECT - help! (PS)
>
> PS. And having done that, find me a list of all the people who keep rats
> .........
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------

Can you imagine trying to do an update or delete?

Daniel Morgan Received on Fri Jan 31 2003 - 11:23:13 CST

Original text of this message

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