"Run Script" Showing Multiple Headers in "Script Output" (Doc ID 2287934.1)

Last updated on JULY 19, 2017

Applies to:

Oracle SQL Developer - Version 4.1 and later
Information in this document applies to any platform.

Symptoms

When running a SQL query that returns more than 14 records with "Run Script" button, the result of "Script Output" shows multiple headers.

Example:

1. Input following SQL in the SQL Worksheet.

select ename from emp;

2. Click "Run Script" button,you can confirm the result outputed two header.

ENAME ----------- > first one
----------
SMITH
ALLEN
WARD
JONES
MARTIN
BLAKE
CLARK
SCOTT
KING
TURNER
ADAMS

ENAME ----------- > second one
----------
JAMES
FORD
MILLER

14 rows selected

 

Changes

 Execute query using "Run Script" button.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms