The one thing that I missed in my reply were the ;-) signs. I say "hear hear" to Mladen and Jared. My attempt at sarcasm fell flat like the Elle show. I was going thru my latest acquistion of Effective Oracle by Design by Tom Kyte, and was unduly influenced by the goodies he spoon fed me ;-).
Regards Raj Mogens Nørgaard To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> <[EMAIL PROTECTED] cc: .dk> Subject: Re: Using ' in Update statement Sent by: [EMAIL PROTECTED] ity.com 10/12/2003 01:04 AM Please respond to ORACLE-L Tom has a small staff to help him answer the questions. I find the comment from Raj to be less than fair and intelligent - or we all misunderstood what he meant (including me). Mogens [EMAIL PROTECTED] wrote: > > I don't know whether Tom does all of the asktom site on his > own time, but I doubt it. > > His website doesn't do much to hurt sales of his book, so he > also has a greater financial interest. Money is a good motivator. > > Tom is also a VP at Oracle, and does some pretty good PR > for his employer via his web site. I imagine he is able to spend > more time on the job answering questions than what would be > practical for most people on this list. > > Many of us answer questions here for a variety of reasons. > > Here's my list of reasons: > > * it's an interesting topic > * it's a topic that covers something I need to do > * it's a topic that is not easily answered from the manuals, and > the person posing the question could use some help. > * it's a topic regarding something I have already learned to solve > * I will learn something by participating > > The last one covers many more threads than I could possibly > be involved in, so I try to limit it to those that will be of use to > me somehow. > > Jared > > > > > > [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > > 10/10/2003 12:54 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject: RE: Using ' in Update statement > > > > > > You guys are mean !!!!!! Tom Kyte would have given me 10 ways of writing > the statement, would have traced every one of them under different > versions > and on different platforms, pointed out the number of logical reads, > elapsed time, et all, and told me which one is better. > > Regards > Raj > > > > > > > [EMAIL PROTECTED] > > disys.com To: Multiple recipients of > list ORACLE-L <[EMAIL PROTECTED]> > Sent by: cc: > > [EMAIL PROTECTED] Subject: RE: Using ' in > Update statement > ity.com > > > > > > 10/10/2003 > > 01:54 PM > > Please respond > > to ORACLE-L > > > > > > > > > > > What he said. > > > > Mladen Gogala > <[EMAIL PROTECTED]> To: Multiple recipients of > Sent by: list ORACLE-L <[EMAIL PROTECTED]> > [EMAIL PROTECTED] cc: > Subject: RE: Using ' in > Update statement > 10/10/2003 09:14 AM > Please respond to ORACLE-L > > > > > > > Here is the reason for that: this list would not be useful to > me if it was devoted to answering beginner's questions. List > would get flooded, I would stop reading as would many other > people. It has already happened. This list is a very valuable resource > to me and I would hate to lose it to the people asking things > like how to set prompt in sqlplus. Usenet groups are the proper place > for that. > People can learn the basics by reading books and manuals and I don't > have much sympathy for the people who don't want to read but post their > questions to this list instead. I am trying to help when I think that > help is needed, but I am also trying to discourage trivial questions > asked for 10th time. > Don't get me wrong, I'm not apologizing for my actions, I'm just > explaining them. This is my last reply in this thread because I don't > intend to create a flame war on this list. I'll surround myself with > an SEP field and vanish from sight. > the basic stuff by reading manuals > On Fri, 2003-10-10 at 11:39, [EMAIL PROTECTED] wrote: > > > > > > Ahhh!!! there is no "elite" and the question was trivial. The great and > > powerful has spoken, perhaps all questions should be filtered > > your way for classification. I can assure nothing on this forum is > worthy > > of becoming "Testy", merely trying to provide a solution for > > someone who needed help and of course one must stand their ground when > > necessary. > > > > > > > > > > Mladen Gogala > > > <[EMAIL PROTECTED] To: Multiple > recipients of list ORACLE-L <[EMAIL PROTECTED]> > > ng.com> cc: > > > Sent by: Subject: RE: Using ' in > Update statement > > [EMAIL PROTECTED] > > > .com > > > > > > > > > 10/10/2003 10:19 > > > AM > > > Please respond to > > > ORACLE-L > > > > > > > > > > > > > > > > > There is no "elite" here, but this was a trivial question which > > I answered by listing manuals in which the answer could be found. > > I was asked for clarification of my reply, so I provided the > > clarification. No need to get testy about it. > > > > On Fri, 2003-10-10 at 08:54, Mercadante, Thomas F wrote: > > > Naaa. He's an equal opportunity ball-buster. > > > > > > > > > -----Original Message----- > > > Sent: Thursday, October 09, 2003 5:54 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > > > > > > > > > > > > > Hamid started his question > > > How can I user comma " ' " in my update statement? > > > > > > I am merely correcting his mistake and then providing a solution. > > > Wow, what a concept on a Oracle Listserv site design for that very > > purpose. > > > Just curious, Would you have answered in the same way if it had been > > asked > > > by one of > > > the "elite"? > > > > > > > > > > > > > > > > > > Mladen Gogala > > > > > > <[EMAIL PROTECTED] To: Multiple > > recipients > > > of list ORACLE-L <[EMAIL PROTECTED]> > > > ng.com> cc: > > > > > > Sent by: Subject: Re: Using > ' in > > > Update statement > > > [EMAIL PROTECTED] > > > > > > .com > > > > > > > > > > > > > > > > > > 10/09/2003 05:09 > > > > > > PM > > > > > > Please respond to > > > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > I didn't mean quote, I meant "RTFM". > > > On Thu, 2003-10-09 at 16:34, [EMAIL PROTECTED] wrote: > > > > > > > > > > > > I assume you mean quote > > > > > > > > update tablea set fielda =' james'ste Camp 'first,'sec' ' > > > > > > > > update tablea set fielda =' james''ste Camp ''first,''sec'' '; > > > > > > > > Just use 2 single quotes > > > > > > > > > > > > > > > > > > > Mladen Gogala > > > > > > > <[EMAIL PROTECTED] To: Multiple > > > recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > > ng.com> cc: > > > > > > > Sent by: Subject: Re: Using ' > in > > > Update statement > > > > [EMAIL PROTECTED] > > > > > > > .com > > > > > > > > > > > > > > > > > > > > > 10/09/2003 02:29 > > > > > > > PM > > > > > > > Please respond to > > > > > > > ORACLE-L > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > It's in the documentation. Start with the concepts manual, then > > SQL*Plus > > > > manual and SQL reference. I'm sure that you'll run across the answer > > > > because that's where I have found the answer to the very same > question. > > > > > > > > On Thu, 2003-10-09 at 13:59, Hamid Alavi wrote: > > > > > List, > > > > > > > > > > How can I user comma " ' " in my update statement? > > > > > > > > > > update tablea set fielda =' james'ste Camp 'first,'sec' ' > > > > > > > > > > > > > > > Thanks, > > > > > > > > > > Hamid Alavi > > > > > > > > > > Office : 818-737-0526 > > > > > Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).