Hi, I have a table in the database (oracle 10 g). I have to spool the data into excel file. when I spool the data, the leading zero is dropped in one of the column. Becasue in excel, by default the data type is "General". If the
datatype is text, then it would have come fine. e.g. in table: 098765, in excel: 98765. Can anyone help me to resolve this ...