Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Real Datatypes and Nested Tables

Real Datatypes and Nested Tables

From: Ian MacGregor <ian_at_SLAC.Stanford.EDU>
Date: Thu, 04 May 2000 14:05:35 -0700
Message-Id: <10487.104992@fatcity.com>


If one, creates datatypes which are comprised of two columns defined as number(8,3), or as float, or as number; and one creates another three datatypes
as "tables of" the 3 datatypes mentioned above, and one creates three tables using
the three table of datatypes , one per table, as a nested tables:

How does one display the fractional portions of the data from the nested table in SQL*PLUS ? The values are being rounded to integers.

Ian MacGregor
Stanford Linear Acclerator Center
ian_at_slac.stanford.edu Received on Thu May 04 2000 - 16:05:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US