Re: better delete statement to remove duplicate rows from exception
Hi, You can do this: delete from orders o1 where rowid(select max(rowid) from orders o2 where o1.order_id = o2.order_id group by order_id having count(order_id) 1); 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? (assuming duplicate rows form at most 5 % of the table rows) Notice that the exceptions table is not analyzed. If I analyze the exceptions table, is there then another better way to write it? create table my_exceptions (row_id urowid, owner varchar2 (30), table_name varchar2 (30), constraint varchar2 (30) ); create table orders (order_id number (8) not null, order_date date, constraint orders_uq1 unique (order_id) disable ) ; /* -- load table orders with millions of rows */ create index orders_idx1 on orders (order_id) ; analyze table orders estimate statistics sample 10 percent ; alter table orders enable constraint orders_uq1 exceptions into my_exceptions ; delete from orders a where a.rowid in (select d.delete_row_id from (select min (b.row_id) over (partition by c.order_id) as keep_row_id, b.row_id as delete_row_id from my_exceptions b, orders c where c.rowid = b.row_id group by c.order_id, b.row_id ) d where d.delete_row_id != d.keep_row_id ) ; commit ; alter table orders enable constraint orders_uq1 ; truncate table my_exceptions ; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dias Costa 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: Find an unprintable character inside a column....
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 the users...). I have a small PL/SQL piece of code used to detect these things, if anyone wants it. peter edinburgh -Original Message- Sent: Thursday, October 09, 2003 9:54 AM To: Multiple recipients of list ORACLE-L Steve, If you are patient, I guess that something like where dump(problem_column) like '%target hex%' should more or less answer your question. HTH SF - --- Original Message --- - From: Steve Main [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 08 Oct 2003 15:44:26 Hello list, I have an application that is choking on the following error, ...invalid character (Unicode: 0x19) was found in the element content... Does anyone know how I could go about searching for this invalid character? Thanks Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dias Costa 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: Scrolling Sideways in SQL*Plus
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 work HTH Jack Rachel Carmichael [EMAIL PROTECTED]@fatcity.com on 07-02-2002 15:08:33 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL) set linesize larger --- [EMAIL PROTECTED] wrote: Hi All, Maybe a stupid question but this is bugging me. In SQL*Plus I get a scrollbar sideways but can't use it even though there is data to the right of the screen. I looked at all the settings but can't find the setting to make it usable 8.1.6 8.1.7 Client on W2K Anybody??? TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] 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: [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). == De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging
Re: CROSS TAB QUERY (long)
('PIJAMAS DE SEDA', .5, '2001-FEB-21'); insert into Sales values ('PIJAMAS DE LA', 117, '2001-MAR-01'); insert into Sales values ('PIJAMAS DE SEDA', 2457, '2001-MAR-01'); insert into Sales values ('CAMISOLAS DE LA', 3276, '2001-MAR-01'); insert into Sales values ('SAIAS DE ALGODAO', 4797, '2001-MAR-01'); insert into Sales values ('SAIAS DE SEDA', 4212, '2001-MAR-01'); insert into Sales values ('PIJAMAS DE SEDA', 643.5, '2001-OCT-05'); insert into Sales values ('SAIAS DE ALGODAO', 2457, '2001-OCT-05'); insert into Sales values ('SAIAS DE SEDA', 702, '2001-OCT-05'); insert into Sales values ('PIJAMAS DE SEDA', 526.5, '2001-OCT-05'); insert into Sales values ('PIJAMAS DE LA', 117, '2001-NOV-05'); insert into Sales values ('PIJAMAS DE SEDA', 1597.05, '2001-NOV-05'); insert into Sales values ('CAMISOLAS DE LA', 3276, '2001-NOV-05'); insert into Sales values ('SAIAS DE ALGODAO', 2158.65, '2001-NOV-05'); insert into Sales values ('SAIAS DE SEDA', 2084.94, '2001-NOV-05'); insert into Sales values ('PIJAMAS DE SEDA', 386.1, '2001-DEC-05'); insert into Sales values ('SAIAS DE ALGODAO', 1474.2, '2001-DEC-05'); insert into Sales values ('SAIAS DE SEDA', 231.66, '2001-DEC-05'); insert into Sales values ('PIJAMAS DE SEDA', 473.85, '2001-DEC-05'); insert into Sales values ('CERVEJA LAGER', 117, '2001-JAN-01'); -- -- drop table Months; -- create table Months (Month varchar2(3), Month1 numeric(2), Month2 numeric(2), Month3 numeric(2), Month4 numeric(2), Month5 numeric(2), Month6 numeric(2), Month7 numeric(2), Month8 numeric(2), Month9 numeric(2), Month10numeric(2), Month11numeric(2), Month12numeric(2)); -- -- insert into Months values('JAN',1,0,0,0,0,0,0,0,0,0,0,0); insert into Months values('FEB',0,1,0,0,0,0,0,0,0,0,0,0); insert into Months values('MAR',0,0,1,0,0,0,0,0,0,0,0,0); insert into Months values('APR',0,0,0,1,0,0,0,0,0,0,0,0); insert into Months values('MAY',0,0,0,0,1,0,0,0,0,0,0,0); insert into Months values('JUN',0,0,0,0,0,1,0,0,0,0,0,0); insert into Months values('JUL',0,0,0,0,0,0,1,0,0,0,0,0); insert into Months values('AUG',0,0,0,0,0,0,0,1,0,0,0,0); insert into Months values('SEP',0,0,0,0,0,0,0,0,1,0,0,0); insert into Months values('OCT',0,0,0,0,0,0,0,0,0,1,0,0); insert into Months values('NOV',0,0,0,0,0,0,0,0,0,0,1,0); insert into Months values('DEC',0,0,0,0,0,0,0,0,0,0,0,1); -- -- -- just to see what's in the Sales table -- select Product, substr(to_char(Invoice_Date),4,3) as Month, sum(Value) as Sales_Value from Sales group by Product, Invoice_Date / -- -- Finaly testing ... -- set linesize 200 set pagesize 24 column Product format a20 -- selectS.Product as Product, sum(S.Value * M.Month1) as January, sum(S.Value * M.Month2) as February, sum(S.Value * M.Month3) as Mars, sum(S.Value * M.Month4) as April, sum(S.Value * M.Month5) as May, sum(S.Value * M.Month6) as June, sum(S.Value * M.Month7) as July, sum(S.Value * M.Month8) as August, sum(S.Value * M.Month9) as September, sum(S.Value * M.Month10) as October, sum(S.Value * M.Month11) as November, sum(S.Value * M.Month12) as December from Sales S, Months M where substr(to_char(S.Invoice_Date),6,3) = 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) . . CSETUP NUMBER(5,2) A record is inserted in this table every end of month. I would like to write an SQL query to produce output below: MONTH JAN FEB MAR APR MAY . . . DEC ERLANG 777 999 98 66 87 999 CONG9 6 3 4 2 4 CSETUP . . . I do not know the number of months in advance, i.e. if the table has 3 months (JAN, FEB, MAR), these are the only months I need in the report. Any suggestions?? Moses Moya Ngati -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Moses Ngati Moya INET: [EMAIL PROTECTED] 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: [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
Re: Fwd: A problem
Hi ! May be this will help you (I hope). This solution is for Windows (X) but with some work it will do also in UNIX. A procedure called BackupOSC is created by the DBA in his schema. A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls 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. The example files are within 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 Message -- Date: Wed, 21 Nov 2001 15:34:27 +0100 I have created a job to export a user shema How can I tell Oracle each time it make the export to use lets say namedate.dmp I mean for example if today is 21.11.2001 the exported file whoud have name21112001.dmp or something like this... --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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.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 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: Fwd: A problem
Hi ! May be this will help you (I hope). This solution is for Windows (X) but with some work it will do also in UNIX. A procedure called BackupOSC is created by the DBA in his schema. A job is created with at command, invoking the batch command file backup_OSC.cmd wich in turn calls 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.: The files are attached. 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. Jared Still wrote: -- Forwarded Message -- Date: Wed, 21 Nov 2001 15:34:27 +0100 I have created a job to export a user shema How can I tell Oracle each time it make the export to use lets say namedate.dmp I mean for example if today is 21.11.2001 the exported file whoud have name21112001.dmp or something like this... --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] 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: [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). exp_OSC.cmd Description: application/unknown-content-type-cmdfile The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. -- file: backupSmartUser.sql -- - set linesize 300 set echo on set feed off set serveroutput on size 1 set sqlprompt 'REM ' spool D:\Export_Oracle\exp_OSC.cmd execute system.BackupOSC; spool off exit -- file: cp_BackupOSC.sql -- -- -- -- procedure invoked for the backup of schema: OSC -- -- create or replace procedure BackupOSC as -- Linha0 varchar2 (20); Linha1 varchar2 (100); Linha2 varchar2 (200); Linha3 varchar2 (30); Linha4 varchar2 (40); Linha5 varchar2 (250); Linha6 varchar2 (250); Linha7 varchar2 (10); begin Linha0 := 'ECHO ON'; -- SELECT 'ECHO ' into Linha1 FROM DUAL; -- SELECT 'ECHO Backing up the OSC user (Instance DC8i) done on: ' || TO_CHAR(SYSDATE,'/MM/DD') || ' starting time ' || TO_CHAR(SYSDATE,'hh:mm:ss') into Linha2 FROM DUAL; -- Linha3 := 'SET ORACLE_SID=DC8i'; Linha4 := 'SET ORACLE_HOME=E:\ORACLE\ORA81'; -- SELECT 'exp USERID=system/manager owner=OSC FILE=d:\Export_Oracle\OSC_' || TO_CHAR(SYSDATE,'MMDD_HHMI') || ' LOG=d:\Export_Oracle\OSC_' || TO_CHAR(SYSDATE,'MMDD_HHMI') || ' BUFFER=40 COMPRESS=y' into Linha5 FROM DUAL; -- SELECT 'ECHO Backup finished: ' || TO_CHAR(SYSDATE,'hh:mi:ss') || ' d:\Export_Oracle\OSC_backups.log' into Linha6 FROM DUAL; -- Linha7 := 'EXIT'; -- dbms_output.put_line(linha0); dbms_output.put_line(linha1); dbms_output.put_line(linha2); --dbms_output.put_line(Linha3); not needed --dbms_output.put_line(Linha4); not needed dbms_output.put_line(linha5); dbms_output.put_line(linha6); --dbms_output.put_line(linha7); will see end BackupOSC; / oracle01 franca4 binary prompt no cd /usr/oraexp mput d:\Export_Oracle\*.DMP bye backup_OSC.cmd Description: application/unknown-content-type-cmdfile
Re: interesting floating point problem with oracle
Hi ! Neither for me ... Jamadagni, Rajendra wrote: Not for me SQL select 62.323/62.323 from dual; 62.323/62.323 - 1 SQL exit Disconnected from Oracle8i Enterprise Edition Release 8.1.6.1.0 - Production With the Partitioning option JServer Release 8.1.6.1.0 - Production __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] 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: [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.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 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).
!! *Very* important Oracle-L message !!
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 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: !! *Very* important Oracle-L message !!
. If you go to http://www.fatcity.com and click on the Website Hosting link, you can check out the packages I offer. In an effort to get new customers, I am willing to waive all setup fees in order to bring new customers on board. If you become a customer here in the next couple of months, that would help tremendously. If you have an interest in hosting your website (personal or business) with us, -or- a want to start a new mailing list, please contact me for details. I know this is a lot to ask of you folks. You are entirely welcome to just tell me to jump in a lake, and that that's how business is right now. But I know many of you personally, either from ODTUG conferences or from other Oracle events, and I also know how staunchly you support this mailing list with useful information, humor, helpfulness and an eye toward quality. I would like to think that you find Fat City to be the best place to host your list, and that you will want to help me out so that I can continue to provide the list to you folks free of charge. I made a promise to Jared years ago to host this list for free because I think it is one of the best and most valuable resources out there. I intend to honor that promise to him by continuing to provide it for free. If it turns out that I must close shop and call it quits, at least I will have known I did my best to make it succeed, and I did so without having to reneg on committments I had made in the past. I am being open and honest with everyone because I believe that this is the best way to succeed. I believe you appreciate this kind of approach, and I want you to know that regardless of what happens, I certainly appreciate every consideration you give this request. Whether or not this succeeds, I know that you are a great group of people and I wish this list the best luck in this life, or the next. :-) Remember, time is of the essence. The sooner I hear from people who can help, the sooner I can nail down a line of approach. If you have any questions or concerns, please E-mail me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] 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: [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.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] 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: [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.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 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).