Holy

由于Oracle varchar类型长度限制为4000 ,以下方法仅支持查询字段拼接后长度小于等于4000第一种方法select wm_concat(column_name)from user_tab_colswhere table_name = upper('T1PLCBASE')--表名--不想查询的字段名and column_name not in 'RNWPAYTODATE', 'A

-- 查询当前哪个表被锁select sess.sid, sess.serial#, lo.oracle_username, lo.os_user_name, ao.object_name, lo.locked_mode from v$locked_object lo, dba_objects ao, v$sessio

getdate()函数连接请戳这里create or replace function getcurrdate(i_date date)return date is v_date date; v_datestr varchar2(10);begin if i_date is null then v_date := sysdate; else

create or replace function dateToNumber(i_date in date)return numberis result number ;begin result := TO_NUMBER(NVL(TO_CHAR(i_date, 'J'), '0')); return result;end dateToNumber;

create or replace function numberToDate(i_date in number)return dateis v_date number; result date ;begin v_date := i_date; if v_date = 0 then v_date := null; e

create or replace function getdate(sp_date varchar) return date is Result date;begin if LENGTH(sp_date) =10 then Result:=to_date(sp_date,'YYYY-MM-dd'); end if; if LENGTH(sp_date) =8 then

create or replace function func_float(i_value float)return numberis v_index number := 0; v_str varchar2(1000); v_result number(20,5); v_int varchar2(100); v_dec varchar2(100);begin

create or replace function strFormatDate(i_datestr in varchar2)return dateisbegin if i_datestr is null or trim(i_datestr) = '' then return null; end if; return to_date(i_datestr,'yyyy-MM-d