select * from (select * from bbs a where rownum<=10) minus (select * from bbs where rownum<=5)想从bbs表中查询第6条到第10条的记录,
却出现错误提示:非法使用Long数据类型,请问这是为什么?
却出现错误提示:非法使用Long数据类型,请问这是为什么?
解决方案 »
- 怎么解决IBM3850 x5/4*8核16线程CUP/64G内存/win2003 x64/安装oracle10g x64创建数据库时进度条不动
- 数据库 问题 大家帮忙看看 必有 重谢 着急
- ADO访问oracle存储过程返回结果集在调用_CommandPtr的Execute函数时报异常
- sql写法求助
- 高手请教
- 关于date类型存日期时间的问题
- 建立job出错
- 怎么样将excel的数据批量导入到oracl库里面哦(解决就送分,不够可以加,我分多)谢谢
- 请高手们帮忙写一条检索树形数据的sql语句,多谢。
- 100分求解,急!请大家帮忙
- 请教各位大侠一个SQL语句,想了很久也没想出来!!
- 这个sql server 的存储过程在 orcale 中怎么写啊
select * from bbs order by id desc)) e
where r between 6 and 10;
友情赠送以下(自己翻译):
LONG columns cannot appear in certain parts of SQL statements:
n GROUP BY clauses, ORDER BY clauses, or CONNECT BY clauses or with the
DISTINCT operator in SELECT statements
n The UNIQUE operator of a SELECT statement
n The column list of a CREATE CLUSTER statement
n The CLUSTER clause of a CREATE MATERIALIZED VIEW statement
n SQL built-in functions, expressions, or conditions
n SELECT lists of queries containing GROUP BY clauses
n SELECT lists of subqueries or queries combined by the UNION, INTERSECT, or
MINUS set operators
n SELECT lists of CREATE TABLE ... AS SELECT statements
n ALTER TABLE ... MOVE statements
n SELECT lists in subqueries in INSERT statements
Triggers can use the LONG datatype in the following manner:
n A SQL statement within a trigger can insert data into a LONG column.
n If data from a LONG column can be converted to a constrained datatype (such as
CHAR and VARCHAR2), a LONG column can be referenced in a SQL statement
within a trigger.
n Variables in triggers cannot be declared using the LONG datatype.
n :NEW and :OLD cannot be used with LONG columns.