Oracle 10g：在视图中对同级进行排序

发布于 2024-11-15 12:45:00 字数 623 浏览 4 评论 0 原文

是否可以在视图内添加 ORDER SIBLINGS BY fieldName？我有一个层次结构，在其中我成功地使用了具有 CONNECT BY 功能的查询。

然而，当我在视图定义中添加 ORDER SIBLINGS BY fieldName 时，Oracle 给出了一个奇怪的括号错误。

drop view myview;
create view myview as (
select id, level as depth, label, parentid, orderhint, 
       connect_by_root myfield1 "myfield1", connect_by_root id "toplevelparentid"
  from mytable
  connect by prior id = parentid
  start with id in (select id from mytable where parentid is null)
  order siblings by orderhint
);

如果没有 ORDER SIBLINGS BY 或在视图定义之外，它就像一个魅力。否则，我得到：

ORA-00907: 缺少右括号

原文

Is it possible to add a ORDER SIBLINGS BY fieldName inside a view?
I've got a hierarchical structure, in which I'm successfully using a query with the CONNECT BY feature.

However, when I add the ORDER SIBLINGS BY fieldName inside the view definition, Oracle gives a strange parenthesis error.

drop view myview;
create view myview as (
select id, level as depth, label, parentid, orderhint, 
       connect_by_root myfield1 "myfield1", connect_by_root id "toplevelparentid"
  from mytable
  connect by prior id = parentid
  start with id in (select id from mytable where parentid is null)
  order siblings by orderhint
);

Without the ORDER SIBLINGS BY or outside a view definition it works like a charm. Otherwise, I get:

ORA-00907: Missing right parenthesis

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

烟织青萝梦 2024-11-22 12:45:00

您是否尝试过删除括号：

drop view myview;
create view myview as
select id, level as depth, label, parentid, orderhint, 
connect_by_root myfield1 "myfield1", connect_by_root id "toplevelparentid"
from mytable
connect by prior id = parentid
start with id in (select id from mytable where parentid is null)
order siblings by orderhint;

Have you tried removing your parentheses:

drop view myview;
create view myview as
select id, level as depth, label, parentid, orderhint, 
connect_by_root myfield1 "myfield1", connect_by_root id "toplevelparentid"
from mytable
connect by prior id = parentid
start with id in (select id from mytable where parentid is null)
order siblings by orderhint;

回复收藏 0 原文

~没有更多了~