刘娜

问题：win7系统，配置oracle的net manager保存出错。问题截图：1、错误提示：Error writing entry to local tnsnames.ora file [img]http://dl.iteye.com/upload/attachment/511724/81a21ef5-4c8a-32d2-8852-051fd85f0d8c.j...

Database character set (AL32UTF8) and Client character set (ZHS16GBK) are different.Character set conversion may cause unexpected results.Note: you can set the client character set through the N...

[b]日期转换[/b][code="java"]update promotion set end_time=to_date('2010-10-15 23:59:59','yyyy-MM-dd HH24:mi:ss') where id=33151[/code][code="java"]select * from kyds_vote v where v.createtime>to_dat...

1.先写一个sql语句，查出你需要的数据。[code="java"]select pin,name,mobile,email from pp_customer cwhere c.name is not null and c.email is not nulland c.pin is not null and c.mobile is not null and rownum < 2001[...

oracle 取当前日期时间的前一天前一小时前一分钟前一秒[url]http://wentao365.iteye.com/blog/779492[/url][code="java"] select from YESKY_APP_DOWNLOAD where CREATE_TIME > sysdate-(3/24/60/60) and ip = #ip#[/c...

分组排序取第一条[code="java"]SELECT soft_id,cn_name,packagename,version,version_code FROM (SELECT ROW_NUMBER() OVER(PARTITION BY packagename ORDER BY version_code DESC) LEV, t.*...

今天在调试代码时出现了下面的bug： ORA-00913: too many values经查是一个INSERT语句的错误：VALUES后面的插入的数据比前面的字段名多了一个，所以才出现了所谓的“too many values”错误。...