Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!f14g2000cwb.googlegroups.com!not-for-mail From: poratips@hotmail.com Newsgroups: comp.databases.oracle.server Subject: Re: INSERT or MULTI INSERT Date: 6 Jun 2005 11:57:14 -0700 Organization: http://groups.google.com Lines: 106 Message-ID: <1118084234.058335.92820@f14g2000cwb.googlegroups.com> References: <1117177220.44669@yasure> <1117182231.965839.253300@g14g2000cwa.googlegroups.com> <1117200927.896270@yasure> <1117205412.716193.272330@f14g2000cwb.googlegroups.com> <1117209064.191033@yasure> NNTP-Posting-Host: 12.2.115.11 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1118084239 17870 127.0.0.1 (6 Jun 2005 18:57:19 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Mon, 6 Jun 2005 18:57:19 +0000 (UTC) In-Reply-To: <1117209064.191033@yasure> User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: f14g2000cwb.googlegroups.com; posting-host=12.2.115.11; posting-account=lfdnTw0AAACzkt07zDa4mPrEh8QjFG_p Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:244364 Thanks lot for your kind information and efforts. I really appreciate it. -- Poratips DA Morgan wrote: > tim.kearsley@milton-keynes.gov.uk wrote: > > > > DA Morgan wrote: > > > >>tim.kearsley@milton-keynes.gov.uk wrote: > >> > >>>DA Morgan wrote: > >>> > >>>< SNIP > > >>> > >>>>TO_CHAR(dynamo.ORDER_SEQ.nextval). > >>>> > >>>>How do you expect to concatenate a string to a number. > >>>> > >>>>For any further help post Oracle version and the error messages. > >>>>We are unable to look over your shoulder or read your mind. > >>>>-- > >>>>Daniel A. Morgan > >>>>Relational theory is not something that is simply a nice-to-have. > >>>>http://www.psoug.org > >>>>damorgan@x.washington.edu > >>>>(replace x with u to respond) > >>> > >>> > >>>Daniel, please make sure of your facts before posting. > >>> > >>>Oracle will handle concatenating a number with a string without any > >>>problem: > >>> > >>>Connected to: > >>>Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production > >>>With the Partitioning, OLAP and Oracle Data Mining options > >>>JServer Release 9.2.0.4.0 - Production > >>> > >>>SQL> create sequence tkseq; > >>> > >>>Sequence created. > >>> > >>>SQL> select tkseq.nextval from dual; > >>> > >>> NEXTVAL > >>>---------- > >>> 1 > >>> > >>>SQL> / > >>> > >>> NEXTVAL > >>>---------- > >>> 2 > >>> > >>>SQL> select 'XXXX'||tkseq.nextval from dual; > >>> > >>>'XXXX'||TKSEQ.NEXTVAL > >>>-------------------------------------------- > >>>XXXX3 > >>> > >>>As I mentioned to you in a previous post on another topic a week or two > >>>ago, (and incidentally you never did acknowledge that you were > >>>incorrect on that occasion) it does nobody any good to post "facts" > >>>that are clearly incorrect and that you clearly haven't tested > >>>yourself. It only reduces your own credibility. > >>> > >>>Regards, > >>> > >>>Tim Kearsley > >>>HBS Milton Keynes > >> > >>It will ... but it also generates a PLS error if you have informational > >>warnings turned on. It is what is referred to as a "bad pratice:" One > >>that Oracle advises against. > >>-- > >>Daniel A. Morgan > >>Relational theory is not something that is simply a nice-to-have. > >>http://www.psoug.org > >>damorgan@x.washington.edu > >>(replace x with u to respond) > > > > > > Hmmm. Fair comment, but the initial reply you made to the OP, i.e.: > > > > > >>>>How do you expect to concatenate a string to a number. > > > > > > suggests strongly to me that you were suggesting that it isn't > > POSSIBLE, not just that it isn't good practice. > > > > Tim Kearsley > > HBS Milton Keynes > > I was incorrect ... or I used poor wording. I think it was poor wording > but others will think I was shirking responsibility so you get it both > ways. > -- > Daniel A. Morgan > Relational theory is not something that is simply a nice-to-have. > http://www.psoug.org > damorgan@x.washington.edu > (replace x with u to respond)