RE: Add a line between sql statment

  • From: "Igor Neyman" <ineyman@xxxxxxxxxxxxxx>
  • To: <alavihamid@xxxxxxxxx>, "'Oracle-L'" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 24 Jan 2005 12:26:56 -0500

Select <column_list> , CHR(13), CHR(13)
        From <table_list)
        Where ......

Igor Neyman, OCP DBA
ineyman@xxxxxxxxxxxxxx



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l


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

Other related posts: