17,092
社区成员
发帖
与我相关
我的任务
分享
-- 查询1:
11:18:52 SCOTT@tdwora > select rownum rn, t__.* from (
11:19:46 2 select e.deptno, e.ename, d.deptno, d.loc
11:19:46 3 from emp e, dept d
11:19:46 4 where e.deptno=d.deptno ) t__;
select rownum rn, t__.* from (
*
第 1 行出现错误:
ORA-00918: 未明确定义列
-- 查询2(将查询1中的子查询涉及到的两个同名字段 deptno去掉一个)
11:19:47 SCOTT@tdwora > select rownum rn, t__.* from (
11:20:11 2 select e.deptno, e.ename, d.loc
11:20:11 3 from emp e, dept d
11:20:11 4 where e.deptno=d.deptno ) t__;
RN DEPTNO ENAME LOC
---------- ---------- ---------- -------------
1 10 KING NEW YORK
2 10 CLARK NEW YORK
3 20 FORD DALLAS
4 20 ADAMS DALLAS
5 20 JONES DALLAS
6 20 SMITH DALLAS
7 30 BLAKE CHICAGO
8 30 MARTIN CHICAGO
9 30 WARD CHICAGO
10 30 TURNER CHICAGO
11 30 ALLEN CHICAGO
已选择11行。
CREATE TABLE test2(id NUMBER(5),name1 VARCHAR2(15));
CREATE TABLE test2(id NUMBER(5),name2 VARCHAR2(15));
SELECT * FROM test1,test2;
ID NAME1 ID NAME2
SELECT ROWNUM rn,t.* FROM
(
SELECT * FROM test1,test2
)t;
7 20 ORA-00918: 未明确定义列
Total execution time 0 sec.
${c.name} |
[@cms.ArtiList chnlId=c.id sysContent='1-1' titLen='20' count='6' /] |