RE: can't see a SQL generated by Crystal Report
I happen to know that you have to work hard to keep Crystal from doing a SELECT * and doing its own filtering and grouping. It can be done, but you have to KNOW that that is what you want to do, i.e. novices will let Crystal do what it wants. -Original Message- Sent: Tuesday, December 09, 2003 1:45 PM To: Multiple recipients of list ORACLE-L I'm not sure. I'm talking to the application team to see what exactly is being done behind the scene. I do know that I can't capture queries running via ColdFusion server and thought that there may be something like that with Crystal. Gene --- Yechiel Adar <[EMAIL PROTECTED]> wrote: > Are you sure that Crystal does not do any local > processing on the data? > > Yechiel Adar > Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
Re: can't see a SQL generated by Crystal Report
I'm not sure. I'm talking to the application team to
see what exactly is being done behind the scene. I do
know that I can't capture queries running via
ColdFusion server and thought that there may be
something like that with Crystal.
Gene
--- Yechiel Adar <[EMAIL PROTECTED]> wrote:
> Are you sure that Crystal does not do any local
> processing on the data?
>
> Yechiel Adar
> Mehish
> - Original Message -
> To: "Multiple recipients of list ORACLE-L"
> <[EMAIL PROTECTED]>
> Sent: Tuesday, December 09, 2003 12:39 AM
>
>
> > Hi all:
> >
> > I'm trying to catch a DDL generated by Crystal
> report.
> > I'm using the following query to do that:
> > select sql_text
> > from v$sqltext
> > where ( address, hash_value ) in
> > (select sql_address, sql_hash_value
> > from v$session
> >where username = UPPER('&username'))
> > order by piece
> > I am catching a SQL, but that SQL returns
> different
> > amount of rows than the report when executed
> through a
> > Crystal. Is there something wrong with my query
> (it is
> > running under Oracle 817) that makes it miss some
> > data?
> >
> > thanks
> >
> > Gene
> >
> >
> > __
> > Do you Yahoo!?
> > Free Pop-Up Blocker - Get it now
> > http://companion.yahoo.com/
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> > --
> > Author: Gene Gurevich
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> > San Diego, California-- Mailing list and
> web hosting services
> >
>
-
> > To REMOVE yourself from this mailing list, send an
> E-Mail message
> > to: [EMAIL PROTECTED] (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).
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.net
> --
> Author: Yechiel Adar
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (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).
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gene Gurevich
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
Re: can't see a SQL generated by Crystal Report
Are you sure that Crystal does not do any local processing on the data?
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 09, 2003 12:39 AM
> Hi all:
>
> I'm trying to catch a DDL generated by Crystal report.
> I'm using the following query to do that:
> select sql_text
> from v$sqltext
> where ( address, hash_value ) in
> (select sql_address, sql_hash_value
> from v$session
>where username = UPPER('&username'))
> order by piece
> I am catching a SQL, but that SQL returns different
> amount of rows than the report when executed through a
> Crystal. Is there something wrong with my query (it is
> running under Oracle 817) that makes it miss some
> data?
>
> thanks
>
> Gene
>
>
> __
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Gene Gurevich
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
can't see a SQL generated by Crystal Report
Hi all:
I'm trying to catch a DDL generated by Crystal report.
I'm using the following query to do that:
select sql_text
from v$sqltext
where ( address, hash_value ) in
(select sql_address, sql_hash_value
from v$session
where username = UPPER('&username'))
order by piece
I am catching a SQL, but that SQL returns different
amount of rows than the report when executed through a
Crystal. Is there something wrong with my query (it is
running under Oracle 817) that makes it miss some
data?
thanks
Gene
__
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gene Gurevich
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).
