Re: Using ' in Update statement

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

Jared.Still_at_radisys.com 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
>
>
>
>
>
> *Rajesh.Rao_at_jpmchase.com*
> Sent by: ml-errors_at_fatcity.com
>
> 10/10/2003 12:54 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> 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
>
>
>
>
>
>
> Jared.Still_at_ra
>
> disys.com To: Multiple recipients of
> list ORACLE-L <ORACLE-L_at_fatcity.com>
> Sent by: cc:
>
> ml-errors_at_fatc Subject: RE: Using ' in
> Update statement
> ity.com
>
>
>
>
>
> 10/10/2003
>
> 01:54 PM
>
> Please respond
>
> to ORACLE-L
>
>
>
>
>
>
>
>
>
>
> What he said.
>
>
>
> Mladen Gogala
> <mladen_at_wangtrading.com> To: Multiple recipients of
> Sent by: list ORACLE-L <ORACLE-L_at_fatcity.com>
> ml-errors_at_fatcity.com 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, Rick_Cale_at_teamhealth.com 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
>
> > <mladen_at_wangtradi To: Multiple
> recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > ng.com> cc:
>
> > Sent by: Subject: RE: Using ' in
> Update statement
> > ml-errors_at_fatcity
>
> > .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
> > >
> > > <mladen_at_wangtradi To: Multiple
> > recipients
> > > of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > ng.com> cc:
> > >
> > > Sent by: Subject: Re: Using
> ' in
> > > Update statement
> > > ml-errors_at_fatcity
> > >
> > > .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, Rick_Cale_at_teamhealth.com 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
> > >
> > > > <mladen_at_wangtradi To: Multiple
> > > recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > > > ng.com> cc:
> > >
> > > > Sent by: Subject: Re: Using '
> in
> > > Update statement
> > > > ml-errors_at_fatcity
> > >
> > > > .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: Rajesh.Rao_at_jpmchase.com
>
> 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: ListGuru_at_fatcity.com (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: =?ISO-8859-1?Q?Mogens_N=F8rgaard?=
  INET: mln_at_miracleas.dk

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: ListGuru_at_fatcity.com (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).