SQL Functions

• new SQL functions added for Oracle7

• existing SQL functions with new functionality

New SQL Functions

• SIN

• COS

• TAN

• SINH

• COSH

• TANH

• EXP

• LN

• LOG

• CONCAT

• INSTRB

• LENGTHB

• SUBSTRB

• NLS_INITCAP

• NLS_LOWER

• NLS_UPPER

• TO_MULTI_BYTE

• TO_SINGLE_BYTE

• GLB

• LUB

• TO_LABEL

• GREATEST_LB

• LEAST_UB

Existing SQL Functions with New Functionality

• The POWER function now allows non-integral exponents.

• The NLSSORT function now accepts the optional NLS_SORT parameter for National Language Support.

• The TO_CHAR function now accepts the optional parameters NLS_DATE_LANGUAGE, NLS_NUMERIC_CHARACTERS, NLS_CURRENCY, and NLS_ISO_CURRENCY for National Language Support.

• In Trusted Oracle7, the TO_CHAR function converts values with the datatypes MLSLABEL or RAW MLSLABEL to values with the datatype VARCHAR2.

• The TO_DATE function now accepts the optional NLS_DATE_LANGUAGE parameter for National Language Support.

• The TO_NUMBER function now accepts the parameters NLS_NUMERIC_CHARACTERS, NLS_CURRENCY, and NLS_ISO_CURRENCY for National Language Support.