RE: Add a line between sql statment

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 24 Jan 2005 12:26:56 -0500
Message-ID: <002701c50239$e7714a00$2004a8c0@development.perceptron.com>

Select <column_list> , CHR(13), CHR(13)

	From <table_list)
	Where ......

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

-----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 12:18 PM
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:30:14 CST