RE: TUSC and Kevin Loney
At TUSC, there are more authors than Rich Niemiec, Mike Ault, and Kevin Loney. There are also Brad Brown, Joe Trezzo, Tony Catalano. -Ari On Mon, 4 Jun 2001, John Kanagaraj wrote: > > > >And tusc has a partnership w/ quest. Weird. tusc does a lot of their > >recruiting at Barnes and Noble. I think Steve Adams is on the hit list. > > > > As far as I am aware, some of the very respectable 'big guns' at Quest are: > Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning' > fame), Steven Feuerstein (of PL/SQL fame), > > And now, as TUSC are: Rich Niemiec (President IOUG-A?), Kevin Loney, Mike > Ault, ... > > So is this coalition a viable alternative to the all-knowing Oracle Support > Services? > > John Kanagaraj > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: John Kanagaraj > 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: Ari D Kaplan 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: Source code of objects
It is DBA_SOURCE / ALL_SOURCE / USER_SOURCE. For example: SELECT distinct OWNER, NAME FROM DBA_SOURCE; lists all source-code related objects in the database (functions, packages, procedures, types). SELECT TEXT FROM DBA_SOURCE WHERE OWNER = 'SYS' and NAME = 'UTL_FILE' ORDER BY LINE; will give the source code for an object. -Ari Kaplan <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> <-> For 400+ Oracle tips, visit: <-> <-><-> <-> www.arikaplan.com <-> <-><-> <-> email: [EMAIL PROTECTED] <-> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> On Mon, 7 May 2001, Brijesh Lal wrote: > Hi > I don't remember the view in which source code is > stored for example source code of procedures, > functions or even database link. Can anyone tell me in > which view is the source code stored > > Regards > Brijesh > > __ > 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: Brijesh Lal > 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: Ari D Kaplan 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: Meeting at IOUG -- Per Ari's suggestion
I have confirmed our Oracle list reservation at "Juan and Only's" at the Swan / Dolphin hotel. Monday, April 30th at 8:00pm The table is under "Ari Kaplan" and there will be plenty of seating. Also, there is a bar with what I understand are amazing margaritas. Having it Monday would give everyone a chance to meet and make new friends just as the conference is beginning. If you want to RSVP to "[EMAIL PROTECTED]" I can see if I need to add another table. The current one should be good for 16 (plus more room at the bar). Looking forward to seeing new and old friends. -Ari Kaplan __ On Thu, 19 Apr 2001, Eric D. Pierce wrote: > just look for all the people scratchin' and spittin' > > On 19 Apr 2001, at 13:21, Molina, Gerardo wrote: > > > > Maybe ORACLE-Listers can congregate at a designated table or > > tables? > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Eric D. Pierce > 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: Ari D Kaplan 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: Meeting at IOUG
Glad to see so many people wanting to get together. I would like to propose a time and place... Tuesday night is the "big bash", and Wednesday night is a "Pleasure Island" event. There is a Monday night welcome reception in the exhibit hall until 7:45. So, I think the best time is Monday at 8pm, somewhere in the Swan and Dolphin complex (not knowing the Orlando area personally). http://www.swandolphin.com/restaur.htm lists the 15 restaurants (with 3D views). My vote is Juan & Only's - "A perfect place to enjoy moderately priced southwestern cuisine. Stop by the bar for the best margaritas in town! Open for dinner." for its bar and not super-loud setting so we can talk. - Ari Kaplan On Tue, 17 Apr 2001, Stephen Andert wrote: > I'll be there and would like to meet as many of you as possible. If anyone who >knows the ropes can suggest a time/place, that would be great. As this is my first >IOUG event, I don't have any ideas on where/when, so it's up to all you "veterans". > > Keep this thread going. > > > Stephen Andert > > > >>> [EMAIL PROTECTED] 04/16 8:15 PM >>> > don't know that any meeting has been scheduled, I do know that a number of > the members of the list are presenting and I intend to be at most of those > sessions :) > > on the other hand, Gaja's sessions tend to draw EVERYONE so you can be sure > of meeting others on the list there > > > >From: "Murali Vallath" <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Meeting at IOUG > >Date: Mon, 16 Apr 2001 18:30:43 -0800 > > > > > >Are any of the floks from the list meeting during the IOUG-A live in > >Florida. > > > >I am attending and would like to join the meeting. > > > >Murali Vallath > >_ > >Get your FREE download of MSN Explorer at http://explorer.msn.com > > > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Murali Vallath > > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.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). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Stephen Andert > 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: Ari D Kaplan 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: report.txt
Dave, There is a great site to analyze the report.txt: www.oraperf.com For those on this list that have used oraperf before, there is now a primary and secondary site, so it *should* be operational. Enjoy, _ Ari Kaplan PocketDBA Systems www.pocketdba.com Wireless Database Management Now(tm) e| [EMAIL PROTECTED] _ On Thu, 22 Mar 2001, David Turner wrote: > Anyone have a shell script that can read a report.txt and list some of the > items that need to be looked at. I'm lazy and don't want to start from > scratch. > > Thanks, Dave Turner > -- > > And you thought James Bond's watch was cool... http://www.tellme.com > Call 1-800-555-TELL for stocks, sports, news...& much more! > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > 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: Ari D Kaplan 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: Offtopic: Canada and America
I once did a year assignment in Syracuse. Luckily I did not get shot ;) Seriously, it is a beautiful town. Got exposed to some American culture. WWF, National Bowling Championship, Golden Glove Boxing Championship, and the like. Plus Skaneateles recently won the US "Olympics of the Mind" competition. Well, I happily in downtown Chicago now. -Ari On Fri, 16 Mar 2001, Kevin Kostyszyn wrote: > No way, you'd probably get shot. > > -Original Message- > Beilstein > Sent: Friday, March 16, 2001 4:23 PM > To: Multiple recipients of list ORACLE-L > > > I'm from Syracuse myself and the city is a nice place. Everything you want > without the dog eat dog attitude of a major city like New York. Most of the > time people even say hello to each other on the streets, try doing that in > New York 8-) > > >>> [EMAIL PROTECTED] 03/16/01 01:06PM >>> > Ari D Kaplan wrote: > > > > Upstate NY is great - Buffalo, Niagara Falls, Syracuse, and the best place > > in the world: COOPERSTOWN. > > > > (For those not familiar with baseball, this is the Baseball Hall of Fame). > > > > -Ari > > and the Kodak museum in rochester, and the eversion museum [housed in an > award wining building by I.M.Pei] in syracuse, and the finger lakse > wineries and > > damn i've lived here too long.;-) > > -- > > Bill Thater Certifiable ORACLE DBA > Telergy, Inc [EMAIL PROTECTED] > > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work! > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > 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: William Beilstein > 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: Kevin Kostyszyn > 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: Ari D Kaplan 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: Offtopic: Canada and America
;the above comment ) > > > >Before you comment on cultures you have not experienced it would be > >advisable > >to at least visit there as a tourist. If you work there for a while you > >may even > >realize that what is "common knowledge" is wrong. After spending six > >weeks in > >Moscow, 2 years ago, I do not believe anything I read in the media (it > >is both > >better and worse than it is reported). > > > >And yes, there is a separate Canadian culture. (Part of which is > >wondering if > >we have a separate culture.) > > > > > > > > > >Sigh.., and the day after I promised Jared I would behave. > > > >Dave > >-- > >Dave Morgan > >Senior Database Administrator > >Internet Barter Inc. > >www.bartertrust.com > >408-910-4183 > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Dave Morgan > > 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: Hand, Michael T > > 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). > > > > > >The information contained in this communication is > >confidential, is intended only for the use of the recipient > >named above, and may be legally privileged. If the reader > >of this message is not the intended recipient, you are > >hereby notified that any dissemination, distribution or > >copying of this communication is strictly prohibited. > >If you have received this communication in error, please > >re-send this communication to the sender and delete the > >original message or any copy of it from your computer > >system. > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: lerobe - Lee Robertson > > 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). > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari D Kaplan 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: Oracle Author in People Magazine
Jared, Looks young ;) For anyone wondering, his picture is on http://www.dba-oracle.com/articles.htm Is he on this list? -Ari _ On Sat, 3 Mar 2001 [EMAIL PROTECTED] wrote: > On Wed, 28 Feb 2001, Ari D Kaplan wrote: > > > > > Now we know from the article that he is 44 years old ;) > > > > Take care, > > > > Ari, > > If we go by the picture he frequently uses, I would > say he's actually only about 35. ;) > > Jared > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari D Kaplan 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).
Oracle Author in People Magazine
Has anyone seen the recent February 26th issue of People Magazine? There was a three-page article on Don Burleson's side-activity: his seeing-eye horses. Very cool ; they even wear shoes. If you do not know Don, he authored the "High-performance Oracle8 Tuning" book. Now we know from the article that he is 44 years old ;) Take care, -Ari Kaplan <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> <-> For 400+ Oracle tips, visit: <-> <-><-> <-> www.arikaplan.com <-> <-><-> <-> email: [EMAIL PROTECTED] <-> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ari D Kaplan 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: Ascii code of tab?
It is CHR(9): SELECT column_1||chr(9)||column_2 FROM table_name; Best regards, -Ari Kaplan Independent Oracle DBA Consultant Founder/CEO, PocketDBA Systems -- Wireless Database Management Now www.pocketdba.com <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> <-> For 400+ Oracle tips, visit: <-> <-><-> <-> www.arikaplan.com <-> <-><-> <-> email: [EMAIL PROTECTED] <-> <-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-> On Mon, 5 Feb 2001, Viktor wrote: > What is ascii code of TAB? > > Thanks > > __ > Get personalized email addresses from Yahoo! Mail - only $35 > a year! http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Viktor > 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: Ari D Kaplan 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).
