Home » SQL & PL/SQL » SQL & PL/SQL » Urgent! IDEPTREE and DEPTREE
Urgent! IDEPTREE and DEPTREE [message #18956] Fri, 22 February 2002 13:44 Go to next message
Nhu N.
Messages: 1
Registered: February 2002
Junior Member
After I ran the utldtree.sql, there is no data in the deptree or ideptree tables. Anyone had this problem? Thanks for your help

Nhu
Re: Urgent! IDEPTREE and DEPTREE [message #18995 is a reply to message #18956] Mon, 25 February 2002 04:46 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
i think u r approaching in wrong way ,try this way

execute deptree_fill('procedure', 'scott', 'billing');
select * from deptree order by seq#;

OR
--
execute deptree_fill('table', 'scott', 'emp');
select * from deptree order by seq#;

OR
--
execute deptree_fill('package body', 'scott', 'accts_payable');
select * from deptree order by seq#;
Previous Topic: using variable as part of where clause
Next Topic: Top 20
Goto Forum:
  


Current Time: Sat Apr 20 05:58:21 CDT 2024