RE: SUPPRESS SQL STATEMENTS
I run the following script, and the -S option solved the problem I had (I even had the line # out in the script and re-invoked it). If the username/pw is on a separate line as shown below, the ps command does not display the userid/pw info. # Set environment variables#!/bin/ksh # Set local environment variablesORACLE_BASE=/opt/oracleJOBDATE=`date '+%Y%m%d'`; export JOBDATE;JOBTIME=`date '+%H%M'`; export JOBTIME; sqlplus -S EOFusername/[EMAIL PROTECTED]set echo offrest of script EOF[EMAIL PROTECTED] wrote: what are the limitations? other than ps commands that can read past a 3k command line "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 12:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SUPPRESS SQL STATEMENTSTrue, but last I checked it had a number of limitations... it's basically a band-aid, while the patient is hemorrhaging. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 15, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SUPPRESS SQL STATEMENTSnot a pr! oblem on most *nix if you use hide.c http://www.cybcon.com/~jkstill/util/zips/hide.tgz Jared "Norris, Gregory T [ITS]" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/15/2003 06:49 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]cc:Subject:RE: SUPPRESS SQL STATEMENTSOn *nix systems, the username/password information will be visible to all via the "ps" command. Not good.-Original Message-Sent: Tuesday, October 14, 2003 11:09 AMTo: Multiple recipients of list ORACLE-LDon't run the script while you're inside sqlplus. Run it from outside:sqlp! lus un/pw @your-script-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Norris, Gregory T [ITS]INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California-- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [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 mayalso send the HELP command for other information (like subscribing).
RE: SUPPRESS SQL STATEMENTS
The script is run from a cron job with a ksh script calling the sql from outside sqlplus. I've solved the problem by using sed to cull the offensive lines, but I should be able to use sqlplus formatting statements to give the correct results. I did include message off (from a previous email), but the results remain the same sofar. --- Khedr, Waleed [EMAIL PROTECTED] wrote: Don't run the script while you're inside sqlplus. Run it from outside: sqlplus un/pw @your-script -Original Message- Sent: Monday, October 13, 2003 12:49 PM To: Multiple recipients of list ORACLE-L A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller 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).
SUPPRESS SQL STATEMENTS
A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT@path/scriptname and PROMPT spool off statements from the report output. The script contains both set heading off and set feedback off as part of the formatting. Posssible solutions? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller 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).
Sql query : select max timestamp value from table
I have multiple timestamps values for single ip in a table, I need the max(timestamp)for each ip I select out. example: timestamp ip 2003-09-29 13:20:23 68.209.182.42003-09-29 13:20:44 68.209.182.42003-10-02 12:53:38 68.209.182.42003-10-02 12:35:06 68.75.94.1582003-10-02 12:52:03 68.97.33.69 Thus select distinct ip, max(timestamp) from table group by ip, timestamp; returns every timestamp value per ip. Any ideas on how to get only the max(timestamp) for each ip?
UNIX : script help/input
Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file? 'File content: Server: dns1.mci.comAddress: 199.249.19.1 Name: WCOM-4NXZGAPWY5.mcilink.comAddress: 166.50.73.209 Delimited file should have the following line(s); (using | or whatever asdelimiter): '166.50.73.209'|'4NXZGAPWY5.mcilink.com'. Required for both single and multiple records. TIA
Re: UNIX : script help/input
Mladen, It worked! Heartfelt thank you from the evangelized perl crowd (now watch the list-owner grin).Mladen Gogala [EMAIL PROTECTED] wrote: #!/usr/bin/perl -wuse strict;use bytes;my ($NAME,$IP,@LB);while () {chomp;@LB=split /\s+/;if ($LB[0] =~ /^name:/i) {$NAME=$LB[1];}if ($LB[0] =~ /^address:/i) {$IP=$LB[1];write;}}format STDOUT=@ ,@$NAME,$IP
RE: PL/SQL Question:Eliminate duplicate rows
Job well done, Tom, the embarrasment is of no consequence. The routine was modified to include Ron's pointer. Stats for Tom's first routine below: load table 1.3 million rows, results table (deduped rows) 48,307. Completion time (via sqlplus over network) 63 seconds. Second routine (same tables) : 21 seconds! (Oracle 8.1.7 on AIX 4.3 IBM M80 (6 way Risc 6000 4 Gig Ram 1.2 TB IBM Shark attached array) --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: You know, I never use that exception, so I can't remember it correctly. You are correct, of course - thanks for embarrasing me in front of thousands and thousands and thousands (how many Jared??) of people! :) Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 19, 2003 4:10 PM To: Multiple recipients of list ORACLE-L except your too_many_rows exception should be dup_val_on_index... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan [EMAIL PROTECTED] e.ny.us To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: PL/SQL Question:Eliminate duplicate rows .com 09/19/2003 01:54 PM Please respond to ORACLE-L Johann, how about the following. what this does is, using the inner begin/end block, catches when an insert would fail because of the PK failure and ignores the error. This is very quick and dirty - it will work fine if you are not working with a huge amount of data. declare cursor c1 is select col1, col2 from some_table; begin for c1_rec in c1 loop begin insert into new_table(col1, col2) values (c1_rec.col1, c1_rec.col2); exception when too_many_rows then null; end; end loop; end; / If you are talking about lots and lots of data, you could easily query the table you are inserting into, testing for the existence of the value you are attempting to insert. If you find it, skip the insert. Like this: declare rec_count number; cursor c1 is select col1, col2 from some_table; begin for c1_rec in c1 loop begin select count(*) into rec_count from new_table where col1 = c1_rec.col1; -- this assumes that col1 is the pk! if rec_count = 0 then insert into new_table(col1, col2) values (c1_rec.col1, c1_rec.col2); end if; exception when too_many_rows then null; end; end loop; end; / Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 19, 2003 3:05 PM To: Multiple recipients of list ORACLE-L Looking for an a sample cursor routine to load a PK enabled table to eliminate any dupes from the load table. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Thomas 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
PL/SQL Question:Eliminate duplicate rows
Looking for an a sample cursor routine to load a PK enabled table to eliminate any dupes from the load table. __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller 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).
Can contracting rates beat minmum wage soon? (OT)
At least at Joe's down the road I used to make tips? Dice proudly rewarded me with this posting last night Title: SAP Database Administrator Skills: SAP, UNIX, Solaris, Oracle Date: 4-2-2003 Location: Dallas, TX Area code: 214 Tax term: CON_W2 Pay rate: $22.23/HOURLY - $22.23/HOURLY Length: 3 months Position ID: pr75243_rdh14923 Dice ID: cxmnpwr Job description: This position is located in Dallas,Texas. Requirements: Time management, task prioritation, able to work well in a team environment with min. direction, project management, self-starter, excellent written and verbal and interpersonal skills and cross- train fellow team members. Must be a US citizen. Min 3 yrs. exp. in SAP Basis(having been involved in at least one full-cycle SAP Upgrade implementation)UNIX(preferSolaris)/Oracle platform Min. 2 years SAP Security/Authorizations. Strong SAP Installation and support (including UNIX, Oracle and Basis skills to perform). WAS,BW,CRM,EBP,ITS,ESS installation exp. a plus. Multiple SAP upgrade exp. Strong Transport Management Systems skills. SAP Security/Authorizations and all aspects of Basis. MISC bolt-on products(Vertex,iXOS, and JefForm)a plus. Exp. with EMC and EDM a plus. Only qualified applicants please. Job Title: SAP Database Administrator Primary Skills: SAP; UNIX; Solaris; Oracle Job Industry: Advertising/Marketing Vacancies: 1 Job City: Dallas Job Metro Area: Dallas Job State: TX Job Country: US Salary: $22.23/HOURLY to $22.23/HOURLY Hours per Week: 40 Start Date: asap Job Duration: 0 - 3 months Detailed Job Duration: 3 months Degree Type: BS Degree Area: IT Experience Minimum: 3 Years Certificates/Licences: none Candidates responding to this posting must currently possess the eligibility to work in the United States. Examine Your Career Options! With over 250 worldwide offices, Manpower Professional gives you an excellent opportunity to choose your career path and customize your work experience. To help you meet your career goals, we offer a wide range of free IT and business training online through our Global Learning Center. We provide other exceptional benefits to our employees including medical and life insurance, holiday and vacation pay, 401K, and a stock purchase plan (in most locations). Servicing over 95% of the Fortune 500 companies enables us to offer you a full range of placement options including contract, direct and contract-to-hire. Requirements: SAP, UNIX, Solaris, Oracle Travel required: none Telecommute: no -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johan Muller 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).
Sql question : use of SUBSTR/INSTR functions
Help! Anybody have a quick and dirty to parse the 4 octets of a typical IP address into 4 separate values. I will insert these into a table where database checks may verify that the data is in fact a number and also part of a valid ip range (the second thru fourth octets cannot be higher than 255. The source data is very dirty and often fat-fingered, hence the painful solution): e.g.: 127.0.0.1 into 127 (val 1), 0 (val 2), 0 (val 3) and 1 (val 4). I have used various flavors of substr/instr to unravel this, but the varying length of the octets (up to 3 bytes) defeats my rudimentary sql coding skills. I probably have to attack the IP with decode, and any input will be very welcome. Running V 8.1.6. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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: oracle-dba.com domain
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItemitem=2057533249 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark LeithSent: Friday, September 27, 2002 9:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: oracle-dba.com domain anyone have a specific URL for the "lot"? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, MABG, 088130)Sent: 27 September 2002 14:18To: Multiple recipients of list ORACLE-LSubject: RE: oracle-dba.com domain I got the first bid in!!! Matt Adams - GE Appliances - [EMAIL PROTECTED]Their fundamental design flaws are completelyhidden by their superficial design flaws. - Douglas Adams -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 26, 2002 4:11 PMTo: Multiple recipients of list ORACLE-LSubject: oracle-dba.com domain email me at [EMAIL PROTECTED] as I'll be out of office and away from this acct for a few days. joe
9i QUESTIONS: STANDBY DATABASE IMPLEMENTATION
I HAVE read the Data Guard Concepts and Administration manual (repeatedly)and will re-read it several more times. Questions: 1. Any other publications, articles, white papers to follow up on? 2. Has anybody implemented this (9.2 on AIX with IBM Shark storage) and with what level of succes/failure/gotchas. The config that is planned is to put the standby database on a separate AIX platform attached to another Shark storage unit. 3. If there is a canned, step-by-step proc anywhere, would anybody be kind enough to post the same. I vaguely recall this topic from previous posts, but as per usual can't remember much (in fact remember zero is a lot closer - just another senior moment I guess). TIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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).
OT: Where are bill rates going?
I just received the following email from a recruiter for a senior DBA production support 6 month contract position (plus tuning and application enhancement thrown into the mix) in the Dallas/Fort Worth metro area. I was submitted for the contract 2 months ago (at $60/hour W2) and subsequently was begged to reduce that to $55/hour (I reluctantly agreed and are now learning the hard way not to appear desperate or talk money up front, by the looks of it). snip OK, Is there ANY way at all you could reduce your rate to $38.00/hour for the x position? snip Any suggestions for a suitable reply (I have several in mind but would like to remain courteous at this stage). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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).
SQL : where clause to include data for the previous 24 hours
I need a where clause to ACCURATELY (down to the second) calculate the previous 24 hours when a query is run and bump the time by 6 hours (event_date is based on GMT). The default date format has been set to 'S-MM-DD HH24:MI:SS','NLS_CALENDAR=GREGORIAN'. I've tried the following: where event_date (to_date(substr(sysdate,0,22),'/MM/DD HH24:MI:SS') + 6/24) - 1. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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).
UNIX SCRIPT ISSUE - URGENT
I need to extract the first 16 bytes of a filename (AIX 4.3) which consists of an IP address (nnn.nnn.nnn.nnn), and move that to first 16 positions in the file itself, plus adding a pipe (|) sign for a delimiter, and save the IP address as a file name with a .dat extension, before loading the contents into a table. My predecessor concocted the following: #!/usr/bin/ksh FN=$1 IP=`echo $FN|cut -c1-16` sed s/Report by Hosts/$IP| Report by Hosts/ $FN newfile.dat #-- End of file which is great for a single file at a time. Right now I have to perform this surgery on 19 986 files, which is in one place. Using the script above would take me over 20 000 hours. Any way I can grab the files one at the time based on a ls command, and invoke the script, and to end up when the last file has been processed. ALTERNATIVE: Each file contains the IP address which has to move into the first position after a string on line 13 which you guessed it: is called 'IP Address:'. Is their a way vi could be used to achieve the same result? Any input would be appreciated, Johan Muller __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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: Data load options
Hydrocodone Acetaminophen. Pain reliever for DBA's most probably; at present jobsite we get dosage of Prosac when we swipe our access badges. --- Hallas John [EMAIL PROTECTED] wrote: Go on then Lisa, I rise to the challenge For us UK based listers what is Vicodin? John -Original Message- Sent: 25 July 01 15:26 To: Multiple recipients of list ORACLE-L Hi Sean, Others have given you different options. Here's some considerations: 1. SQL Script. * Can be SLOW * May require intermittent commits in your script * Manual and error prone * Must go through SQL engine 2. SQL Loader * Can be very fast (direct - bypassing SQL engine). * Direct path load will invalidate indexes. * You can keep track of rejected records easily (.bad file) * Dependent upon your file format being EXACT, no errors. 3. Import * Requires minimal manual fiddling * Can be very slow - I once imported 150GB and it took ~3 days * Does not seamlessly handle all object types (INtermedia (domain) indexes is one example) * Restarting an import will take a lot longer. If your import fails, be sure and truncate/drop all tables before starting again. * Have the option of not including indexes (INDEXES=N) * Can also reset your storage parms prior to import (export with data=n, edit file [SSSHHH] and enter new storage parms / import, export with data=y, import data with IGNORE=Y) I'm sure others will have additional considerations to share. My choice has always been exp/imp. Lisa Koivu The Vicodin-enhanced DBA Ft. Lauderdale, FL, USA -Original Message- Sent: Wednesday, July 25, 2001 6:16 AM To: Multiple recipients of list ORACLE-L I'm trying to compile a list of options for loading data into an Oracle database on NT platform. What I've come up with so far is: [1] SQL script that performs inserts, updates. [2] SQL Loader utility [3] Import utility Are there others? Anyone care to share experience based opinions on pros and cons of the methods? Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: O'Neill, Sean 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). ** This email and any attachments may be confidential and the subject of legal professional privilege. Any disclosure, use, storage or copying of this email without the consent of the sender is strictly prohibited. Please notify the sender immediately if you are not the intended recipient and then delete the email from your inbox and do not disclose the contents to another person, use, copy or store the information in any medium. ** __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johan Muller 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).