Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    32

    Unanswered: newline in Oracle

    How to put the new line in the string type variable in the stored procedure

    for example
    declare abc varchar2(20)

    abc := 'abc\ncde'

    And the expected result is
    abc
    cde

    but the final result is
    abc\ncde

  2. #2
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas, USA
    Posts
    68
    Try 'abc' || chr(10) || 'cde' -- newline character is x0D, or 10 I think.

Posting Permissions

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