发布时间：2014-02-10 13:14:37
select regexp_substr('1,2,3,4,5,6','[^,]+',1,rownum) remindId,1 remindTypefrom dual connect by rownum <=length('1,2,3,4,5,6')-length(replace('1,2,3,4,5,6',',',''))+1......【阅读全文】
发布时间：2013-11-18 11:42:25
问题create table abc(A int,B int) Select A,count(B) as total from ABC group by ASelect A,count(B) as total1 from ABC where B > 30 group by ASelect A,count(B) as totlal2 from ABC where B > 20 group by A如何合并这三个查询？得到一个查询结果：A,total,total1,total2解决方案：Select A,count(B) .........【阅读全文】
发布时间：2013-10-04 00:33:20
表t_users(用户)字段类型是否为空user_idnumberpkuser_namevarchar2(20) not nulluser_agenumbernot null.........【阅读全文】
发布时间：2013-10-03 01:00:11
备份分两大类：逻辑备份、物理备份。物理备份又分：冷备份、热备份。一、逻辑备份打开cmd.执行以下命令1.例如：exp system/12345@test file="d:/dfe/mydb.dmp";命令格式：exp /@ file="......【阅读全文】
