Internal vs. External datatypes [question]
From: Harold Almon <hala_at_shared.com>
Date: 22 Feb 95 21:55:43 GMT
Message-ID: <3igbsv$67q_at_transfer.stratus.com>
Date: 22 Feb 95 21:55:43 GMT
Message-ID: <3igbsv$67q_at_transfer.stratus.com>
Does anyone know if ORACLE stores the external datatype definition of a column in any of its internal tables? I have read that the DESCRIBE statement returns the internal datatype but I really need to know the way the column was described in the CREATE TABLE statement.
From what I understand, if I use
age INTEGER;
in a CREATE TABLE statement, the DESCRIBE will return decimal(10,0) as the datatype. What I'm trying to find is that age was defined as a INTEGER. Received on Wed Feb 22 1995 - 22:55:43 CET