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)
Received on Fri May 27 2005 - 08:39:48 CDT
