weixin_41126842的博客

grant select on TEST to user;-- 把TEST表的select权限授予给用户user(也就是另一个库)revoke select on TEST from user;--取消授权select * from DBA_TAB_PRIVS where TABLE_NAME ='TEST' and grantee= 'user';--查询权限

select sess.sid,sess.serial#,lo.oracle_username,lo.os_user_name,ao.object_name 被锁表对象名,lo.locked_mode 索模式,sess.login_time 登录数据库时间,'alter system kill session '''||sess.sid||sess.serial#||'''' freesqlfrom V#LOCKED_OBJECT LO,DBA_OBJECTS AO ,V#SESSION SE

执行计划一：explain plan set statement_id ='test1' into plan_table for …select operation,options,object_name,object_type,id,parent_id,position,cost,cardinality,cpu_cost,io_costfrom plan_table where statement_id='test1'执行计划二：explain plan set statemen

用union all可以实现列转行数据库列 ：ind_code , ind_name , data_d,data_m,data_y 111 收入 222 333 444现在要：111 收入 日 222 111 收入 月 333 111 收入 ...

select * from ( select zz.*,row_number() over(paritiion by zz.warnIndCode order by zz.warnLightTtpe asc) yn-- 上面为对指标进行分组，然后组内对灯类型进行升序排列，取组内第一个 from ( select * from ( ...

select * from (select h.* , row number() over(partition by h.group_id order by h.rule_code desc) rn from t_test h ) t where t.rn <=1

<if test="orgList !=null and orgList.size>0">and dept_code in<!--处理in的集合超过1000条时oracle不支持的情况--><trim suffixOverrides=" or dept_code in()"> <!--表示删除最后一个条件--> <...

select t.code from ( select p.plan_code code, p.plan_parent_code parentCode from t_plan where comments='comment' ) t start with code ='00' connect by prior code = parentCode...