"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 laterOracle 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 |