CREATE DOMAIN -+ +--------------+ +-> <domain-name> +-----------------------------------++ | +-> STORED NAME IS <stored-name> ---+| |+-----------------------------------------------------+ |++-> IS data-type -+-+----------------------------+---+ | +-> AS data-type -+ +--> DEFAULT value-expr -----+ | | +--------------------------------------------------+ | +-+--------------------------------------------+-+ | +-> COLLATING SEQUENCE IS <collation-name> --+ | | +-> NO COLLATING SEQUENCE -------------------+ | | +------------------------------------------------+ | +-+----------------------+-+------------------------++-> | +-> domain-constraint -+ ++> sql-and-dtr-clause -++| | +---------<------------+ | +-> FROM -> <path-name> +----------------->----------+---+ +-> DATABASE ALIAS <alias> --+ domain-name = -+---------------------------+-> <name-of-domain> ---> +-+-> <schema-name> -+-> . -+ +-> <alias> -------+ data-type = --+-> char-data-types ---------------------------+--> +-> TINYINT --------------+-----+----------+---+ +-> SMALLINT -------------+ +-> (<n>) -+ | +-> INTEGER --------------+ | +-> BIGINT ---------------+ | +-> LIST OF BYTE VARYING -+ | +-> DECIMAL -++-----------------------------+--+ +-> NUMERIC -++-> ( -> <n> +----------+-> ) + | | +-> , <n> -+ | +-> FLOAT -+----------+------------------------+ | +-> (<n>) -+ | +-> REAL --------------------------------------+ +-> DOUBLE PRECISION --------------------------+ +-> date-time-data-types ----------------------+ char-data-types = -+-> CHAR -------------++------------++--------------------------------+-+-> +-> CHARACTER --------++-> ( <n> ) -++-> CHARACTER SET char-set-name -+ | +-> CHAR VARYING -----+ | +-> CHARACTER VARYING + | +-> VARCHAR --+> ( <n> ) ---+--------------------------------+----------+ +-> VARCHAR2 -+ +-> CHARACTER SET char-set-name -+ | +-> LONG VARCHAR ------------------------------------------------------+ +-> NCHAR --------------+-+------------+--------------------------------+ +-> NATIONAL CHAR ------+ +-> ( <n> ) -+ | +-> NATIONAL CHARACTER -+ | +-> NCHAR VARYING --------------+-+------------+------------------------+ +-> NATIONAL CHAR VARYING ------+ +-> ( <n> ) -+ | +-> NATIONAL CHARACTER VARYING -+ | +-> RAW -> ( <n> ) -----------------------------------------------------+ +-> LONG -+--------+----------------------------------------------------+ +-> RAW -+ date-time-data-types = --+-> DATE -+----------+-----------------+--> | +-> ANSI -+ | | +-> VMS ---+ | +-> TIME ---> frac --------------------+ +-> TIMESTAMP --> frac ----------------+ +-> INTERVAL ---> interval-qualifier --+ interval-qualifier = --+-> YEAR ---> prec --+-------------+-----------------+-> | +-> TO MONTH -+ | +-> MONTH --> prec ----------------------------------+ +-> DAY ----> prec --+-------------------------------+ | +-> TO -+-> HOUR ---------------+ | +-> MINUTE -------------+ | +-> SECOND -> frac -----+ +-> HOUR ---> prec --+-------------------------------+ | +-> TO -+-> MINUTE -------------+ | +-> SECOND -> frac -----+ +-> MINUTE -> prec --+-------------------------------+ | +-> TO SECOND ------> frac -----+ +-> SECOND -> seconds-prec --------------------------+ literal = --+-> numeric-literal ----+---> +-> string-literal -----+ +-> date-time-literal --+ +-> interval-literal ---+ domain-constraint = --+----------------------------------------------------+----> +-> CHECK ( predicate ) -+--------------------------++ +-> constraint-attributes -+ sql-and-dtr-clause = -+-> QUERY HEADER IS -+> <quoted-string> +------------------+-> | +------ / <--------+ | +-> EDIT STRING IS <quoted-string> ------------------------+ | | +-> QUERY NAME FOR -+-> DTR --------+-> IS <quoted-string> + | +-> DATATRIEVE -+ | +-> DEFAULT VALUE FOR -+-> DTR --------+-> IS <literal> ---+ | +-> DATATRIEVE -+ | +-> NO QUERY HEADER ---------------------------------------+ +-> NO EDIT STRING ----------------------------------------+ +-> NO QUERY NAME ----+--> FOR -+-> DTR --------+----------+ +-> NO DEFAULT VALUE -+ +-> DATATRIEVE -+ | +-> COMMENT IS -+-> <quoted-string> -+---------------------+ +------ / <----------+