Excel imports long data and changes to 000 at the end

Problem description ： from PL/SQL Import data to Excel in , It is found that the end of long data automatically becomes 000

Cause analysis ： This is a Excel When importing data , The default is normal format , The conventional format is more than 15 If the pure number of bits is at the end, it will automatically become 000, Solved                         It's also very simple , There are two main ones

terms of settlement ：

One 、 from Excel Start with the format of ：

First the PL/SQL Data for is exported as .TSV file , Then use Notepad to open , At this time, the data is correct

Then create a new blank Excel file , Press ctrl+A Select all cells , Click the start tab , Select “ routine ” Of “ Text ”

Last , Copy and paste the data in Notepad to get the correct data , Very simple

Two 、 Start with the data format ： You can splice a character on pure digital data in the database , Then import Excel in , In this way, the data will be displayed normally

  Splice a colon in front of the data （'）

Add single quotation marks to the query results ：

select '''' || to_char('aaa') || '''' from dual;--'aaa'

Related links ：

https://blog.csdn.net/woshimyc/article/details/72519018