new line character for a place holder column in reports
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: new line character for a place holder column in reports

  1. #1
    Join Date
    Jun 2001
    Posts
    109
    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

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    :cp_concatinated:= :cp_1||chr(10)||:cp_2||chr(10)||:cp_3||chr(10)||:cp_4 ;

  3. #3
    Join Date
    Jun 2001
    Posts
    109
    What does chr(10) do?

  4. #4
    Join Date
    Jun 2001
    Posts
    109
    It doesn't like that? Its not printing anything.

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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
  •  


Click Here to Expand Forum to Full Width