07 2020 档案
摘要:create table t_stat(a int,b int); insert into t_stat select mod(level,5),mod(level,3)+2 from dual connect by level<=200; 直接创建出200条记录出来 快速构建一个临时表出来 wit
阅读全文
摘要:-- 准备环境 create table t1(id int,name varchar2(100)); begin for i in 1001..10000 loop insert into t1 values(i,'china'||to_char(i)); end loop; commit; en
阅读全文
摘要:CREATE OR REPLACE FUNCTION LONG_TO_CHAR(uTABLE IN VARCHAR2,uID IN NUMBER) RETURN VARCHAR2 AS uVal VARCHAR2(32767); BEGIN SELECT DATA_DEFAULT INTO uVal
阅读全文