Re: Add a line between sql statment
- From: "Michael McMullen" <ganstadba@xxxxxxxxxxx>
- To: <alavihamid@xxxxxxxxx>, "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 24 Jan 2005 12:32:19 -0500
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@xxxxxxxxx>
To: "Oracle-L" <oracle-l@xxxxxxxxxxxxx>
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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
