set numformat "999g999g999d99"
set numformat "999,999,999.99"
This works in sqlplus, sql deveoper and sqlcl.
set linesize... also works in all.
F:\OTN>type generic.sql set echo on prompt generic.sql set numformat "999,999,999.99" set linesize 132 show numformat show linesize
F:\OTN>sql -l gaz/gaz@xe ... SQL> show version Oracle SQLDeveloper Command-Line (SQLcl) version: 184.108.40.2064.2224 SQL> @f:\otn\generic.sql SQL> prompt generic.sql generic.sql SQL> set numformat "999,999,999.99" SQL> set linesize 132 SQL> show numformat numformat "999,999,999.99" SQL> show linesize linesize 132 SQL>
F:\OTN>sqlplus -l gaz/gaz@xe SQL*Plus: Release 220.127.116.11.0 Production on Mon Jan 22 20:57:40 2018 ... SQL> @f:\otn\generic.sql SQL> prompt generic.sql generic.sql SQL> set numformat "999,999,999.99" SQL> set linesize 132 SQL> show numformat numformat "999,999,999.99" SQL> show linesize linesize 132 SQL>
sql developer 18.104.22.1685.2349
...actually, linesize in sql dev may well be a bug. Setting the file f:\otn\generic.sql as the
Tools -> Preferences -> Database -> Filename for connection startup script
Gets run ok as shown by the Messages - Log (View -> Log), but the connection worksheet (in my case) shows 970:
You should raise an SR with support.oracle.com for "set linesize".
As for "set numformat", that may already have an SR raised by someone else... it errors in sql dev and sqlcl.
Here's a useful link to the sqlplus commands currently supported in sql developer 17.4
Another tip, in sql dev worksheet, type:
...and hit "Run Script" to see where/what file or files get run at login, and see if any of the files listed have a "set linesize xxx" in them, that match your linesize that sql dev is showing.
(By the way, to see "everything" type "show all+" and hit "Run Script" (F5 by default for widows)..
We set the linesize dynamically in the worksheet - as you make it wider/narrower, we set linesize to match...but I filed a bug on this awhile back as it seems to measure pixels vs characters. Apparently that's still an issue.
Thanks for the info on "set linesize".
The other command that OP posted about ("inability to use several sqlplus settings"... seems to mean 2 in OP's case)
SQL> set numformat "999g999g999d999";
SP2-0246: Illegal FORMAT string "999g999g999d999"
is still an issue, in sqlcl 22.214.171.1245.2224 and sql dev 126.96.36.1995.2349:
Is there a bug that has bee raised for that too?
(Works in sqlplus (tested in sqlplus 188.8.131.52.0 and 184.108.40.206))