SQL : The Complete Beginner's Guide - Step By Step Instructions (The Black Book) by Byron Francis

Author:Byron Francis [Francis, Byron]
Language: eng
Format: epub
Published: 2017-04-28T07:00:00+00:00

DECIMALSpecifies values similar to those of the NUMERIC data type. However, if the implementation-defined precision is higher than the specified precision, values with the higher precision will be accepted, but the scale will always be what you specify.

Example: ARTIST_ROYALTY DECIMAL (5, 2)

INTEGER Specifies a value with an implementation-defined precision and a 0 scale, meaning that only integers are accepted and you do not specify any parameters with this data type. The data type can also be abbreviated as INT. Example: ARTIST_ID INT

SMALLINTSpecifies a value similar to an INTEGER data type. However, the precision defined by the implementation must be smaller than the INTEGER precision.

Example: ARTIST_ID SMALLINT

FLOATSpecifies the precision of a numeric value, but not the scale.

Example: ARTIST_ROYALTY FLOAT (6)

REALSpecifies a value with an implementation-defined precision, but without a scale. The precision must be smaller than the precision defined for a DOUBLE PRECISION data type.

Example: ARTIST_ROYALTY REAL

DOUBLE PRECISIONSpecifies a value with an implementation-defined precision, but without a scale. The precision must be greater than the precision defined for the REAL data type. The implication is that the value of the precision should be double that of the REAL data type, but each implementation defines double differently. Example: ARTIST_ROYALTY DOUBLE PRECISION

Table 3-2 Numeric Data Types with Example Column Definitions

Datetime Data Types

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.