Oracle exports data to CSV format via PL/SQL developer, VARCHAR2 Type field if the value is stored in a number (for example, 3307830000004059) too long, the last one will be set to 0

Problem Description:

Oracle uses PL/SQL developer to export data to CSV format, VARCHAR2 Type field if the value (for example, 3307830000004059) is too long, the CSV file is represented in scientific notation, even if the column is selected, click Data--. > columns, fixed width, column data format select text, and the last one will still be set to 0.

Workaround:

Oracle uses PL/SQL developer to export data to CSV format, create a new Excel file, click Data-to-text, select previously exported CSV file, file type separator symbol, select comma, "Select all Columns" and select column data format text.

Examples are as follows:

1) Oracle's column data

2) CSV file when the column is parsed, the last character in the last column is set to 0

3) Workaround

1. Oracle exports data to CSV format files via PL/SQL developer Test.csv
2. Create a new Excel file, click Data--from text, select the previously exported CSV file Test.csv as shown in

　　　　

3. Click Next to show

　　　　

4. Select comma, click Next as shown, Shift-Select all columns, select text Format

　　　　

5. Click Done, as shown, select data to be stored on an existing worksheet or a new sheet

　　　　

6. All columns are displayed as style text in the database

　　　　

Oracle exports data to CSV format via PL/SQL developer, VARCHAR2 Type field if the value is stored in a number (for example, 3307830000004059) too long, the last one will be set to 0