Re: question : select

From: Ed Prochak <edprochak_at_adelphia.net>
Date: Mon, 12 May 2003 14:44:40 GMT
Message-ID: <3EBFB77D.9050104@adelphia.net>

(I normally bottom post, but my comments are inline of the top post]

delaigue wrote:

> Hello,
> 
> Thank you for answering,
> 
> 1 ) I've tried to run the subquery alone :
> 
> select dossierid from demande where demandeid between '165000000' and
>   '170000000' and originedemande = 'e-Mail' and etatdemande = 'Transférée'
> 
>  and it does work, it returns what is expected ( one number of lines )
> 
> 2 ) Good remark : it seems to me that thetype of  "demandeid" is "number" ->
> it would be a good reason to make TOAD exit -> I will try without the quotes
> on monday ( when I am back at work )
> 
> PS : what does "IOW" mean ?

shorthand for: In Other Words

> 
> 3 ) Never any error code, TOADD simply runs and runs and runs and doesn't
> react any more to any command : I must force to stop the process TOADD from
> an external way ( by using the "task manager" of Windows )

Oh, so my comment about your english should be corrected instead of "run out" (which you say you meant it runs and runs) say "hangs" (which is generally used to mean the program does not respond)

> 
> 
> Good night

Well, It may take a TOAD user to help. I don't really see anything gravely wrong in your query.

Anyone else care to answer this?

> 
> "Ed Prochak" <edprochak_at_adelphia.net> a écrit dans le message de news:
> 3EBC51C0.4040904_at_adelphia.net...
> 

>>delaigue wrote:
>>
>>>Hello,
>>>
>>>
>>>My purpose is to select the lines from the table "dossier" fulfilling
>>>conditions on fields belonging to the table "demande" ( "dossierid" is a
>>>primary key of table "dossier" and the couple ("dossierid", "demandeid")
>>

> is
> 


>>>a primary key of the table "demande" )

>>>

>>>I've tried to run this request via an interface for oracle ( TOADD ) :

>>>

>>>(1)

>>>select numdossier from dossier

>>>where dossierid in

>>>( select dossierid from demande where demandeid between '165000000' and
>>>'170000000' and originedemande = 'e-Mail' and etatdemande =
>>

> 'Transférée' )
> 

>>>and it does not work, it makes TOADD run out
>>>For, there really is at least one line fulfilling the three conditions
>>
>>What does the subquery alone return?
>>select dossierid from demande where demandeid between '165000000' and
>> '170000000' and originedemande = 'e-Mail' and etatdemande = 'Transférée'
>>
>>
>>Also, is there a reason for quoting the ID numbers?? IOW, why use
>>'165000000'
>>instead of
>> 165000000
>>
>>
>>When Toad exits, what error message does it give?
>>
>>
>>
>>>this one does work ( makes TOADD run out ) :
>>>select MonDossier.numdossier from dossier MonDossier, demande MaDemande
>>>where MonDossier.dossierid = MaDemande.dossierid and
>>

> MaDemande.demandeid
> 

>>>between '165420325' and '165420329'
>>
>>Again what is the error message??????????????
>>
>>
>>>
>>>Can anybody tell me if there is something wrong in the request (1) ?
>>>Or give me a simple way to implement it differently ?
>>>
>>>
>>>
>>>Thank you by advance,
>>>Pascal Delaigue
>>>Good night
>>>
>>>P.S. : perhaps my english/american writing is not good, it's because I'm
>>>french -> if there are big mistakes, please tell me, thanks
>>
>>instead of "run out" say "exit".

-- 
Ed Prochak
running    http://www.faqs.org/faqs/running-faq/
netiquette http://www.psg.com/emily.html
--
"Two roads diverged in a wood and I
I took the one less travelled by
and that has made all the difference."
robert frost

Received on Mon May 12 2003 - 09:44:40 CDT