miss zheng

SELECT t.table_name, t.colUMN_NAME, t.DATA_TYPE || '(' || t.DATA_LENGTH || ')', t1.COMMENTSFROM User_Tab_Cols t, User_Col_Comments t1WHERE t.table_name = t1.table_name AND t.column_name = t1.column_name;

在传统数据库中，若遇到数据量大的情况下，临时使用，可以考虑使用物化视图进行操作。以下记录一下，物化视图的创建及刷新 、删除。. 物化视图的创建create materialized view BI_VIEW_TEST refresh force on demand start with sysdate nextto_date(concat(to_char( sysdate+1,'dd-mm-yyyy'),'06:00:00'),'dd-mm-yyyy hh24:mi:ss') assele.

https://blog.csdn.net/findmyself_for_world/article/details/49978279

--统计图（比例大于5，统计各类，比例小于5的则汇总统计值）select * from (select name, sum(rs) as rs, round(ratio_to_report(sum(rs)) over(), 5) * 100 as bl from (select *from test) agroup by name)wher...

select regexp_replace(mc,'（.+）','') from BI

1. trim()删除字符串两边的空格。2. ltrim()删除字符串左边的空格。3. rtrim()删除字符串右边的空格。4. trim('字符1' from '字符串2')分别从字符2串的两边开始，删除指定的字符1。5. trim([leading | trailing | both] trim_char from string)　从字符串String中删除指定的字符trim_ch...

1、括号前后内容截取substr(name,1,instr(name,'（')-1)select name,substr(name,1,instr(name,'-')-1) 前,substr(name,instr(name,'-')+1,length(name)-instr(name,'-')) 后 from xx2、将字段内容的括号去掉regexp_replace(na...

conn /as sysdbaselect password from dba_users where username='SCOTT';password------------------------------F894844C34402B67alter user SCOTT identified by values 'F894844C34402B67';

to_date(substr(sale_time, 1, 10),'yyyy-mm-dd')>= trunc(sysdate -7)另：oracle trunc函数源链接为:https://www.cnblogs.com/zfyouxi/p/5236336.htmlselect to_char(sysdate, 'yyyy-mm-dd h...

--创建oracle用户用户名与密码create user yhmidentified bytest;赋予权限grant dba to yhm;