Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Very important: Problems with Oracle SQL!
>the problem part is " 'AK' + aukIndex as AKINDEX "
Normally you'd use concat (..) or || to concatenate two strings in Oracle. So, try:
'AK' || aukIndex
or
'AK' || to_char( aukIndex )
Arjan. Received on Thu Aug 27 1998 - 13:20:46 CDT