numeric_test1.htm
Disclaimer: Objectives
  • This example shows the base and sub types of NUMBER family data type.
Describe Table
SQL View (SQL Developer Tool) 

desc numeric_test1
Name Null Type       
---- ---- ---------- 
M1        NUMBER       --number
M2        NUMBER(38)   --smallint
M3        NUMBER(38)   --int
M4        NUMBER(38)   --integer
M5        FLOAT(63)    --real
M6        FLOAT(126)   --float(126)
M7        NUMBER(38)   --numeric
M8        NUMBER(38)   --dec(38)
M9        FLOAT(126)   --double precision
SQL Developer "detail" tab

details: Machinery underneath a table and data type

CREATED 23-MAY-14
LAST_DDL_TIME 23-MAY-14
OWNER SCOTT
TABLE_NAME NUMERIC_TEST1
TABLESPACE_NAME USERS
CLUSTER_NAME
IOT_NAME
STATUS VALID
PCT_FREE 10
PCT_USED
INI_TRANS 1
MAX_TRANS 255
INITIAL_EXTENT
NEXT_EXTENT
MIN_EXTENTS
MAX_EXTENTS
PCT_INCREASE
FREELISTS
FREELIST_GROUPS
LOGGING YES
BACKED_UP N
NUM_ROWS
BLOCKS
EMPTY_BLOCKS
AVG_SPACE
CHAIN_CNT
AVG_ROW_LEN
AVG_SPACE_FREELIST_BLOCKS
NUM_FREELIST_BLOCKS
DEGREE 1
INSTANCES 1
CACHE N
TABLE_LOCK ENABLED
SAMPLE_SIZE
LAST_ANALYZED
PARTITIONED NO
IOT_TYPE
OBJECT_ID_TYPE
TABLE_TYPE_OWNER
TABLE_TYPE
TEMPORARY N
SECONDARY N
NESTED NO
BUFFER_POOL DEFAULT
ROW_MOVEMENT DISABLED
GLOBAL_STATS NO
USER_STATS NO
DURATION
SKIP_CORRUPT DISABLED
MONITORING YES
CLUSTER_OWNER
DEPENDENCIES DISABLED
COMPRESSION DISABLED
COMPRESS_FOR
DROPPED NO
COMMENTS