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