May 2008
-
Interesting fact about Microsoft Excel.
—
in TechnologyToday I woke up to the fact that – Microsoft Excel can store only 65,536 rows per sheet.Exporting data from any other tool like TOAD, will write the extra rows,…
-
SQL Date formatting function
—
in TechnologyTO_CHAR(date column to format , ‘DD-Mon-YYYY’) = ’10-May-2008′ THis function comes handy to do quick date comparisions.