Toad World® Forums

Import data Utility- convert decimal to fraction

Message from: spathak26_718

Hi,

I have converted Microsoft Excel data into Oracle table using TOAD “Import data”

utility. It is converting data from fraction to decimal but I want data in
fractions
in my table. Please let me know if it can be done.

expected result
Code Tol_minus tol_plus incr1 incr2
1.01 -1/2 1/4 3/4 1 3/4

Thanks
Sandy


Historical Messages

Author: spathak26_718
Date: Fri Nov 04 09:26:55 PDT 2011

Hi,

I have converted Microsoft Excel data into Oracle table using TOAD “Import data”

utility. It is converting data from fraction to decimal but I want data in
fractions
in my table. Please let me know if it can be done.

expected result
Code Tol_minus tol_plus incr1 incr2
1.01 -1/2 1/4 3/4 1 3/4

Thanks
Sandy

__


I have converted Microsoft Excel data into Oracle table

It is converting data from fraction to decimal but I want

data in fractions in my table

Interesting question. Mathematically a fraction and a decimal value are
identical. I’m not sure Oracle is – by default – built to
handle such “number formats” as fractions, percentages, etc.

Even Excel stores the value in a number (like a decimal of .5) and then formats
it via the display functionality into the fractional version (1/2).

I don’t know if Toad was built with the options to select formats such as
percentages and fractions. The version I have, 10.6, does not seem to contain
such functionality.

If I’m correct on both Toad and Oracle (and I could easily be wrong as
I’ve never had need for such functionality), then your options are: