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: