From: "Klaus Zeuch" <Klaus.Zeuch@erls04.siemens.de>
Subject: WebDB and report download to Excel
Date: 2000/05/05
Message-ID: <8etu06$c9h$1@papyrus.erlm.siemens.de>#1/1
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211
X-Complaints-To: newsteam@erlm.siemens.de
X-Trace: papyrus.erlm.siemens.de 957512518 12593 149.1.41.29 (5 May 2000 07:41:58 GMT)
Organization: Siemens AG, ATD TD IT MV 1
X-MSMail-Priority: Normal
NNTP-Posting-Date: 5 May 2000 07:41:58 GMT
Newsgroups: comp.databases.oracle.tools


Hi,

when downloading files as sylk-file("Excel")  webdb truncates leading zeroes
in columns of database-type char/varchar2 if the contents can be interpreted
as a number (doesn't do that in html/ascii-display). Any solutions (except
prefixing the column retrieved in the sql-statement with select .... ' ' ||
column as .... from)?

Version: 2.1.0.9.3 on 8.1.5.0.0  HP-UX 64 bit,

Thanks

Klaus