Re: better delete statement to remove duplicate rows from exception

2003-12-11 Thread Dias Costa
); Obviously you cand firstly do a select statment (on a limited set of data), instead of a delete statement, just to be sure it works as expected. Best regards Dias Costa Jacques Kilchoer wrote: In the situation below, is there a better way to write the delete statement that eliminates duplicates

Re: Find an unprintable character inside a column....

2003-10-09 Thread Dias Costa
Peter, i would be interested in that. can you mail it to me ? Dias Costa Robson, Peter wrote: Yes, exactly Stephane - Non-printable characters like this are a proper pest in our environment, to the extent that I have exception reports running every night looking for them (cannot trust

Re: Scrolling Sideways in SQL*Plus

2002-02-08 Thread Dias Costa
Hi ! Do all you have allready done and more: maximize the window. It usualy does the trick. Dias Costa [EMAIL PROTECTED] wrote: Hi, I set the linesize larger and the buffer etc.. I do get the scrollbar and there is data to the right of the screen, but the scrollbar just won't

Re: CROSS TAB QUERY (long)

2001-11-28 Thread Dias Costa
) = M.Month group by S.Product; -- -- If you neeed some more help, I'll be glad to help You. Bye Dias Costa Moses Ngati Moya wrote: Hi Gurus, I have a table Monthly_Stats as below: MONTH VARCHAR2(20), ERLANG NUMBER(7,2) CONGNUMBER(5,2

Re: Fwd: A problem

2001-11-22 Thread Dias Costa
an attached zip file. The file exp_Ora.ftp is a parameter file for to FTP the DMP files to other machine. If you find some strange words in the files, they are Portuguese. Hope it helps. Dias Costa P.S.: My apologies for I have sent the files unziped. Jared Still wrote: -- Forwarded

Re: Fwd: A problem

2001-11-21 Thread Dias Costa
SQLPLUSW to run the above procedure. The outcome is a batch command file called exp_OSC.cmd wich is invoked by the firts batch file to perform the real export. The secret is to use the SQL to create the second file since DOS hasn't the ability to handle strings. Hope it helps. Dias Costa P.S

Re: interesting floating point problem with oracle

2001-09-25 Thread Dias Costa
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dias Costa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

!! *Very* important Oracle-L message !!

2001-08-30 Thread Dias Costa
Jared, I'm in for $12. Dias Costa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dias Costa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: !! *Very* important Oracle-L message !!

2001-08-30 Thread Dias Costa
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dias Costa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists