RE: function help ???
Andrea, Here is a version of the function you asked for, IT IS NOT WELL TESTED, should give you something to go on. Scott Crabtree FUNCTION calc_avg (student_id IN NUMBER) RETURN NUMBER AS CURSOR student_c IS SELECT snum || call# class, credit, RTRIM (grade) grade, credit * DECODE (RTRIM (grade), 'A', 4, 'B', 3, 'C', 2, 'D', 1, 'F', 0) weight FROM enrollment WHERE student# = student_id ORDER BY grade DESC; last_classNUMBER := 0; last_weight NUMBER := 0; last_credit NUMBER := 0; last_gradeVARCHAR2 (1):= 'Z'; cum_weightNUMBER := 0; cum_credits NUMBER := 0; gpa NUMBER (5, 2) := 0.00; student_rec student_c%ROWTYPE; BEGIN OPEN student_c; FETCH student_c INTO student_rec; WHILE student_c%FOUND LOOP --DBMS_OUTPUT.PUT_LINE(to_char(student_rec.weight) || ' ' || nvl(to_char(student_rec.credit),'NULL')); IF last_class = student_rec.class --Repeat_delete AND last_grade IN ('F', 'D') AND student_rec.grade IN ('A', 'B', 'C') THEN cum_weight := cum_weight - last_weight + student_rec.weight; cum_credits := cum_credits - last_credit + student_rec.credit; --DBMS_OUTPUT.PUT_LINE(to_char(student_rec.weight) || to_char(student_rec.credit)); ELSE cum_weight := cum_weight + student_rec.weight; cum_credits := cum_credits + student_rec.credit; END IF; last_class := student_rec.class; last_weight := student_rec.weight; last_credit := student_rec.credit; last_grade := student_rec.grade; FETCH student_c INTO student_rec; END LOOP; CLOSE student_c; gpa := cum_weight / cum_credits; -- DBMS_OUTPUT.PUT_LINE('Cum Weight:' || to_char(cum_weight) || ' Cum Credits:' || to_char(cum_credits)); RETURN gpa; END; -- Function CALC_AVG Call it for every distinct student# using: select calc_avg(student),a.student from (select distinct STUDENT# student from enrollment) a -Original Message- Sent: Monday, December 03, 2001 12:12 PM To: Multiple recipients of list ORACLE-L Hi, Could any one show me how to write the following function? Thank you very, very much! The GPA Function 1. A GPA is calculated in the following fashion: Assume a student receives an A on a 3-credit_hour course and a D on a 2-credit-hour course. His grade is (4*3+1*2)/(3+2)=2.8. 2.Repeat_delete Policy: A student may repeat a course as many times as he wants. However, if the first grade he receives on this course is a D or F, then the second grade will automatically replaces the first grade, and the first enrollment will not go into his GPA calculation. Under any other circumstances, his grades will be considered as a regular grade and be taken into consideration for GPA. create table Enrollment( Student# NUMBER (7), SNUM NUMBER (5), Call# NUMBER (7), Semester char (8), GRADE char (3), Credit number, Withdraw_Date Date); SNUM + Call# represents one class. Insert into Enrollment values('58001','111','70070','Sp2000','F',3, null); Insert into Enrollment values('58001','111','70070','Fa2000','B',3, null); Insert into Enrollment values('58003','222','70070','Sp2000','A',2, null); Insert into Enrollment values('58004','333','80025','Fa2000','A',2, null); Insert into Enrollment values('58005','222','80025','Fa2000','C',3, null); __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrea Oracle 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: Scott Crabtree 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
RE: Lots and lots of redo logs
!! Please do not post Off Topic to this List !! Christopher R. Spence said: Disks are cheap and if you store things on the outer platters performance will suffer? Chris, I'm not sure what you mean here. The concept of Variable Transfer Rate covers this. Stealing a quote from: Optimal Storage Configuration Made Easy, By Juan Loaiza, Oracle Corporation The transfer rate for a disk drive is not the same for all portions of a disk. The outer sectors of a disk drive move by the disk head faster than the inner sections leading to a faster transfer rate for the outer sectors. This is simply because of the circular shape of a disk drive. Scott -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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:Deleting Files in NT
Raj, If you have the resource kit installed you can use forfiles. forfiles -pp:\zipfiles\hot\ -s -m*.* -d-20052001 -cCMD /C DEL /Q @FILE; Forfiles is helpful for ton's of DB Maintenance, you can pipe the results to any dos command you want. We use a statement like the one below in our spool_Hot_Backup script to prune the backup directories before we put all the tablespaces in hot backup mode and ocopy them, We then compress them in a staging directory using pacomp and move them to a drive so that last nights datafiles are around for a speedy recovery (If Necessary). /* Clean Out ZIP Files older than two days: Uses Forfiles Resource Kit*/ select to_char(sysdate-2,'ddmm') into datestr from dual; dbms_output.put_line('host forfiles -p'||backupdir||' -s -m*.* -d-'||datestr|| ' -c'||chr(34)||'CMD /C DEL /Q @FILE'||chr(34)||';'); HTH, (hazardous terminal halitosis) Scott Crabtree -Original Message- Sent: Wednesday, May 23, 2001 11:45 AM To: Multiple recipients of list ORACLE-L DBAs How do I delete files from NT which are older than a week. I need this to organise my backup dump files. Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Scott Crabtree 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).
NT-RE: Database Down-Dump and Mail Event Logs
Title: RE: Database Down Here some help from Paul Drake on NT diagnostics tools you can put in place to send yourself event logs. Sample code to email event logs C:\blat -install mail.mydomain.com [EMAIL PROTECTED] Failed to open registry key for Blat profile , using default. SMTP server set to mail.mydomain.com on port 25 with user [EMAIL PROTECTED], retry 1 time(s) C:\dumpel -F my_app_log.txt -L Application -c Dump successfully completed. C:\blat C:\my_app_log.txt -to [EMAIL PROTECTED] Sending C:\my_app_log.txt to [EMAIL PROTECTED] Login name is [EMAIL PROTECTED] received email in the recipient email account dumpel.exe - NT command to dump the event logs to file - NT Resource Kit. The book Windows Admin Scripting describes this on pg 279. ISBN 1-57610-881-3 D:\dumpel /? DumpEl usage: -e nn Filters for event id nn (up to 10 may be specified) -f filename Output filename (default stdout) -l name Dumps the specified log (system, application, security) -b Dumps a backup file (use -l to specify file name) -m name Filters for events logged by name -r Filters out events logged by name (must use -m too) -s servername Remote to servername -t Use tab to separate strings (default is space) -c Use comma to separate fields -ns Do not output strings -format fmt Specify output format. Default format is dtTCISucs where t - time d - date T - event type C - event category I - event ID S - event source u - user c - computer s - strings blat.exe - NT freeware utility for sending mail with attachments The book Windows Admin Scripting includes a routine to generate a spreadsheet of Backup Exec jobs using the Windows Scripting Host shell - but I haven't used WSH yet. hth, Paul -Original Message-From: Burton, Laura L. [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 5:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Down Amen Sister!! I am afraid you all will have to be my virtual party people, since I am the only one around here that got excited when the recovery was done...so have a great time!! Laura :) -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 23, 2001 3:12 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Database Down -Original Message- From: Burton, Laura L. [mailto:[EMAIL PROTECTED]] My database is up and with no data loss!!! Congratulations! I've done the exercises in Rama Velpuri's book, but when it comes to a live situation, it's a little more scary. So where's the party?
RE: Problem in fetching Table Info
Manoj, Nothing helps your sql skills like traversing the data dictionary, put on your hip waders get out your TUSC posters, a magnifying glass, a bottle of scotch and dive in. Here is one way, by no means the best or the only. SELECT A.column_name, A.data_type, DECODE(A.data_type,'NUMBER', DECODE(A.data_precision,NULL,A.data_length,A.data_precision), A.data_length) as Length, A.nullable, min(con_p) || min(con_c) || min(con_r), column_id FROM user_tab_columns A, (select B.constraint_name con_name, DECODE(B.constraint_type,'P','P',null) con_p, DECODE(B.constraint_type,'C','C',null) con_c, DECODE(B.constraint_type,'R','R',null) con_r, B.table_name tname, C.Column_name col_name FROMuser_constraints B, user_cons_columns C WHERE B.constraint_name = C.constraint_name AND B.Table_name = 'AG_PRODUCT' ) my_all_cons WHERE A.column_name= my_all_cons.col_name (+) AND A.table_name = my_all_cons.tname (+) AND A.table_name = 'AG_PRODUCT' GROUP BY A.column_name, A.data_type, DECODE(A.data_type,'NUMBER', DECODE(A.data_precision,NULL,A.data_length,A.data_precision), A.data_length), A.nullable, column_id ORDER BY COLUMN_ID If you like recursive SQL, take the table_name out of the inline view and join my_all_cons.tname = A.table_name in the outer. Great for watching recursive sql for those with Unabridged Data Dictionaries HTH, Scott Crabtree -Original Message- Sent: Monday, May 14, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I am facing some problem while fetching data from oracle. I have to fetch all info like column_name,data_type,data_length,Nullable and primary key for particular table. For that i had prepared 2 quiries like: select A.column_name,A.data_type, 2 decode(A.data_type,'NUMBER', 3 decode(A.data_precision,NULL,A.data_length,A.data_precision), 4 A.data_length) as Length, 5 A.nullable from 6* user_tab_columns A where table_name = 'TEST' Which gives me info as : COLUMN_NAMEDATA_TYPE LENGTH N -- - -- - FLD1 NUMBER 5 N FLD2 NUMBER 3 N FLD3 VARCHAR2 10 N FLD4 VARCHAR2 30 Y FLD5 VARCHAR2 100 Y FLD6 VARCHAR2 50 Y FLD7 NUMBER22 Y Which is fine,but along with this i want info like which fields are pkey for which i have one more query: select C.column_name,B.constraint_type from user_constraints B,user_cons_columns C where B.constraint_name=C.constraint_name and B.table_name='TEST' which gives me info as to which are pkeys in table, But when i join these 2 quiries i get only 3 fields which are in primary key like FLD1,FLD2,FLD3 COLUMN_NAMEDATA_TYPE LENGTH N C -- - -- - - FLD1 NUMBER 5 N P FLD2 NUMBER 3 N P FLD3 VARCHAR2 10 N P whereas i want all other fields also along with that. Output should be as : COLUMN_NAMEDATA_TYPE LENGTH N -- - -- - FLD1 NUMBER 5 N P FLD2 NUMBER 3 N P FLD3 VARCHAR2 10 N P FLD4 VARCHAR2 30 Y FLD5 VARCHAR2 100 Y FLD6 VARCHAR2 50 Y FLD7 NUMBER22 Y I tried following query for this: 1 select A.column_name,A.data_type, 2 decode(A.data_type,'NUMBER', 3 decode(A.data_precision,NULL,A.data_length,A.data_precision), 4 A.data_length) as Length, 5 A.nullable,B.constraint_type from 6 user_tab_columns A, 7 user_constraints B, 8 user_cons_columns C 9 where 10 B.constraint_name=C.constraint_name and 11 A.column_name=C.column_name(+) and 12 A.table_name=B.table_name and 13* A.table_name = 'GEMS Could any one Help me in this?? TIA Manoj. __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Soman Manoj 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
COLLECTION ITERATOR PICKLER FETCH
Sometimes I really love the developers at Oracle.. This should be good fodder for Eric P. Does anyone have experience with infamous pickler Fetch which shows up in this explain plan the select is on index organized nested tables (Nested objects)? It's obvious that someone in internals has a good sense of humor. I guess this is the way Oracle dereferences the embedded collections? SELECT STATEMENT SORT GROUP BY NESTED LOOPS NESTED LOOPS NESTED LOOPS NESTED LOOPS ` BLAH BLAH BLAH COLLECTION ITERATOR PICKLER FETCH VIEW AD_AGG_DATA_MASTER UNION-ALL PARTITION FILTER TABLE ACCESS BY INDEX ROWID AD_23 INDEX RANGE SCAN AD_23_IDX_1 FILTER TABLE ACCESS BY INDEX ROWID AD_24 INDEX RANGE SCAN AD_24_IDX_1 FILTER TABLE ACCESS BY INDEX ROWID AD_25 INDEX RANGE SCAN AD_25_IDX_1 Scott Crabtree Veritas Certified Survivor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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).
Home Grown Partitioning
To ORACLE-L tuning Gurus: Running Oracle 8.1.7.0.2 on W2K I have a query involving a partition view, but I can't seem to get it to filter partitions. Even though I join it to a table with rows that join only to one of the view's underlying tables, it persists in performing the union-all and then hash-joining the result. But this is very inefficient; when I join the query to the single underlying table, it runs ten times faster. Other queries using this partition view properly filter partitions, but for some reason, we have a query which is refusing to behave. I have tried the USE_NL hint (to prevent the hash-join) and the INDEX hint, but neither have worked. We have partition_view_enabled = TRUE in the ini file. Any Suggestions Would be greatly appreciated. (We can't run Oracle Enterprise Edition and therefore can not use Oracle Partitioning) Thanks, and Sorry for the long post (I didn't include the query because it make this post even longer, if anyone would like to see it I will email it offline) Scott Crabtree Professional Software Systems -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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: Generate random number
Helmut, Make sure you have run dbmsrand.sql as sys. This installs the dbms_random package First you seed the random package. exec dbms_random.seed(1) Then select dbms_random.random from dual; RANDOM -- 723648616 exec DBMS_RANDOM.TERMINATE; RTFM Reference (Oracle8i Supplied PL/SQL Packages Reference) HTH, Scott Crabtree -Original Message- Sent: Saturday, March 31, 2001 7:00 PM To: Multiple recipients of list ORACLE-L Hi! Is there a function in Oracle that returns a random number, when it's called? e.g. rnd (1,1000) should return a random number between 1 and 1000. This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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: hash_area_size
Chuck, The closest I could come to a definate answer on this one was in doc 58906.996where the Tech skirted the issue you asked about. Quote metalink user "5. Does every client connection/session get hash_area_size allocated or only those that execute a hash join. tech I believe that hash_area_size is allocated for a process that executes a hash join." Great, but does it stay allocated after? From playing around with it, I set my hash area size up to 1600 and no memory was allocated until Iexecuteda query that hash joined. Once it was allocated it wasn't released until the session ended. Also, I believe the memory is not shared. (When I had 4 user processes executing the queries my machine was down 64MB) tech The memory for hash_area_size is allocated from the User Global Area (UGA) of a user process. For dedicated server connection, this is part of process memory (PGA). For multi-threaded server, the UGA is allocated from either the Shared Pool or the Large Pool, if the Large Pool is configured (recommended). Regards, Scott Crabtree -Original Message-From: Chuck Hamilton [mailto:[EMAIL PROTECTED]]Sent: Thursday, March 29, 2001 4:01 PMTo: Multiple recipients of list ORACLE-LSubject: hash_area_size Is the hash area memory released back to the o/s when the hash join operation is finished or does it remain allocated as long as the session is still connected?
RE: Update two columns in a single update statement
Helmut, Try update tablename set column1 = value1, column2 = value2 where rownum 1 Scott Crabtree -Original Message- Sent: Thursday, March 29, 2001 6:51 PM To: Multiple recipients of list ORACLE-L Hi! Can I update two columns in a single update statement? What is the exact syntax for this... update tablename set col1,col2 = 45,33 Just like in an insert statement, you would go insert into (col1,col2) values (45,33) This is 8.1.6 on Win2k. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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: 8.1.7 Patches
Todd, Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the latest patch AFAIK. Scott Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. -Original Message- Sent: Wednesday, March 21, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Metalink shows that there is no patch available for 8.1.7 on NT. Is that correct or am I needing a vacation? I hate to be cynical, but an Oracle product with no patch for 3 months? This I find hard to believe. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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: 8.1.7 Patches
Todd, Sorry, I spoke too soon, we are patching to 8.1.7.0.2 on NT MetaBlurb Quote about 8.1.7.1 "No date on Windows NT, it is still listed as delayed HP-UX 3/23/01 AIX 3/23/01 Compaq 3/16/01 " Sorry about the disinformation. Scott -Original Message- Sent: Wednesday, March 21, 2001 4:57 PM To: '[EMAIL PROTECTED]' Todd, Your skepticism is healthy, but Metalink is not:-) 8.1.7.1 is the latest patch AFAIK. Scott Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. Support Status ~~ Release Comments 8.1.7.0 Oracle8i Release 3 Base Release See [NOTE:120801.1] if installing on Unix. 8.1.7.1 Current patch set - see [NOTE:120613.1] for contents. -Original Message- Sent: Wednesday, March 21, 2001 4:30 PM To: Multiple recipients of list ORACLE-L Metalink shows that there is no patch available for 8.1.7 on NT. Is that correct or am I needing a vacation? I hate to be cynical, but an Oracle product with no patch for 3 months? This I find hard to believe. Todd Carlson Oracle 8 8i Certified DBA Bunge Corporation -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Crabtree 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).