业务 数据 安全

摘要： 1.查询普通行的数据所占空间:表:DIM_USAGE如表结构：create table DIM_USAGE( USAGE VARCHAR2(20), USAGE_NAME VARCHAR2(120))求所有记录行所占空间：select 3+vsize(USAGE)+1+nvl(vsize(USAGE_NAME),0)+1 from DIM_USAGE;2.查询含有 BLOB字段的空间大小select dbms_lob.getLength(ATTACHMENT_CONTENT)/1024 ||'KB' from TOP_ATTACHMENT_CONTENT a; 阅读全文

摘要： 一、将一条记录复制成多条相同记录select codefrom(select '001,002,003,004,005,' as code from dual)connect by level<=5;二、实现将一串字符转换成行记录select regexp_substr(code,'[^,]+',1,level) code,levelfrom(select '001,002,003,004,005,' as code from dual)connect by level<=5结果:code level001 1002 2003 300 阅读全文