RE: Oracle REPLACE function and carriage returns

2003-03-19 Thread Hopper, Wendy S
The query seems to remove the carriage returns when returning the data 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 -- Au

Oracle REPLACE function and carriage returns

2003-03-19 Thread Hopper, Wendy S
ia 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

RE: Query tuning with tablename alias

2002-11-20 Thread Hopper, Wendy S
cal can explain this properly). Regards, Mark. "Hopper, Wendy S" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject:

RE: Query tuning with tablename alias

2002-11-20 Thread Hopper, Wendy S
Regards, Mark. "Hopper, Wendy S" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Query tuning with tablename alias

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 application that 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