My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.