Re: Add a line between sql statment

depending on your os use chr(value)
select ascii(' press return here') from dual select sysdate || chr(value from above) || user from dual ----- Original Message -----
From: "hamid alavi" <alavihamid_at_gmail.com> To: "Oracle-L" <oracle-l_at_freelists.org>
Sent: Monday, January 24, 2005 12:18 PM
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

>

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