RE: help set nomail
** Welcome to the Oracle-L Mailing List! ** Table Of Contents - 1) Charter for this mailing list 2) Characteristics of this mailing list 3) How to submit a posting to the list 4) How to unsubscribe from the list 5) Commonly used mailing list server commands 6) Contact information 1) Charter for this mailing list The purpose of this mailing list is to offer a forum for discussions about Oracle products, tools and technologies. 2) Characteristics of this mailing list Public or private? Public Moderated? No Archived? Yes Available in DIGEST format? Yes Subscriber list public or private? Private to subscribers only Can you make your address private? Yes Cross-posting to other lists allowed? No 3) How to submit a posting to the list All submissions for this mailing list should be made by sending your E-mail message to the following address: [EMAIL PROTECTED] Once your message is received at fatcity.com, it will be re-distributed to all mailing list subscribers. You may receive replies either privately or as replies to the list itself, depending on the choice of the person responding. 4) How to unsubscribe from the list If you wish to unsubscribe from this mailing list, you should send an E-mail message to the mailing list server, with the following command in the message BODY (a Subject line is not required or needed): UNSUB ORACLE-L Your E-mail message should be addressed to: [EMAIL PROTECTED]-- Note EXACT spelling of 'ListGuru' NOTE: If you only want to *TEMPORARILY* stop receiving postings from this mailing list, you may want to use the SET NOMAIL command as mentioned below. 5) Commonly used mailing list server commands The mailing list server software in use at fatcity.com is ListGuru. ListGuru accepts most commands from all major mailing list servers, including Listserv, ListProc, Majordomo, MailBase and SmartList (among others). All messages to the mailing list server MUST be addressed to only one address, however: [EMAIL PROTECTED]-- Note EXACT spelling of 'ListGuru' Mailing list commands must be included in the message body, not the Subject line. Commands on the Subject line are ignored. Multiple commands can be included in a single message. You may send as many messages as you wish. A short description of the most commonly used commands follows. For a complete list of all commands available, use the HELP command to obtain more detailed information. In all commands below, list refers to a name of a valid mailing list name (for example, ORACLE-L ). Command FormatWhat it does ----- HELP Sends complete ListGuru command information LISTS Sends a list of all available lists at this site UNSUB list Unsubscribes the subscriber from the list SET list NOMAIL Temporarily turns off messages to the subscriber SET list MAIL Resumes mail flow to the subscriber CONFIRM listConfirms a subscription to a particular list WHICH Shows ALL lists that a user is subscribed to SET list DIGEST Turns on DIGEST mode for a list (if available) SET list NODIGEST Returns to normal (single message) mode for a list INDEX list Lists all available archive files for a list END Discontinues further command processing (useful if you have long signature sections). There are more than 50 commands which can be used with ListGuru. The HELP command details all commands and their function. In addition, it specifies which commands from other mailing list server software may be used. Note that the two most common mistakes when using mailing list servers are misspellings of addresses or list names, and posting mailing list server commands to the list itself (a major no-no). When in doubt, ask for HELP. 6) Contact information To reach the administrator of this mailing list, for reasons such as problems with the mailing list or your subscription, send an E-mail message to: [EMAIL PROTECTED] For manual requests that you were not able to accomplish by using the mailing list server, you may send an E-mail message to: [EMAIL PROTECTED] For other problems or questions unrelated to a specific mailing list, (such as bounced messages and the like) send an E-mail message to: [EMAIL PROTECTED] This mailing list is administered by: Bruce A. Bergman ([EMAIL PROTECTED]) Fat City Network Services 7157 Park Village Road San Diego, California 92129-4536 [END] -Original Message- From: Ferenc Mantfeld
Re: help set nomail
Try 'set oracle-l nomail' Jared On Wednesday 05 February 2003 06:52, Ferenc Mantfeld wrote: Hi All my machine has been rebuilt, with my outlook file lost, thus I do not have the mail that describes how to set my account not to receive mail until I say so. I sent a message to [EMAIL PROTECTED] with content : set nomail Oracle-L. This came back as an invalid list. Could someone please tell me how to set my account not to receive any mail, as I am preparing to fly to Dallas for the symposium, and have a few other errands to run before and after. TIA. Regards: Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 12:18 PM Will this work? select b.id , trunc(b.today) tday , b.code , b.value , sum(B.VALUE) over (partition by b.id, trunc(b.today), b.code order by b.id, trunc(b.today), B.CODE range between unbounded preceding and CURRENT ROW) val_total from ( select id, trunc(today) today, code, sum(value) val_total from sum_test group by id, trunc(today), code ) a , sum_test b where a.id=b.id and trunc(b.today)=a.today and a.code=b.code order by 2, 1 / - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 03, 2003 10:09 AM I need some help with some SQL pleeeaasseee I'm trying to do some summay work with some data using some of the Oracle9i Analytic functions. Here is the sample data: SQL select * from sum_test; ID TODAY CODE VALUE -- - -- 1 02-FEB-03 A 100 1 02-FEB-03 A 200 1 02-FEB-03 B50 1 03-FEB-03 A50 1 03-FEB-03 B25 1 05-FEB-03 A 725 1 05-FEB-03 C 125 1 02-FEB-03 A 100 1 03-FEB-03 A 100 2 02-FEB-03 A 100 2 03-FEB-03 A 100 2 04-FEB-03 B 100 and here is how I want the output to look: Note that I want: 1. for the first day I want total by ID, tday (truncated date) and code. I want the daily total in the VAL_TOTAL column 2. For each subsiquent day, I want that days total in val_total ADDED to the previous total. ID TDAY CODE VALUE VAL_TOTAL -- - -- -- 1 02-FEB-03 A 100400 1 02-FEB-03 A 200400 1 02-FEB-03 A 100400 1 02-FEB-03 B50 50 2 02-FEB-03 A 100100 1 03-FEB-03 A50550 1 03-FEB-03 A 100550 1 03-FEB-03 B25 75 2 03-FEB-03 A 100750 2 04-FEB-03 B 100175 1 05-FEB-03 A 725 1275 1 05-FEB-03 C 125125 Here is the query I'm trying: select b.id, trunc(b.today) tday, b.code, b.value, sum(a.val_total) over (partition by b.id, trunc(b.today), b.code order by b.id, trunc(b.today) range between unbounded preceding and unbounded following) val_total from ( select id, trunc(today) today, code, sum(value) val_total from sum_test group by id, trunc(today), code ) a, sum_test b where a.id=b.id and trunc(b.today)=a.today and a.code=b.code order by 2, 1 / Results... ID TDAY CODE VALUE VAL_TOTAL -- - -- -- 1 02-FEB-03 A 100 1200 1 02-FEB-03 A 200 1200 1 02-FEB-03 A 100 1200 1 02-FEB-03 B50 50 2 02-FEB-03 A 100100 1 03-FEB-03 A50300 1 03-FEB-03 A 100300 1 03-FEB-03 B25 25 2 03-FEB-03 A
Re: help set nomail
Use: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, February 05, 2003 9:52 AM Hi All my machine has been rebuilt, with my outlook file lost, thus I do not have the mail that describes how to set my account not to receive mail until I say so. I sent a message to [EMAIL PROTECTED] with content : set nomail Oracle-L. This came back as an invalid list. Could someone please tell me how to set my account not to receive any mail, as I am preparing to fly to Dallas for the symposium, and have a few other errands to run before and after. TIA. Regards: Ferenc Mantfeld Dreaming costs you nothing. Not dreaming costs you everything. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, February 04, 2003 12:18 PM Will this work? select b.id , trunc(b.today) tday , b.code , b.value , sum(B.VALUE) over (partition by b.id, trunc(b.today), b.code order by b.id, trunc(b.today), B.CODE range between unbounded preceding and CURRENT ROW) val_total from ( select id, trunc(today) today, code, sum(value) val_total from sum_test group by id, trunc(today), code ) a , sum_test b where a.id=b.id and trunc(b.today)=a.today and a.code=b.code order by 2, 1 / - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, February 03, 2003 10:09 AM I need some help with some SQL pleeeaasseee I'm trying to do some summay work with some data using some of the Oracle9i Analytic functions. Here is the sample data: SQL select * from sum_test; ID TODAY CODE VALUE -- - -- 1 02-FEB-03 A 100 1 02-FEB-03 A 200 1 02-FEB-03 B50 1 03-FEB-03 A50 1 03-FEB-03 B25 1 05-FEB-03 A 725 1 05-FEB-03 C 125 1 02-FEB-03 A 100 1 03-FEB-03 A 100 2 02-FEB-03 A 100 2 03-FEB-03 A 100 2 04-FEB-03 B 100 and here is how I want the output to look: Note that I want: 1. for the first day I want total by ID, tday (truncated date) and code. I want the daily total in the VAL_TOTAL column 2. For each subsiquent day, I want that days total in val_total ADDED to the previous total. ID TDAY CODE VALUE VAL_TOTAL -- - -- -- 1 02-FEB-03 A 100400 1 02-FEB-03 A 200400 1 02-FEB-03 A 100400 1 02-FEB-03 B50 50 2 02-FEB-03 A 100100 1 03-FEB-03 A50550 1 03-FEB-03 A 100550 1 03-FEB-03 B25 75 2 03-FEB-03 A 100750 2 04-FEB-03 B 100175 1 05-FEB-03 A 725 1275 1 05-FEB-03 C 125125 Here is the query I'm trying: select b.id, trunc(b.today) tday, b.code, b.value, sum(a.val_total) over (partition by b.id, trunc(b.today), b.code order by b.id, trunc(b.today) range between unbounded preceding and unbounded following) val_total from ( select id, trunc(today) today, code, sum(value) val_total from sum_test group by id, trunc(today), code ) a, sum_test b where a.id=b.id and trunc(b.today)=a.today and a.code=b.code order by 2, 1 / Results... ID TDAY CODE VALUE VAL_TOTAL -- - -- -- 1 02-FEB-03 A 100 1200 1 02-FEB-03 A 200 1200 1 02-FEB-03 A 100 1200 1 02-FEB-03 B50 50 2 02-FEB-03 A 100100 1 03-FEB-03 A50300 1 03-FEB-03 A
Re: help set nomail
it should be set oracle-l NOMAIL deb From: Ferenc Mantfeld [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: help set nomail Date: Wed, 05 Feb 2003 06:52:21 -0800 Hi All my machine has been rebuilt, with my outlook file lost, thus I do not have the mail that describes how to set my account not to receive mail until I say so. I sent a message to [EMAIL PROTECTED] with content : set nomail Oracle-L. This came back as an invalid list. Could someone please tell me how to set my account not to receive any mail, as I am preparing to fly to Dallas for the symposium, and have a few other errands to run before and after. _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle Developer 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).