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