Oracle's column formatting causes field values to be displayed as "# # #" approach

Questions:

Query a field, the result field value display is All "# # #

Reason:

Before making other queries, the same field name was formatted:col value format A20, which causes the column data to show an exception;

Workaround:

1. Exit the current session and log back in

Exit

Sqlplus/nologin

Conn/as SYSDBA

2. Formatted clear:column field name Clear

That is:col Value Clear

Later, after careful query, the error field itself is the Number data type, and the previous query time format of the same name field is varchar2, so, do the column format must be error.

Since it is a number type, it is also possible to handle this problem in the same way as Col value format 9999 , in addition to the top 2 methods.

Oracle's column formatting causes field values to be displayed as "# # #" approach