-
Hello all,
I have a place holder column which is nothing but a concatination of different place holder columns. I need a new line whenever it concatinates the next place holder column.
:cp is a plcae holder column.
for ex:
:cp_1='A'
:cp_2='B'
:cp_3='C'
:cp_4='D'
:cp_concatinated:= :cp_1||:cp_2||:cp_3||:cp_4
output:---ABCD
but I need my output to be
A
B
C
D
Can anyone help pleeeeeease..
thanks
Saritha
-
:cp_concatinated:= :cp_1||chr(10)||:cp_2||chr(10)||:cp_3||chr(10)||:cp_4 ;
-
-
It doesn't like that? Its not printing anything.
-
This is function that convert ASCII code 10 (CR) to char variable.
http://download-east.oracle.com/otnd...18.htm#1016244
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|