Re: Using ' in Update statement

Get over it and like it was stated earlier, go to usenet.

joe

Rajesh.Rao_at_jpmchase.com wrote:

>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: Joe Testa
  INET: oracle-l_at_oracle-dba.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).