Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: Query on VARCHAR2....

    All,

    In VARCHAR2 column, I would like to store data line by line.
    As an Example :

    This is first line
    This is second line
    This is ....


    It is possible to store the value in VARCHAR2 column this way?

    Thanks,
    JD

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    Use the newline character CHR(10):
    Code:
    SQL> select 'xxx'||chr(10)||'yyy' from dual;
    
    'XXX'||
    -------
    xxx
    yyy

Posting Permissions

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