Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Expressions, 8 of 14
You can use any built-in SQL function or user-defined function as an expression. Some valid built-in function expressions are:
LENGTH('BLAKE') ROUND(1234.567*43) SYSDATE
A user-defined function expression specifies a call to
CREATE OPERATOR
,
CREATE FUNCTION
, and Oracle9i Data Cartridge Developer's Guide)
Some valid user-defined function expressions are:
circle_area(radius) payroll.tax_rate(empno) scott.payrol.tax_rate(dependents, empno)@ny DBMS_LOB.getlength(column_name) my_function(DISTINCT a_column)
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|