VMS Help  —  ORACLE_RDB72, Terminology
    The following table identifies the differences in terminology
    among the Oracle Rdb standard interface products:

                  DIFFERENCES IN RELATIONAL TERMINOLOGY
                  ___________________________________________________________

                                   ANSI/ISO SQL
                  SQL______________Standard_________RDO, RDML________________

                  Alias            N/A[1]           Database handle

                  Authorization    Authorization    OpenVMS user name
                  identifier       identifier

                  Cartesian        Cartesian        Cross product
                  product          product

                  Catalog          Catalog          N/A[1]
                                   (SQL:2003)[2]

                  Column           Column           Field

                  Column select    Column select    Record selection
                  expression       expression       expression

                  Connection       Connection       N/A[1]
                                   (SQL:2003)[2]

                  Isolation level  Isolation level  Concurrency
                  READ COMMITTED   READ COMMITTED
                                   (SQL:2003)[2]

                  Isolation level  Isolation level  N/A[1]
                  REPEATABLE READ  REPEATABLE READ
                                   (SQL:2003)[2]

                  Isolation level  Isolation level  Consistency
                  SERIALIZABLE     SERIALIZABLE
                                   (SQL:2003)[2]

                  Context files    N/A[1]           N/A[1]

                  Correlation      Correlation      Context variable
                  name             name

                  Database         Database[3]      Database

                  Domain           Domain           Global field
                                   (SQL:2003)[2]

                  Environment      Environment      N/A[1]

                  List             N/A[1]           Segmented string

                  Parameter        Parameter        Host language variable

                  Predicate        Predicate        Conditional expression

                  Result table     Result table     Record stream

                  Row              Row              Record

                  Schema           Schema           N/A[1]

                  Session          Session          N/A[1]
                                   (SQL:2003)[2]

                  Storage area     N/A[1]           Storage area

                  Storage map      N/A[1]           Storage map

                  Table            Table            Relation

                  ___________________________________________________________

    Footnotes:    [1] N/A means that the term is not applicable or not used
                      with the listed product, standard, or system.

                  [2] SQL:2003 is the industry standard.

                  [3] The ANSI/ISO SQL:2003 Standard defines this term in a
               slightly different way than does the SQL interface of Oracle
        Rdb.
Close Help