OraFAQ Forum: Forms » Hierarchical Query for Employee

Home » Developer & Programmer » Forms » Hierarchical Query for Employee (Developer 6I Database 10g window XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Hierarchical Query for Employee [message #410771]

Tue, 30 June 2009 03:30

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Hi i have 1 Table Employee

In employee i have code's which is

01 is Department Code
and 010001 is Employee Code

I need a Hierarchical Tree view like this

Any idea

Regards

Shahzaib Ismail

Report message to a moderator

Re: Hierarchical Query for Employee [message #411158 is a reply to message #410771]

Thu, 02 July 2009 03:26

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

oK DONE IT

Report message to a moderator

Re: Hierarchical Query for Employee [message #411258 is a reply to message #411158]

Thu, 02 July 2009 19:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

As a guide to others, please post your solution.

David

Report message to a moderator

Re: Hierarchical Query for Employee [message #411360 is a reply to message #410771]

Fri, 03 July 2009 04:25

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

I Alter my employee table and create one column
Catagory_id Then Right This code

And in ID i write the trigger when_validate_item

IF :ID <99 THEN 

	
	SET_ITEM_PROPERTY('CONTROL',ENABLED,PROPERTY_FALSE);

Elsif :Id >99 Then 	


:Block2.catagory_no := substr(:block2.Id,1,2);

END IF;

SELECT 1, LEVEL, name||' ('||to_char(id)||' )','',to_char(id) 
FROM py_emp 
CONNECT BY PRIOR id = catagory_id start with
id BETWEEN 01 AND 100

Regards

Shahzaib ismail

Report message to a moderator

Previous Topic:	Schedule the form execution
Next Topic:	Populating LOV with Like operator

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 08:18:28 CDT 2024