oracle sql
常用sql
竹蜻蜓vYv
努力使自己成为一个数据库大佬
展开
-
循环删除数据
--TB_VEHICLE_FAULT declare maxrows number default 500000; begin for i in 1 .. 50 loop delete from TB_VEHICLE_FAULT where FAULT_BEGIN_TIME < to_date(20190601, 'yyyy-mm-dd hh24:mi:ss') and rownum <= maxrows; commit; end loop;.原创 2020-07-06 10:58:23 · 609 阅读 · 0 评论 -
oracle 常用脚本
1.查看用户权限 setlinesize200; colprivs_typeformata10; colusernameformata20; coltable_nameformata35; colcolumn_nameformata25; colPRIVILEGEformata60; witht1as ( selectupper('bi...原创 2020-06-09 14:36:14 · 2134 阅读 · 0 评论