RE: Add a line between sql statment

From: Bill Coulam <bill.coulam_at_nospam.com>
Date: Mon, 24 Jan 2005 11:25:40 -0600
Message-ID: <FJEOLLFBELDPHAFFABKMKEJGCEAA.bill.coulam@nospam.com>

SQL*Plus or some other database interface?

If SQL*Plus, check out the BREAK command in the User Guide.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of hamid alavi Sent: Monday, January 24, 2005 11:18 AM
To: Oracle-L
Subject: Add a line between sql statment

Hi list,

How can I add an space line(CR) between the result of a query:

example:
line 1
space line
space line
line 2
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Mon Jan 24 2005 - 12:25:28 CST