Skip Headers
Oracle® Database SQL Reference
10g Release 2 (10.2)

Part Number B14200-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Oracle Compliance with FIPS 127-2

Oracle complied fully with last Federal Information Processing Standard (FIPS), which was FIPS PUB 127-2. That standard is no longer published. However, for users whose applications depend on information about the sizes of some database constructs that were defined in FIPS 127-2, we list the details of our compliance in Table B-12.

Table B-12 Sizing for Database Constructs

Database Constructs FIPS Oracle Database

Length of an identifier (in bytes)

18

30

Length of CHARACTER datatype (in bytes)

240

2000

Decimal precision of NUMERIC datatype

15

38

Decimal precision of DECIMAL datatype

15

38

Decimal precision of INTEGER datatype

9

38

Decimal precision of SMALLINT datatype

4

38

Binary precision of FLOAT datatype

20

126

Binary precision of REAL datatype

20

63

Binary precision of DOUBLE PRECISION datatype

30

126

Columns in a table

100

1000

Values in an INSERT statement

100

1000

SET clauses in an UPDATE statement (Note 1)

20

1000

Length of a row (Note2, Note 3)

2,000

2,000,000

Columns in a UNIQUE constraint

6

32

Length of a UNIQUE constraint (Note 2)

120

(Note 4)

Length of foreign key column list (Note 2)

120

(Note 4)

Columns in a GROUP BY clause

6

255 (Note 5)

Length of GROUP BY column list

120

(Note 5)

Sort specifications in ORDER BY clause

6

255 (Note 5)

Length of ORDER BY column list

120

(Note 5)

Columns in a referential integrity constraint

6

32

Tables referenced in a SQL statement

15

No limit

Cursors simultaneously open

10

(Note 6)

Items in a select list

100

1000


Note 1: The number of SET clauses in an UPDATE statement refers to the number items separated by commas following the SET keyword.

Note 2: The FIPS PUB defines the length of a collection of columns to be the sum of: twice the number of columns, the length of each character column in bytes, decimal precision plus 1 of each exact numeric column, binary precision divided by 4 plus 1 of each approximate numeric column.

Note 3: The Oracle limit for the maximum row length is based on the maximum length of a row containing a LONG value of length 2 gigabytes and 999 VARCHAR2 values, each of length 4000 bytes: 2(254) + 231 + (999(4000)).

Note 4: The Oracle limit for a UNIQUE key is half the size of an Oracle data block (specified by the initialization parameter DB_BLOCK_SIZE) minus some overhead.

Note 5: Oracle places no limit on the number of columns in a GROUP BY clause or the number of sort specifications in an ORDER BY clause. However, the sum of the sizes of all the expressions in either a GROUP BY clause or an ORDER BY clause is limited to the size of an Oracle data block (specified by the initialization parameter DB_BLOCK_SIZE) minus some overhead.

Note 6: The Oracle limit for the number of cursors simultaneously opened is specified by the initialization parameter OPEN_CURSORS. The maximum value of this parameter depends on the memory available on your operating system and exceeds 100 in all cases.