RE: Tracing SQL: where is the select in the select ?

Hi,

I don't see any reaction to this as of yet.

I'm not sure I can help, but it could be easier if I'd have the full select-statement and de tkprof-output ...

Greets,

Kirsten

> -----Original Message-----
> From: paquette stephane [SMTP:stephane_paquette_at_yahoo.com]
> Sent: Friday, August 11, 2000 5:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Tracing SQL: where is the select in the select ?
>
> Hi all,
>
> I'm tracing a select containing a select :
> select c1, c2, (select c4,c5 from t1 where...),c3...
> from ..
> where ...
>
> In tkprof, there is no sign of the query "select c4,c5
> from t1 where..." query .
>
> Is that normal ?
>
> =====
> Stephane Paquette
> DBA Oracle
> stephane_paquette_at_yahoo.com
> spaquette_at_houra.fr
> (33) 01 53 93 06 50
>
> __________________________________________________
> Do You Yahoo!?
> Kick off your party with Yahoo! Invites.
> http://invites.yahoo.com/
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Aug 16 2000 - 02:19:19 CDT