现在有一张表 dateA
字段有
Adate Bdate Cdate Ddate
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-29 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-29 2011-03-29 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-29 2011-05-29 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
表内信息如上,现在要将这张表的信息统一,Adate 统一为2011-06-15,Bdate统一为2011-09-15
Cdate统一为2011-12-30,Ddate统一为2012-01-30.请问谁能提供下SQL语句方法吗
字段有
Adate Bdate Cdate Ddate
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-3-31 2011-09-30 2011-5-31 2011-02-22
2011-03-29 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-29 2011-03-29 2011-05-30 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-29 2011-05-29 00:00:00 2011-2-22 00:00:00
2011-03-31 2011-03-30 2011-05-30 00:00:00 2011-2-22 00:00:00
表内信息如上,现在要将这张表的信息统一,Adate 统一为2011-06-15,Bdate统一为2011-09-15
Cdate统一为2011-12-30,Ddate统一为2012-01-30.请问谁能提供下SQL语句方法吗
解决方案 »
- oracl的存储过程
- oracle 启动问题
- 数据排序后,怎么样获取第一条,下一条,上一条,最末一条的记录?
- 想查询数据库中由用户自己建立的表的信息,该调用数据字典里面的什么?
- 超级新手,超级菜鸟,超级问题——登录到 Oracle Management Server ?
- oci调用存储过程的问题
- How Oracle Allocating Space in Tablespace
- 求一个sql,任意数目参数显示任意行,求大神指点
- PD逆向工程如何导入SQL表注释
- 谁能提供oracle10g 的补下
- 如何从日志中查找出哪个用户的做过了删除操作记录?
- 数据库插入5000行,第二天就事务回滚了,减少了2000行,怎么回事呢?如何解决呀?
adate = to_date('2011-06-05', 'yyyy-mm-dd'),
bdate = to_date('2011-09-15', 'yyyy-mm-dd'),
cdate = to_date('2011-12-30', 'yyyy-mm-dd'),
ddate = to_date('2011-01-30', 'yyyy-mm-dd');