Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    21

    Unanswered: How to delimit records by carriage return/line feed

    Hi,

    I'm running some queries(report) and the records are supposed to be delimited by carriage return/line feed. Apart from using whitespaces, how do I ensure that records are delimited by carriage return/line feed.

    Thanks
    It pays to share!

  2. #2
    Join Date
    May 2003
    Location
    France
    Posts
    112

    Re: How to delimit records by carriage return/line feed

    try to add chr(10) in your query

    Originally posted by daymauler
    Hi,

    I'm running some queries(report) and the records are supposed to be delimited by carriage return/line feed. Apart from using whitespaces, how do I ensure that records are delimited by carriage return/line feed.

    Thanks

  3. #3
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    21

    Re: How to delimit records by carriage return/line feed

    thanks I've tried that too, I thought there might be something better. thanks a lot.
    It pays to share!

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    in sql-plus you could set pagesize 1
    you would also need to set heading off so that you don't get the column
    titles every row.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Feb 2004
    Location
    Atlanta, GA
    Posts
    21
    thanks I will try it.
    It pays to share!

Posting Permissions

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