Carlos wrote:
>>>How do you expect to concatenate a string to a number.
>
>
> Wrong. Though TO_CHAR() is the right method for such concatenation,
> Oracle can manage without it:
>
> SQL> create sequence KKSEQ;
>
> Secuencia creada.
>
> SQL> select 'XXXX'||kkseq.nextval from dual;
>
> 'XXXX'||KKSEQ.NEXTVAL
> --------------------------------------------
> XXXX1
>
> SQL> /
>
> 'XXXX'||KKSEQ.NEXTVAL
> --------------------------------------------
> XXXX2
>
> SQL> /
>
> 'XXXX'||KKSEQ.NEXTVAL
> --------------------------------------------
> XXXX3
>
> I hope your pupils cannot read this, Daniel ;-)
>
> Cheers.
Actually I hope they do. My eyes were drawn to a bad practice
and it was late. I have no problem admitting when I am incorrect.
I do, however, have a problem with people encouraging bad coding
habits.
--
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:41:05 CDT
