兼容PostgreSQL风格的函数或者带有PACKAGE属性的函数支持重载。在指定REPLACE的时候,如果参数个数、类型、返回值有变化,不会替换原有函数,而是会建立新的函数。 不能创建仅形参名字不同(函数名和参数列表类型都一样)的重载函数。 不能创建与存储过程拥有相同名称和参数列表的函数。 不支持形参仅在自定义ref cursor类型...
CREATE SCHEMA CREATE SEQUENCE CREATE SERVER CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TABLE AS CREATE TABLE PARTITION CREATE TRIGGER CREATE TYPE CREATE USER CREATE VIEW CREATE WEAK PASSWORD DICTIONARY CURSOR DEALLOCATE DECLARE DELETE DO DROP AUDIT POLICY DROP CLIENT...
CREATE SCHEMA CREATE SEQUENCE CREATE SERVER CREATE SYNONYM CREATE TABLE CREATE TABLESPACE CREATE TABLE AS CREATE TABLE PARTITION CREATE TRIGGER CREATE TYPE CREATE USER CREATE VIEW CREATE WEAK PASSWORD DICTIONARY CURSOR DEALLOCATE DECLARE DELETE DO DROP AUDIT POLICY DROP CLIENT...
Syntax (compatible with PostgreSQL) for creating a user-defined function: CREATE [ OR REPLACE ] FUNCTION function_name ( [ { argname [ argmode ] argtype [ { DEFAULT | := | = } expression ]} [, ...] ] ) [ RETURNS rettype [ DETERMINISTIC ] | RETURNS TABLE ( { column_name column...
Syntax (compatible with PostgreSQL) for creating a user-defined function: CREATE [ OR REPLACE ] FUNCTION function_name ( [ { argname [ argmode ] argtype [ { DEFAULT | := | = } expression ]} [, ...] ] ) [ RETURNS rettype [ DETERMINISTIC ] | RETURNS TABLE ( { column_name column...