表是这样的,如下
ID,INDEX,HASH
0200010348,07,00631903116510018117
0200010348,08,00633003525103516121
0200010348,02,00564002925106834917
0200010348,03,00604103420402801123
0200010321,07,00545703020909917827
0200010321,08,00551702719812400823
0200010321,02,00546403919603816513
0200008690,08,00533104215503916320
0200010321,03,00558005421907435410
0200008690,07,00557907521203100023
0200008690,02,00519304622004517424
0200008690,03,00554803128903300822想变成这样的!ID,INDEX1,HASH1,INDEX2,HASH2,INDEX3,HASH3,INDEX4,HASH4
0200010348,07,00631903116510018117,08,00633003525103516121,02,00564002925106834917,03,00604103420402801123
0200010321,07,00545703020909917827,08,00551702719812400823,02,00546403919603816513,03,00558005421907435410
0200008690,07,00557907521203100023,08,00533104215503916320,02,00519304622004517424,03,00554803128903300822就是这样了,现在不知道怎么办了!!希望大家给人帮助!!
ID,INDEX,HASH
0200010348,07,00631903116510018117
0200010348,08,00633003525103516121
0200010348,02,00564002925106834917
0200010348,03,00604103420402801123
0200010321,07,00545703020909917827
0200010321,08,00551702719812400823
0200010321,02,00546403919603816513
0200008690,08,00533104215503916320
0200010321,03,00558005421907435410
0200008690,07,00557907521203100023
0200008690,02,00519304622004517424
0200008690,03,00554803128903300822想变成这样的!ID,INDEX1,HASH1,INDEX2,HASH2,INDEX3,HASH3,INDEX4,HASH4
0200010348,07,00631903116510018117,08,00633003525103516121,02,00564002925106834917,03,00604103420402801123
0200010321,07,00545703020909917827,08,00551702719812400823,02,00546403919603816513,03,00558005421907435410
0200008690,07,00557907521203100023,08,00533104215503916320,02,00519304622004517424,03,00554803128903300822就是这样了,现在不知道怎么办了!!希望大家给人帮助!!
解决方案 »
- 如何查谁执行了此sql
- 找不到文件夹 机器名 localhost
- 请教,多表分页查询语句性能问题
- 谁能告诉我 关键字PIPELINED是什么东西,干什么用的.
- 求一sql
- <救命啊,最後100分>我的用戶名/密碼是正確的,但卻提示(ORA01017:invalid username/password;login denied)
- *********一个特妖怪的查询问题(在线等待)*************
- 那位大虾帮个忙,帮我介绍两本oracle初学者入门的书!谢了!!!
- 新手请问关于存储过程的问题
- SQL> insrt into disconnect_cause values('10','正常结束');
- 触发器
- 请教在linux下安装oracle10g遇到的问题
自己搜索下行列转换,太多的回答了