Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    spain
    Posts
    7

    Unanswered: i need newline linefeed \n cr

    hello I need to know how to put or insert a new line
    character in a multiline text item because I want to
    break by some point in the text that it contains.

    something like this
    asadjkaslkdjasld.
    asdasda, asdasdas asdasdas.
    asdads.asdasdads a.asdadasda.

  2. #2
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Re: i need newline linefeed \n cr

    Originally posted by plcabgut
    hello I need to know how to put or insert a new line
    character in a multiline text item because I want to
    break by some point in the text that it contains.

    something like this
    asadjkaslkdjasld.
    asdasda, asdasdas asdasdas.
    asdads.asdasdads a.asdadasda.
    Do you want to get the output using DBMS_OUTPUT.PUT_LINE?
    Thanks and Regards,

    Praveen Pulikunnu

  3. #3
    Join Date
    Feb 2004
    Location
    Hyderabad, India
    Posts
    9
    Hi,

    Give the ascii value of new line feed in your SQL query.
    Hope this is your requirement.

  4. #4
    Join Date
    Jan 2004
    Posts
    492
    I think you want chr(10) or chr(13) --forget exactly which one

    Do something like this:

    DBMS_OUTPUT.PUT_LINE('TEST' || chr(10) 'LINE2);

  5. #5
    Join Date
    Feb 2004
    Location
    spain
    Posts
    7

    thnks to all

    it was perfect I did it and it worked.
    I have done it before but I didn't remember,
    'text 1'||chr(10)||'text 2.'

    text 1
    text 2.

    a lot of thanks to all.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •