oyprunner的专栏

刚开始表没有设置主键盘，后来要设置 多个字段作为主键 但是这几个字段的值有少部门是重复的，所以要找出重复的行。[code="sql"]三个设置为主键的字段：c_year，c_parent，c_name--找出重复的行select * from t_qq9_gdp t where rowid != (select max(rowid) f...

给表添加列和注释[code="sql"]-- Add/modify columns alter table TB_CONTACT_REC add C_INCOMING_CALL_PURPOSE VARCHAR2(2);alter table TB_CONTACT_REC add C_IS_TELESALES_BUSI varchar2(1);alter table TB_CONTA...

[code="sql"]select substr(('0' || Extract(MONTH from ins.t_end_date)), 2) || substr(('0' || Extract(DAY from ins.t_end_date)), -2), substr('0' || Extract(MONTH from ...

[b][size=medium]1 oracle分页的一种写法[/size] [/b][code="sql"]SELECT * FROM ( SELECT row_.*, rownum rownum_ FROM (...... ) row_ WHERE rownum ? [/code][b][size=medium]2 日期月日比较不用年（转换成字符串可直接进行 > < 比较）[/si...

[b][size=medium]1 数值型函数[/size][/b] abs:求绝对值函数,如:abs(?5) 5 sqrt:求平方根函数,如:sqrt(2) 1.41421356 power:求幂函数,如:power(2,3) 8 cos:求余弦三角函数,如:cos(3.14159) ?1 mod:求除法余数,如:mod(1600, 300) 100 ceil:求大于等于...

[code="sql"]declare begin for tttt in (select temp.c_id from (select cst.c_tci_id, max(ins.T_END_DATE) as endDate from tb_test_1 t1, tb_test_2 ...

[b][size=medium]1 exists && in [/size][/b] [code="sql"] --EXISTS的执行流程 select * from t1 where exists ( select null from t2 where y = x --可以理解为: for x in ( select * from t1 )...