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 '%%' 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). > > __
Re: CROSS TAB QUERY (long)
lues ('CAMISOLAS DE LA', 2106, '2001-MAY-05'); insert into Sales values ('SAIAS DE ALGODAO', 4797, '2001-MAY-05'); insert into Sales values ('SAIAS DE SEDA', 3042, '2001-MAY-05'); insert into Sales values ('PIJAMAS DE SEDA', 2398.5, '2001-JAN-01'); insert into Sales values ('SAIAS DE ALGODAO', 37791, '2001-JAN-01'); insert into Sales values ('SAIAS DE SEDA', 3042, '2001-JAN-01'); insert into Sales values ('PIJAMAS DE SEDA', .5, '2001-JAN-01'); insert into Sales values ('PIJAMAS DE LA', 117, '2001-SEP-11'); insert into Sales values ('PIJAMAS DE SEDA', 2457, '2001-SEP-11'); insert into Sales values ('CAMISOLAS DE LA', 2106, '2001-SEP-11'); insert into Sales values ('SAIAS DE ALGODAO', 4797, '2001-SEP-11'); insert into Sales values ('SAIAS DE SEDA', 3042, '2001-SEP-11'); insert into Sales values ('PIJAMAS DE SEDA', 2398.5, '2001-FEB-21'); insert into Sales values ('SAIAS DE ALGODAO', 37791, '2001-FEB-21'); insert into Sales values ('SAIAS DE SEDA', 3042, '2001-FEB-21'); insert into Sales values ('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.Month
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 > .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 > .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).
Re: !! *Very* important Oracle-L message !!
ere > > > sufficient pledges to enable me to move forward. If it seems like there > > > is, > > > then I will come up with a way for you to honor your pledge (probably > > > either > > > directly to me via check or via PayPal, most likely). The funds can be > > > collected in the next few weeks, but I must make my decision on Friday. > I > > > apologize for the late notice on this, but I was not given this offer by > my > > > ISP until late last week. > > > > > > In return for your contributions, I promise the following things: > > > > > > - I will use all contributions ONLY for the express purpose of paying > for > > > my > > > Internet service costs > > > - I will continue to host the ORACLE-L list for free for the forseeable, > > > indefinite future > > > - I will make no more requests of this list for contributions of this > sort > > > - I will provide a full accounting and update to the list on the costs > and > > > how the funds are being used > > > - I will make improvements to the list that will enhance your features > and > > > performance (for example, faster turn-around on list postings, etc) > > > - I will at least carry though for the next calendar year unless I have > > > catastrophic financial failure > > > > > > Please note that the ODTUG organization is already making a considerable > > > contribution by way of a monthly payment for service, so they are > already > > > aware of this situation and are actively helping out. There are a good > > > number of people here who are on the ODTUG lists too, so I wanted to > point > > > that out ahead of time and let you know that they are being very > helpful. > > > > > > Another way you could contribute would be to come to Fat City for your > list > > > hosting or website hosting needs. I had just started offering website > > > hosting services before this mess started, and obviously, a monthly > paying > > > customer is far better than a one-time contribution. 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).
!! *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).