菜鸟来问下ORACLE中怎么给一个视图加一个ID列，如何用rownum

Question

如题所述

Answer 1

SELECT ROWNUM rn,v.* FROM view_test v;
输出：
RN ID DEPTNO DNAME
1 1 20 RESEARCH
2 2 30 SALES
3 3 30 SALES
4 4 20 RESEARCH
5 5 30 SALES
6 6 30 SALES
7 7 10 ACCOUNTING
8 8 10 ACCOUNTING
9 9 30 SALES
10 10 30 SALES
11 11 20 RESEARCH
12 12 10 ACCOUNTING
13 13 20 RESEARCH

Answer 2

select rownum as id, 字段1，字段2 from 表

Answer 3

直接在建立视图的时候就可以加上啊