SQL> select * from tb1; ID A B
---------- ---------- ----------
1 1 23
2 1 17
3 2 1
4 2 7
5 2 10
6 3 19
7 3 21
8 3 15
9 4 188
10 3 5
11 4 88
12 4 8812 rows selectedSQL> select * from tb1 where rowid<10;select * from tb1 where rowid<10ORA-00932: inconsistent datatypes: expected ROWID got NUMBER这个是怎么回事呢?我想取前10条数据,我用的scott用户,分配了sysdba权限。
---------- ---------- ----------
1 1 23
2 1 17
3 2 1
4 2 7
5 2 10
6 3 19
7 3 21
8 3 15
9 4 188
10 3 5
11 4 88
12 4 8812 rows selectedSQL> select * from tb1 where rowid<10;select * from tb1 where rowid<10ORA-00932: inconsistent datatypes: expected ROWID got NUMBER这个是怎么回事呢?我想取前10条数据,我用的scott用户,分配了sysdba权限。
select * from tb1 where rownum<10
select * from tb1 where rownum<10;