- 浏览: 88626 次
- 性别:
- 来自: 南京
最新评论
-
aoyoo111:
很好谢谢以保存嘿嘿嘿嘿嘿嘿嘿
java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB -
cuisuqiang:
标题很新颖,可是没看懂说的什么
时间控件的设计
Mysql数据库,Oracle数据库分别取得年,月,日。 年月,年月日。
Mysql语句:
select substr(a.createtime, 1, 4) as statisticsName from defect1 a;
select substr(a.createtime, 1, 7) as statisticsName from defect1 a;
select substr(a.createtime, 1, 10) as statisticsName from defect1 a;
Oracle语句一:
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy') , to_char(a.createTime, 'yyyy')) cn where record > '1 ' order by statisticsID
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy-mm') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy-mm') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy-mm') , to_char(a.createTime, 'yyyy-mm')) cn where record > '1 ' order by statisticsID
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy-mm-dd') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy-mm-dd') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy-mm-dd') , to_char(a.createTime, 'yyyy-mm-dd')) cn where record > '1 ' order by statisticsID
select substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4) as statisticsID,
count(a.createTime) as record from defect1 a where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4)
Oracle语句二:
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 7) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 7) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,7),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 10) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 10) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,10),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
Mysql语句:
select substr(a.createtime, 1, 4) as statisticsName from defect1 a;
select substr(a.createtime, 1, 7) as statisticsName from defect1 a;
select substr(a.createtime, 1, 10) as statisticsName from defect1 a;
Oracle语句一:
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy') , to_char(a.createTime, 'yyyy')) cn where record > '1 ' order by statisticsID
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy-mm') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy-mm') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy-mm') , to_char(a.createTime, 'yyyy-mm')) cn where record > '1 ' order by statisticsID
select cn.statisticsID, cn.statisticsName ,cn.record as statisticsName from
( select to_char(a.solveTime,'yyyy-mm-dd') as statisticsID, count(a.createTime) as record ,to_char(a.createTime,'yyyy-mm-dd') as statisticsName from defect1 a
where 1=1 group by to_char(a.solveTime,'yyyy-mm-dd') , to_char(a.createTime, 'yyyy-mm-dd')) cn where record > '1 ' order by statisticsID
select substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4) as statisticsID,
count(a.createTime) as record from defect1 a where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4)
Oracle语句二:
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 4) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,4),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 7) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 7) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,7),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
select cn.statisticsID,statisticsName ,cn.record as statisticsName from
( select substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 10) as statisticsID, count(to_char(a.createTime,'yyyy-mm-dd')) as record,substr(to_char(a.createTime,'yyyy-mm-dd'), 1, 10) as statisticsName from defect1 a
where 1=1 group by substr(to_char(a.solveTime,'yyyy-mm-dd'),1,10),to_char(a.createTime,'yyyy-mm-dd') ) cn where record > '1 ' order by statisticsID
发表评论
-
误delete删除表数据
2014-07-24 19:53 965flashback table project_party ... -
使用alter语句修改表
2014-07-16 20:14 816alter table table_name add col ... -
Oracle 记录表名和表记录数
2012-12-06 09:39 804oracle那个系统表同时记录表名和表记录数的? selec ... -
创建数据表空间
2012-11-21 16:43 0create tablespace stbss data ... -
移动数据文件
2012-10-15 10:49 0方法一 1. 关闭数据库,利用os拷贝 shutdown i ... -
orcle数据库备份恢复
2012-09-13 11:43 0oracle数据库的备份与恢复: 在命令行方式下: 备份: ... -
oracle 基础操作
2012-06-21 12:15 01、创建表 CREATE TABLE students ( s ... -
Oracle 查看索引语句
2012-05-18 15:40 11571. 查询一张表里面索引 select * from use ... -
ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB
2012-04-27 15:44 23939紧接第上篇文章。 第一步:查看SQL语句。 修改语句成: se ... -
简单理解外连接
2012-04-27 11:26 0sql的高级查询有四种连接,分别是:等值连接,非等值连接,外连 ... -
java.sql.SQLException: ORA-00932: 数据类型不一致: 应为 -, 但却获得 CLOB
2012-04-26 20:00 16727select distinct a.id, ... -
MYSQL常用经典命令
2012-03-22 20:32 7961.停止mysql kill -9 `ps -ef | gre ... -
oracle 函数,存储过程语法格式
2012-03-19 14:37 0oracle 函数语法格式 CREATE OR REPLACE ... -
增删改字段SQL语句
2012-03-06 16:18 794第一句: 1.添加字段 alter table version ... -
简单时间
2011-12-06 10:59 0SELECT add_months(TRUNC(SYSDATE ... -
创建Oracle表空间
2011-11-28 10:06 01、先查询空闲空间 select tablespace_na ... -
ORA-01861: 文字与格式字符串不匹配(1)
2011-11-24 16:58 50671.条件查询主任务数据异常:ORA-01861: 文字与格式字 ... -
ORA-01861: 文字与格式字符串不匹配
2011-11-24 16:56 2639if(Utility.isNotEmpty(taskVo.ge ... -
服务器端转到测试平台,根据用户名不可查找,根据ID可以查找
2011-11-24 16:55 8041.条件查询主任务数据异常:ORA-01861: 文字与格式字 ... -
服务器端转到测试平台,根据用户名不可查找,根据ID可以查找
2011-11-24 15:42 682select * from sitepro_attr wher ...
相关推荐
SpringBoot+Mybatis+Atomikos+Mysql+Oracle 多数据源分布式事物后台搭建 完整demo包,直接下下来解压,数据库配成自己的库,表自己的表,修改下脚本直接跑,网上大把资料,没一个能直接用的,这里花了点时间稍做...
mysql以表级锁为主,对资源锁定的粒度很大,如果一个session对一个表加锁时间过长,会让其他session无法更新此表中的数据。 虽然InnoDB引擎的表可以用行级锁,但这个行级锁的机制依赖于表的索引,如果表没有索引,...
mysql oracle 阿拉伯数字转中文数字, 亲测可用.找了很长时间才找到,
用于web开发连接Oracle和mysql,网上很难找的,我花了很久时间才找到,一直收藏在电脑里!
各种数据库之间的转换工具,亲测,好用!简洁方便。节省好多时间
MYSQL培训经典教程(DOC) Oracle(PPT) Oracle培训资料(PPT) Oracle数据库精讲与疑难解析(PDF) Oracle PL SQL语言基础(EXE) Oracle_Errors.chm Oracle权限管理笔记.pdf SQL语法祥解.doc 高级数据库系统.pdf ...
Oracle10g分区常用的是:range(范围分区)、list(列表分区)、hash(哈希分区)、range-hash(范围—哈希分区)、range-list(列表—复合分区)。 Range分区:Range分区是应用范围比较广的表分区方式,它是以列的...
通过goldengate 在线对mysql进行实时迁移,缩短生产业务停机时间
Sqlserver、Oracle、MySql、PostgreSql、SqlLite常用数据库的对比 1、分页 2、时间函数 3、自增列 4、表名规范 5、字符串连接 6、变量定义 7、其它
mysql以表级锁为主,对资源锁定的粒度很大,如果一个session对一个表加锁时间过长,会让其他session无法更新此表中的数据。 虽然InnoDB引擎的表可以用行级锁,但这个行级锁的机制依赖于表的索引,如果表没有索引,...
使用jdbc连接数据库时需要使用到oracle和mysql的jar包.在这里打包上传给需要的朋友用一下
三大数据库常用时间类型总结
第一本专门为程序员编写的数据库图书 《程序员的SQL金典》 1.将子查询、表连接、数据库语法差异等用通俗...解决方案,同时学会MSSQLServer、MYSQL、Oracle、DB2 数据库不再是梦 4.国内第一本讲解开窗函数实际应用的图书
下面总结出MySQL转换Oracle的几点注意事项,希望对大家有所帮助。 1.自动增长的数据类型处理 MySQL有自动增长的数据类型,插入记录时不用操作此字段,会自动获得数据值。Oracle没有自动增长的数据类型,需要建立一...
此小组件适合表包含很多个字段情况,减少人工取字段时间,perl程序打包成exe可执行文件,大部分人都是用Perl写网站程序,是用它来开发应用程序。exe可以不用暴露他们的Perl源代码
这两个星期里一直都在忙于一件事儿,就是数据库的迁移问题。没有做的时候感觉这是一件十分轻松的事儿,可是等到实实在在去做去实现的时候,自己...这里我也是在网上找了一个现成的工具:oracletomysql,它是只能为我们
给出在this时区=other时区的日期和时间 SQL> select to_char(sysdate,'yyyy.mm.dd hh24:mi:ss') bj_time,to_char(new_time 2 (sysdate,'PDT','GMT'),'yyyy.mm.dd hh24:mi:ss') los_angles from dual; BJ_TIME ...
这是我前段时间写的一个分页,是用Jsp+Javabean+Servlet对Oracle 和Mysql分页
另外他们列出的这些区别有些是蛮有意义的,有些可能由于他们本人的MySQL DBA的身份,对Oracle的理解有些偏差,有些则有凑数的嫌疑. 但是总体上结合Baron Schwartz的列表可以让大家大概地了解到Oracle与MySQL的共同之处...
这是我最近这段时间以来所用过的各个数据库Oracle&Mysql&Sql2000-jar驱动包(全集)