有如下表:
create table temp_order (col1 int,col2 varchar(10))
insert into temp_order values ('1','A')
insert into temp_order values ('3','B')
insert into temp_order values ('4','C')如何得到
1 A
2
3 B
4 C
create table temp_order (col1 int,col2 varchar(10))
insert into temp_order values ('1','A')
insert into temp_order values ('3','B')
insert into temp_order values ('4','C')如何得到
1 A
2
3 B
4 C
解决方案 »
- oracle exp问题
- 在线等啊,高手进来啊!~
- 救命: can bind a LONG value only for insert into a LONG column
- 在VMware下的SUSE Linux上安装Oracle问题
- 初学者求教CSDN大哥指点该段存储过程的解释,非常感谢!
- ORACLE导入表的问题?
- 请问这样的SQL如何实现
- 为什么select * from table1 where ''='' 和select * from table1 where ''<>''都不返回数据呢
- oracle9改不了字段---开始是用了小写字作字段名现在改成大写才行
- oracle11g客户端的安装问题,来个大神帮帮忙。万分感谢
- 在公司遇到一个特别刁钻的需求,一起来围观
- 数据备份问题
---------- --------------------
1 A
3 B
4 C已选择3行。16:26:00 SCOTT@myora >
16:26:00 SCOTT@myora > with a1 as (select level c1
16:26:00 2 from dual t1
16:26:00 3 connect by level<=(select max(col1) from temp_order))
16:26:00 4 select a1.c1 as col1, a2.col2
16:26:00 5 from a1 left join temp_order a2 on a1.c1=a2.col1
16:26:00 6 order by a1.c1; COL1 COL2
---------- --------------------
1 A
2
3 B
4 C已选择4行。16:26:01 SCOTT@myora >
select rownum col1 , col2 from temp_order where rownum=temp_order.col1
SELECT 1,'A' FROM DUAL
UNION ALL
SELECT 3,'B' FROM DUAL
UNION ALL
SELECT 4,'C' FROM DUAL
)
SELECT t2.rid, nvl(t1.col2,' ') FROM TEMP_ORDER T1 RIGHT JOIN (SELECT ROWNUM rid FROM DUAL CONNECT BY ROWNUM<5) t2 on t1.col1 = t2.rid order by t2.rid asc;
CREATE TABLE temp_order
(col1 INT,col2 VARCHAR(10)
);
INSERT INTO temp_order VALUES
('1','A'
);
INSERT INTO temp_order VALUES
('3','B'
);
INSERT INTO temp_order VALUES
('4','C'
);
COMMIT;SELECT t1.col1,
temp_order.col2
FROM temp_order
RIGHT JOIN
(SELECT rownum AS col1 FROM dual CONNECT BY rownum < 5
) t1
ON temp_order.col1 = t1.col1
ORDER BY t1.col1;