SqlDbx
You are not logged in.
Pages: 1
What is the difference between three different options:
1. Excel
2. Excel (as text, smart)
3. Excel (as displayed
Offline
1. This is just raw export to Excel
2. This option tries to address following issues. Assume you have BIGINT column which has a big value. Excel will format it as double in scientific notation which is not good. Another example VARCHAR field with value '000003'. Default
export into Excel will show it as 3.
That's why BIGINT columns exported to Excel as text
3. This option outputs all columns the way they displayed. So basically everything exported explicitly as text
Offline
1. This is just raw export to Excel
2. This option tries to address following issues. Assume you have BIGINT column which has a big value. Excel will format it as double in scientific notation which is not good. Another example VARCHAR field with value '000003'. Default
export into Excel will show it as 3.
That's why BIGINT columns exported to Excel as text
3. This option outputs all columns the way they displayed. So basically everything exported explicitly as text
We had bad data in oracle date field. Ex date ='0000-00-00' or '9999-99-99'.
Sqldbx export the 0000-00-00 in option #3 as 10007-06-07. Sqlplus exported those date as is 0000-00-00.
Pages: 1