(1)//判断表是否存在
CREATE or REPLACE FUNCTION "PUBLIC"."F_IS_TABLE_EXIST"("V_TABLE_EN_NAME" CHARACTER VARYING(8000 CHAR)) RETURNS INTEGER
AS i_count int default 0;
begin
select count(1) into i_count from sys_tables t where upper(t.TABLENAME)=upper(v_table_en_name);
return i_count;
end;
//去除空格
CREATE or REPLACE FUNCTION "PUBLIC"."FUNC_S_TRIM"("TEMP_S" CHARACTER VARYING(8000 CHAR), "TABLE_NAME" CHARACTER VARYING(8000 CHAR) DEFAULT NULL, "S_CLOUMN_CODE" CHARACTER VARYING(8000 CHAR) DEFAULT NULL, "CODE" CHARACTER VARYING(8000 CHAR) DEFAULT NULL) RETURNS CHARACTER VARYING
AS clean_s varchar2(4000);
begin
clean_s := Trim(Replace(temp_s, ' ', ''));
Return(clean_s);
end;
(2)//判断字符串,是否为空
CREATE or REPLACE FUNCTION "PUBLIC"."F_STR_IS_EMPTY"("V_STR" CHARACTER VARYING(8000 CHAR)) RETURNS INTEGER
AS i_count int default 0;
begin
if v_str is null or v_str = '' then
i_count := 1;
else
i_count := 0;
end if;
return i_count;
end;
(3) Oracle新建系统表时,要求主键为32位uuid,猜测Oracle肯定会提供相关的函数。
翻阅相关文档,果然发现Oracle提供的函数 sys_guid() 用于获取32位uuid,简单使用为
select sys_guid() from dual;
该函数返回32位的uuid为大写,可以使用 lower(sys_guid()) 转为小写.