delcare
rg_id recordgroup;
begin
rg_id := create_group_from_query
('alpha','select 1, level, ename, null, to_char(empno) '
|| ' from emp where deptno= '
||:control.dno
||' connect by prior empno= mgr '
|| ' start with job=''PRESIDENT''');
v_ignore := populate_group(rg_id);
Ftree.set_tree_property(htree,Ftree.record_group,rg_id);
delete_group(rg_id);
end;请问:每一句语句的意思?
rg_id recordgroup;
begin
rg_id := create_group_from_query
('alpha','select 1, level, ename, null, to_char(empno) '
|| ' from emp where deptno= '
||:control.dno
||' connect by prior empno= mgr '
|| ' start with job=''PRESIDENT''');
v_ignore := populate_group(rg_id);
Ftree.set_tree_property(htree,Ftree.record_group,rg_id);
delete_group(rg_id);
end;请问:每一句语句的意思?
start with --表示从哪个结点或哪些结点开始进行层次遍历其它的子句与普通查询中的相应子句的含义一致。