My Oracle Support Banner

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

Last updated on JUNE 21, 2021

Applies to:

Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle SQL Developer - Version 4.1 and later
Oracle Database Exadata Cloud Machine - Version N/A 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

 

NOTE: In the example above user details  represent a fictitious sample (based upon made up data used in the Oracle Demo Data). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

 

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!


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.