1 %field-name-spec 2? 2 CHAR 2.1? 2.1 BIT (length) 2.1.1 %strip-spec 2.1 MIXED-| strip-spec | 2.1 BLOBF 2.1.1? PRESERVE WHITESPACE 2.1.2? BINARYXML 2.1 CLOBF 2.1.1? MIXED 2.1.2? PRESERVE WHITESPACE 2.1 DBCLOBF 2.1.1? PRESERVE WHITESPACE 2 VARCHAR 2.1? 2.1 BIT 2.1 MIXED 2.1 BLOBF 2.1.1? PRESERVE WHITESPACE 2.1.2? BINARYXML 2.1 CLOBF 2.1.1? MIXED 2.1.2? PRESERVE WHITESPACE 2.1 DBCLOBF 2.1.1? PRESERVE WHITESPACE 2.1.2 %strip-spec 2 GRAPHIC 2.1? EXTERNAL 2.2? (length) 2.3 %strip-spec 2 VARGRAPHIC 2.1 %strip-spec 2 SMALLINT 2 INTEGER 2.1? EXTERNAL 2.1.1? (length) 2 BIGINT 2 BINARY 2.1? (length) 2.2 %strip-spec 2.0 VARBINARY 2.0 BINARY VARYING 2.1 %strip-spec 2 %decimal-spec 2 FLOAT 2.1? EXTERNAL 2.2? (length) 2 DATE EXTERNAL 2.1? ( 2.1.1 length 2.1.1 date-format 2.1.2 ) 2 TIME EXTERNAL 2.1? ( 2.1.1 length 2.1.1 time-format 2.1.2 ) 2 TIMESTAMP EXTERNAL 2.1? ( 2.1.1 length 2.1.1 timestamp-format 2.1.2 ) 2 TIMESTAMP-WITH-TIME-ZONE EXTERNAL 2.1? (length) 2 ROWID 2 BLOB 2 CLOB 2.1? MIXED 2 DBCLOB 2 DECFLOAT 2.1! (34) 2.1? 2.1 (16) 2.1 EXTERNAL 2.1.1? (length) 2 XML 2.1? PRESERVE WHITESPACE 2.2? BINARYXML 3? 3 NULLIF 3.1 %field selection criterion 3 DEFAULTIF 3.1 %field selection criterion