Error starting at line 1 in command:
SELECT * FROM
(SELECT u.*, ROWNUM AS NUM FROM
("SELECT * FROM JFORUM_POSTS p, JFORUM_POSTS_TEXT t WHERE p.POST_ID = t.POST_ID"
u )
WHERE NUM BETWEEN 1 and 20
Error at Command Line:3 Column:5
Error report:
SQL Error: ORA-00972: 标识过长
00972. 00000 -"identifier is too long"
*Cause:An identifier with more than 30 characters was specified.
*Action: Specify at most 30 characters.
SELECT * FROM
(SELECT u.*, ROWNUM AS NUM FROM
(SELECT * FROM JFORUM_POSTS p, JFORUM_POSTS_TEXT t WHERE p.POST_ID = t.POST_ID) u ) h
WHERE NUM BETWEEN 1 and 20
去掉双引号会出现这个
Error starting at line 1 in command:
SELECT * FROM
(SELECT u.*, ROWNUM AS NUM FROM
(SELECT * FROM JFORUM_POSTS p, JFORUM_POSTS_TEXT t WHERE p.POST_ID = t.POST_ID) u )
WHERE NUM BETWEEN 1 and 20
Error at Command Line:2 Column:12
Error report:
SQL Error: ORA-00918: 未明确定义列
00918. 00000 -"column ambiguously defined"
*Cause:
*Action:
我加了as u以后出现这个
Error starting at line 1 in command:
SELECT * FROM
(SELECT u.*, ROWNUM AS NUM FROM
(SELECT * FROM JFORUM_POSTS p, JFORUM_POSTS_TEXT t WHERE p.POST_ID = t.POST_ID) as u )
WHERE NUM BETWEEN 1 and 20
Error at Command Line:3 Column:84
Error report:
SQL Error: ORA-00907: 缺少右括号
00907. 00000 -"missing right parenthesis"
*Cause:
*Action:
SQL语句我看着貌似没错啊
最初由 kissmoon 发布
[B]SELECT * FROM
(SELECT u.*, ROWNUM AS NUM FROM
(SELECT * FROM JFORUM_POSTS p, JFORUM_POSTS_TEXT t WHERE p.POST_ID = t.POST_ID) u ) h
WHERE NUM BETWEEN 1 and 20 [/B]
Error starting at line 1 in command:
SELECT * FROM
(SELECT u.*, ROWNUM AS NUM FROM
(SELECT * FROM JFORUM_POSTS p, JFORUM_POSTS_TEXT t WHERE p.POST_ID = t.POST_ID) u ) h
WHERE NUM BETWEEN 1 and 20
Error at Command Line:2 Column:10
Error report:
SQL Error: ORA-00918: 未明确定义列
00918. 00000 -"column ambiguously defined"
*Cause:
*Action: