Just found an interesting feature in SQL Developer 3

I created a dataset that contained two columns of numbers that I wanted to quickly get into excel. I choose, export in CSV format to clipboard so that I could quickly paste it into an existing spreadsheet.

My dataset contained:

1234, 5678
2345, 6789
3456, 7890

The data that was exported was:

12,345,678
23,456,789
34,567,890

Have to export to an xls file, open it then copy and paste – YAWN !

Last week I gave a colleague a demonstration on why, if you have numbers stored in a character string you should convert them explicitly to numbers:

select ‘Yes’
from dual
where ’1000′ between ’000′ and ’999′;

‘YES’
—–
Yes

Protected: Tell Me When The DB Is Back

Oracle, Windows, Work Enter your password to view comments.
Apr 072009

This post is password protected. To view it please enter your password below:


Follow Me

Translate this Page

© 2011 Ross Goodman Suffusion theme by Sayontan Sinha