加载中
sql server 连续月

sql server 连续月

2017/06/10 11:36
26
highcharts

highcharts x,y坐标轴label Formatter

2016/01/18 10:47
48
oracle 中的 EXISTS

select TB.CREATOR from T_BUSINESS_001_MAIN tb where not EXISTS( select * from T_BASE_007_ACCOUNT t where t.ACCOUNT_ID=TB.CREATOR );...

2014/02/21 13:32
58
linux 下启动oracle数据库

linux 下启动oracle数据库

2014/01/11 11:38
123
oracle sql判断字符串是否相同

--后三位 和 前三位 比较 select t.REG_ADDRESS, t.REG_ADDRESS_DETAIL from T_COMMON_001_MAIN t where t.DATA_FROM=3 and t.REG_ADDRESS like '四川%' and substr(t.REG_ADDRESS,instr(t.R...

2014/01/02 21:14
1.1W
TO_DATE

SELECT count(*) FROM T_COMMON_001_MAIN T WHERE T.DATA_FROM = 3 AND ( T.APPROVAL_BEGIN_TIME >= "TO_DATE" ( '2013-12-18 00:00:00', 'yyyy-mm-dd hh24:mi:ss' ) OR T.APPROVAL_BEGIN_TI...

2013/12/18 13:36
9
exp/imp(导出/导入)

exp ccntbpm_kj/yiyangJtwz0726@CCNT62 file=d:\db_62_bak\ccntbpm_kj_62_20131114.dmp log=d:\db_62_bak\ccntbpm_kj_62_20131114.log imp userid=用户/密码 file=d:\db_62_bak\ccntbpm_kj_6...

2013/12/13 14:42
32
insert into 带连接,带截取的sql

select sys_guid(),"SUBSTR"(t.BUSINESS_ID, 1, 5) || '4',ROLE_ID,IS_LAW from T_SYS_007_BUSI_ROLE t where t.BUSINESS_ID like '__1_21';...

2013/11/27 16:32
29
不错的颜色,编辑器最适合

色调85,饱和度,123,亮度205

2013/11/26 20:51
48
被加锁的数据处理

--找到session select t2.username,t2.sid,t2.serial#,t2.logon_time from v$locked_object t1,v$session t2 where t1.session_id=t2.sid order by t2.logon_time; --把sid,serial#传进去然后...

2013/11/07 13:20
58
oracle权限

ccntbpm_kj grant select,delete,update,insert on 对象名 to ccntbpm; ccntbpm_pro drop synonym T_LAW_PROCESSAPPROVAL ; create synonym T_LAW_PROCESSAPPROVAL for ccntbpm_kj.T_LAW_PRO...

2013/10/24 17:36
17
oracle中的rownum

create table person(ID char(6), name VARCHAR2(100)); insert into person values('200001',‘徐一’); insert into person values('200002',‘李二’); insert into person values('20000...

2013/10/22 11:46
19
一个不错的execl简单教程

http://bbs.csdn.net/topics/390358967 如果有问题可尝试 下载poi以后解压,然后在环境变量中加入poi的bin路径

2013/09/13 12:00
12
指定列的顺序同时不破坏数据的步骤

--T_LAW_RULE ALTER TABLE T_LAW_RULE drop primary key; --删除主键 ALTER TABLE T_LAW_RULE MODIFY(ID NULL); --设为null ALTER TABLE T_LAW_RULE ADD(ID_TMP CHAR(32)); --添加一临时列 ...

2013/09/06 18:09
96
表字段信息

select tb1.代码,tb1.数据类型,tb2.comments "注释" from (select t.COLUMN_NAME "代码",t.DATA_TYPE||'('||t.DATA_LENGTH||')' "数据类型" from all_tab_columns t where table_name='T_SE...

2013/08/19 17:56
36
表结构的查询

select t.COLUMN_NAME "代码",t.DATA_TYPE||'('||t.DATA_LENGTH||')' "数据类型" from all_tab_columns t where table_name='T_SERVICE_064_SELBROKER';...

2013/08/19 16:59
33
oracle中的sql分页查询

java例: sb.append("select rownum row_no_nmb,sb3.*from(select sb2.*,rownum row2b from (").append(sql).append(")sb2)sb3 where row2b between ").append(begin).append(" and ").appen...

2013/07/29 11:33
64

没有更多内容

加载失败,请刷新页面

没有更多内容

返回顶部
顶部