摘要:
一、创建视图 drop view srv_kims_zt_tablename;--删除视图避免重复 --创建视图开始 create or replace view srv_kims_zt_tablename as select z.id as column1, z.name as column2, 阅读全文
摘要:
一、Orcal存储过程语法 --定义存储过程开始 create or replace procedure pm_quotaresult_tablename( --定义入参 v_fundcode in varchar2, v_bendyeildid in varchar2, v_busidate in 阅读全文
摘要:
1、查找表中多余的重复记录,重复记录是根据单个字段(Id)来判断 select * from tablename where Id in (select Id from tablename group byId having count(Id) > 1) [and age > 10]; 2、删除表中 阅读全文