CODEWITHSUNDEEP
oracle-sqldeveloper
user1872384
user1872384

Reputation: 7147

sql developer export table to xls

How to export the entire query results to xls format without the value truncated (with the header intact).

e.g

truncated value in yellow

the value is round up to 276408428673510000 when the actual value is suppose to be 276408428673508271

Using this method

enter image description here

Upvotes: 0

Views: 9311

Answers (2)

Lynn_Akemi
Lynn_Akemi

Reputation: 11

My solution was use the LPAD or RPAD functions, you give the exact length that you want and when you export the data, these don't round it.

Upvotes: 1

Rajkumar Raju
Rajkumar Raju

Reputation: 26

After selecting the data by clicking 'Ctrl+ A' in gride, use 'Ctrl+Shift+C' to copy the data with Header. After pasting the data into MS Excel, try changing the 'format' to number or text. You must be knowing that 'format cells' is available as a right click option in MS Excel.

Upvotes: 1

Related Questions