Page History
...
Estimates the selectivity (0-100) of a value. The value is defined as (100 * distinctCount / rowCount). The selectivity of 0 rows is 0 (unknown). Up to 10000 values are kept in memory. Aggregates are only allowed in select statements.
Example
| Code Block |
|---|
SELECT SELECTIVITY(First_name), SELECTIVITY(City) FROM Employee WHERE ROWNUM() < 2 |
...
| Code Block |
|---|
SELECT LOG(ID) FROM Employee
|
Example
| Code Block |
|---|
SELECT LOG10(ID) FROM Employee |
...
Converts a string to lowercase.
Example
| Code Block |
|---|
SELECT LOWER(Fname) FROM Employee |
...
Returns the location of a search string in a string. See also LOCATE.
Example
| Code Block |
|---|
SELECT POSITION('J', Fname) FROM Employee |
LPAD, RPAD
LPAD(string, int [, paddingString])
RPAD(string, int [, paddingString])
...