Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h9AMAM201938 for ; Fri, 10 Oct 2003 17:10:22 -0500 X-ClientAddr: 66.27.56.210 Received: from ns3.fatcity.com (rrcs-west-66-27-56-210.biz.rr.com [66.27.56.210]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h9AMAKc01932 for ; Fri, 10 Oct 2003 17:10:21 -0500 Received: from ns3.fatcity.com (localhost.localdomain [127.0.0.1]) by ns3.fatcity.com (8.12.8/8.12.8) with ESMTP id h9AJNQgl030041 for ; Fri, 10 Oct 2003 12:26:44 -0700 Received: (from root@localhost) by ns3.fatcity.com (8.12.8/8.12.5/Submit) id h9AJFMVw028151 for oracle-l@orafaq.net; Fri, 10 Oct 2003 12:15:23 -0700 Received: by fatcity.com (05-Jun-2003/v1.0g-b73/bab) via fatcity.com id 005D2B89; Fri, 10 Oct 2003 12:14:25 -0800 Message-ID: Date: Fri, 10 Oct 2003 12:14:25 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Joe Testa Sender: ml-errors@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Joe Testa Subject: Re: Using ' in Update statement Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 73; ListGuru (c) 1996-2003 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Get over it and like it was stated earlier, go to usenet. joe Rajesh.Rao@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@ra > disys.com To: Multiple recipients of list ORACLE-L > Sent by: cc: > ml-errors@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 > To: Multiple recipients of > Sent by: list ORACLE-L > ml-errors@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@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 >> >> > > > >> > >> >recipients of list ORACLE-L > > >> ng.com> cc: >> >> > > > >> Sent by: Subject: RE: Using ' in >> >> >Update statement > > >> ml-errors@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 >>> >>> >> >>> >>recipients >> >> >>>of list ORACLE-L >>> ng.com> cc: >>> >>> Sent by: Subject: Re: Using ' in >>>Update statement >>> ml-errors@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@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 >>>> >>>> >>>> >>> >>>> >>>recipients of list ORACLE-L >>> >>> >>>> ng.com> cc: >>>> >>>> >>>> Sent by: Subject: Re: Using ' >>>> >>>> >in > > >>>Update statement >>> >>> >>>> ml-errors@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@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@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).