Oracle REPLACE function and carriage returns

2003-03-19 Thread Hopper, Wendy S
, but when I spool the output to a file it still shows ^m followed by * in it. Any ideas on what is going on here? Thanks for any help. Wendy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hopper, Wendy S INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Oracle REPLACE function and carriage returns

2003-03-19 Thread Hopper, Wendy S
via sqlplus, but when I spool the output to a file it still shows ^m followed by * in it. Any ideas on what is going on here? Thanks for any help. Wendy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hopper, Wendy S INET: [EMAIL PROTECTED] Fat City Network Services

Query tuning with tablename alias

2002-11-20 Thread Hopper, Wendy S
Title: Message Hello list. I have recently been tasked with trying to optimize some slow performing queries (Oracle 8.1.7) for an applicationthat generates reports in a data warehouse type environment. I have noticed in most of the queries that the table names have been aliased, but not

RE: Query tuning with tablename alias

2002-11-20 Thread Hopper, Wendy S
. Hopper, Wendy S To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wendy.hopper@ cc: eds.com Subject: Query tuning with tablename alias

RE: Query tuning with tablename alias

2002-11-20 Thread Hopper, Wendy S
this properly). Regards, Mark. Hopper, Wendy S To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wendy.hopper@ cc: eds.com Subject: Query tuning