Kbase P112000: Which functions exist on SQL-92 ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/12/2005 |
|
Status: Unverified
GOAL:
Which functions exist on SQL-92 ?
GOAL:
List of SQL-92 functions
FIX:
SQL-92 Aggregate Functions
AVG Function
COUNT Function
MAX Function
MIN Function
SUM Function
SQL-92 Scalar Functions
ABS Function
ACOS Function
ADD_MONTHS Function
ASCII Function
ASIN Function
ATAN Function
ATAN2 Function
CASE Function
CAST Function
CEILING Function
CHAR Function
CHR Function
COALESCE Function
CONCAT Function
CONVERT Function
COS Function
CURDATE Function
CURTIME Function
DATABASE Function
DAYNAME Function
DAYOFMONTH Function
DAYOFWEEK Function
DAYOFYEAR Function
DB_NAME Function
DECODE Function
DEGREES Function
EXP Function
FLOOR Function
GREATEST Function
HOUR FUNCTION IFNULL Function
INITCAP Function
INSERT Function
INSTR Function
LAST_DAY Function
LCASE Function
LEAST Function
LEFT Function
LENGTH Function
LOCATE Function
LOG10 Function
LOWER Function
LPAD Function
LTRIM Function
MINUTE Function
MOD Function
MONTH Function
MONTHNAME Function
MONTHS_BETWEEN Function
NEXT_DAY Function
NOW Function
NULLIF Function
NVL Function
PI Function
POWER Function
PREFIX Function
PRO_* Functions
QUARTER Function
RADIANS Function
RAND Function
REPEAT Function
REPLACE Function
RIGHT Function
ROUND Function
ROWID Function
RPAD Function
RTRIM Function
SECOND Function
SIGN Function
SIN Function
SQRT Function
SUBSTR Function
SUBSTRING Function
SUFFIX Function
SYSDATE Function
SYSTIME Function
SYSTIMESTAMP Function
TAN Function
TO_CHAR Function
TO_DATE
TO_NUMBER Function
TO_TIME Function
TO_TIMESTAMP Function
TRANSLATE Function
UCASE Function
UPPER Function
USER Function
WEEK Function
YEAR Function