No blank lines between command window output

[Tobo]

Whenever I run commands in a command window, there are no blank lines between the output lines. This worked in the previous version so I'm guessing one of my settings changed. I'm using 10.0.5.1710.

Here's an example. If I enter the commands below in the edit tab of the command window:

--System Information
prompt ** System Info
prompt -----------
set heading off
select substr(instance_name,1,20) || ' ' || substr(host_name,1,20) from v$instance;
select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
set heading on

--Database Status
prompt
prompt

prompt ** Database Status **
SELECT d.name "Database", i.status, i.logins, d.open_mode "DB MODE",i.database_status "DB STATUS"
FROM v$instance i, v$database d WHERE UPPER(i.instance_name) = UPPER(d.name);

The output will look like this:

SQL>
** System Info
-----------
mydb HPSRVR13
2014-01-07 06:43:39
** Database Status **
Database STATUS LOGINS DB MODE DB STATUS
--------- ------------ ---------- -------------------- -----------------
MYDB OPEN ALLOWED READ WRITE ACTIVE

I would prefer for it to look like this:

SQL>
** System Info
-----------
mydb HPSRVR13
2014-01-07 06:43:39

** Database Status **
Database STATUS LOGINS DB MODE DB STATUS
--------- ------------ ---------- -------------------- -----------------
MYDB OPEN ALLOWED READ WRITE ACTIVE

Note the two blank lines as a result of the PROMPT command between the two SQL results.

Question: what do I need to change in Tools / Preferences or some other location to make this happen? Thanks.

 

[Marco Kalter]

There is no preference for this, but this is on the list of enhancement requests.

 

[Tobo]

Thanks Marco for the info.