如何在PL/SQL开发人员的网格输出中设置numwidth?
问题描述：
我正在PL/SQL Developer中运行一些查询，结果中的一列有18位数字. PL/SQL Developer不会以科学计数形式仅显示15位数字，而不会在结果网格中显示整个数字.
I'm running some queries in PL/SQL Developer, and one of the columns in the result has 18-digit numbers. Instead of displaying the entire number in the resulting grid, PL/SQL Developer displays only 15 digits in scientific notation.
我试图找到一种方法来更改程序的首选项，以便我能看到整个数字，就像SQL * Plus中的set numwidth一样.但是我的搜索是徒劳的.
I tried to find a way to change this in the preferences of the program, so that I'll see the entire number, just like set numwidth does in SQL*Plus. But my search was futile.
如何更改此设置?
答
证明此是可能的！
工具->首选项-> SQL窗口-> 编号字段为to_char
Tools -> Preferences -> SQL Window -> Number fields to_char