update person set height = '171m' where rownum < 501;
update person set height = '175m' where height <> '171m' and rownum < 501;
update person set height = '173m' where height <> '171m' and height <> '175m';
update person set height = '175m' where height <> '171m' and rownum < 501;
update person set height = '173m' where height <> '171m' and height <> '175m';
解决方案 »
- mysql用select into给变量赋值出错
- 关于oracle中database link(数据库链接)的问题~~~~~
- pl sql 操作超大字符串
- ORACLE 锁等待问题,急(在线等)
- Oracle启动问题
- 为什么select to_date(sysdate) from table1可以但select to_date(sysdate, 'yyyy-MM-dd hh24:mi:ss') from table1 报错
- 删除记录
- 问一根据范围不同取不同值的查询sql!
- 请问哪里有glibc-2.1.3-stubs.tar.gz下载
- asp.net 连接 oracle 11g 64位(windows 平台)
- 日期格式转化问题,急啊!
- 请问,谁知道ORACLE9i的用户名和密码?
update person set height='175m' where height is null and rownum <= 500;
update person set height='173m' where height is null and rownum <= 500;
update person set height = '175m' where height <> '171m' and rownum < 501;