thanks for response
Anna Bachman, February 01, 2022 - 11:03 pm UTC
Thanks for the response.
I tried your suggestions:
> show sqlformat
SQL Format : Default
> set sqlformat
SQL Format Cleared
> select ....
Same results, i.e. the column names are printed every 58 rows, but
no page break character
February 02, 2022 - 8:53 am UTC
What exactly are you expecting to appear that doesn't? How does this differ to SQL*Plus?
expect a formfeed character in SQLCl (as I do in SQL*Plus)
Anna Bachman, February 02, 2022 - 3:06 pm UTC
Hi again,
When I use SQL*Plus, I see a formfeed character at the bottom of each page. Not so with running the same query in SQLCl.
As mentioned in my initial Results, I am wondering why there is a difference between the output of a query in SQL*Plus vs SQLCl. Perhaps a configuration or set command?
from initial post...
Results: This script results in output with formfeed (^L or CHR(12)) in spooled output when run in SQL*Plus, but not in SQLcl.
February 03, 2022 - 3:20 am UTC
We'll check with the SQLcl team and report back
set classic on
Ramon Caballero, February 02, 2022 - 9:07 pm UTC
February 03, 2022 - 3:20 am UTC
Setting is accepted but does not change things. We'll ask the SQLcl team internally
Any feedback from SQLcL team?
Anna Litch Bachman, June 16, 2022 - 6:02 pm UTC
Hello!
Back in February, you were going to check with the SQLcL team on support for set newpage 0
Any news? Even just knowing if it is definitely not supported or plans to support would be helpful.
July 05, 2022 - 12:11 am UTC
My apologies - I should have come back to this with an update.
Bug 34349407 was logged, so it is with the devs
Thanks for response Conner
Anna Litch Bachman, July 05, 2022 - 2:09 pm UTC
At least now I have a bug number to check in on.
July 06, 2022 - 10:32 am UTC
You're welcome