-- Copyright © Oracle Corporation 1995-1996. All Rights Reserved.
print 'Copyright © Oracle Corporation 1995-1996. All Rights Reserved.';
set dialect 'SQLV40';
DROP MODULE Rdb$ORACLE_SQLFUNC_CHAR;
DROP MODULE Rdb$ORACLE_SQLFUNC_OCTET;
-- Rdb SQL functions fashioned after Oracle SQL functions:
-- Number functions:
DROP FUNCTION ABS;
DROP FUNCTION CEIL;
DROP FUNCTION COS;
DROP FUNCTION COSH;
DROP FUNCTION EXP;
DROP FUNCTION FLOOR;
DROP FUNCTION LN;
DROP FUNCTION LOG;
DROP FUNCTION MOD;
DROP FUNCTION POWER;
DROP FUNCTION ROUND;
DROP FUNCTION SIGN;
DROP FUNCTION SIN;
DROP FUNCTION SINH;
DROP FUNCTION SQRT;
DROP FUNCTION TAN;
DROP FUNCTION TANH;
DROP FUNCTION TRUNC;
-- Character functions returning character values:
DROP FUNCTION CHR;
-- Character functions returning number values:
DROP FUNCTION Rdb$VARCHAR_TO_ASCII;
-- Other functions:
DROP FUNCTION HEXTORAW;
DROP FUNCTION RAWTOHEX;
DROP FUNCTION Rdb$IS_DEC_MCS_ALPHANUM;
 drop domain Rdb$ORACLE_SQLFUNC_VCHAR_DOM;
drop domain Rdb$ORACLE_SQLFUNC_DATE_DOM;
drop domain Rdb$ORACLE_SQLFUNC_DEC_MCS_DOM;
set dialect 'ORACLE LEVEL1';
print '%Info: Your SQL dialect is now Oracle Level1';
commit;