Shulou(Shulou.com)06/01 Report--

Question:

Query a certain field, and the result field values are all "#"

Reason:

In previous queries, the same field name was formatted: col value format A20, which caused the column data to display abnormally

Solution:

1. Exit the current session and log in again

Exit

Sqlplus / nologin

Conn / as sysdba

2. Format clear: column field name clear

Namely: col value clear

Later, after careful query, the error field itself is the number data type, and the field with the same name formatted before the query is varchar2, so it is bound to make an error after formatting the column.

Since it is a number type, in addition to the two handling methods above, you can also deal with this problem in such a way as col value format 9999.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.