CDO$HELP.HLB  —  Expressions  value_expr, Parameters  builtin-expr
    { NULL                                                             }
    {        [                                         ]               }
    {        [ [ BOTH     ]                            ]               }
    { TRIM ( [ [ LEADING  ] CHARACATER value-expr FROM ] value-expr )  }
    {        [ [ TRAILING ]                            ]               }
    {        [                                         ]               }
    { POSITION (value-expr IN value-expr FROM value-expr )             }
    { USER                                                             }
    { CURRENT_USER                                                     }
    { CURRENT_DATE                                                     }
    { CURRENT_TIME (scale)                                             }
    { CURRENT_TIMESTAMP (scale)                                        }
    { CHARACTER_LENGTH (value-expr)                                    }
    { CHAR_LENGTH (value-expr)                                         }
    { OCTET_LENGTH (value-expr)                                        }
    { UPPER (value-expr)                                               }
    { LOWER (value-expr)                                               }
    { SESSION_USER                                                     }
    { SUBSTRING [_OCTETS] (value-expr FROM value-expr FOR value-expr)  }
    { SUBSTRING_CHARACTERS (value-expr FROM value-expr FOR value-expr) }
    { SYSTEM_USER                                                      }
    { cast-builtin-expr                                                }
    {           { YEAR    }                                            }
    {           { MONTH   }                                            }
    {           { DAY     }                                            }
    {           { HOUR    }                                            }
    { EXTRACT ( { MINUTE  } FROM value-expr)                           }
    {           { SECOND  }                                            }
    {           { WEEKDAY }                                            }
    {           { JULIAN  }                                            }
    { TRANSLATE (value-expr USING character-set)                       }

    Calculate values based on specified value expressions. See the
    Descriptions subtopic for Built-in Function descriptions.

    See the Oracle Rdb7 SQL Reference Manual for the character set
    types.
Close Help