DTRHELP.HLB  —  Commands Statements Clauses, DEFINE TABLE Command
       Enters the definition of a dictionary or domain table in the data
       dictionary (Oracle CDD/Repository) and creates an access control
       list (ACL) for the table. The following sections explain how to
       define dictionary and domain tables.

       Format

         To define a dictionary table use the following syntax:

         DEFINE TABLE path-name

          [QUERY_HEADER [IS] "header-segment"[/...]]

          [EDIT_STRING [IS] edit-string]

          [USING] code-field : translation-field [,]
          {"code-1"  }  { "translation-1" }
          {code-1    }: { translation-1   }[,]
          {          }  {                 }

          [ {"code-2"  }  {"translation-2"  } ]
          [ {code-2    }: {translation-2    } ][,]
          [ {          }  {                 } ]

           .                .
           .                .
           .                .

          [     { "translation-n"  } ]
          [ ELSE {translation-n    } ]
          [     {                  } ]

         END_TABLE

         To define a domain table use the following syntax:

         DEFINE TABLE  path-name FROM [DOMAIN] domain-name

          [QUERY_HEADER [IS] "header-segment"[/...]]

          [EDIT_STRING [IS] edit-string]

          [USING] code-field : translation-field [,]
          [     { "translation-string"  } ]
          [ ELSE {translation-string    } ]
          [     {                       } ]

         END_TABLE
Additional Information: explode extract
Arguments Examples
Close Help