Thanks lot for your kind information and efforts.
I really appreciate it.
DA Morgan wrote:
> tim.kearsley_at_milton-keynes.gov.uk wrote:
> >
> > DA Morgan wrote:
> >
> >>tim.kearsley_at_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_at_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_at_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_at_x.washington.edu
> (replace x with u to respond)
Received on Mon Jun 06 2005 - 13:57:14 CDT
