The problem which is saved my job and got appreciation for the solution...

3 months time....2 resources...i am the responsible person...already 2 clients failed to solve....everybody(Clients,PL,Colleague) thought that is cannot be done in specified time...finally it had come to me to solve it....That is 'Facility Obligor Relationship Problem'...

Initially i am also frustrated when it comes to me....but i took it as a challenge to solve it....First 5 days i did not do any thing even i did not code a single line....but my inner feeling says that there could be some simple solution ...next is week end..so i am planning to go to my friend's marriage...Friday night started and got into the bus...thinking about the problem whole night...at 5 o'clock suddenly i got a thought....but i cannot test it...but i am very much eager to test since my life is depend on that problem...in my return journey also i didn't get sleep bcoz very much eager to test the solution to such a gr8 problem.

Monday morning .....early get into the office bus .... on that day i am the first person to the office...Immediately logon to the system and checked the solution.....my face is glowing like a sun ...expected solution got it....i am very happy....immediately sent a mail to my onsite coordinator to confirm the solution....he confirmed immediately...Implemented the solution within next 5 days...remaining 80 days enjoyed with newly joined employee..Stayed in office hardly 5 hours ...finally got appreciation...delivered on time...entire team has got appreciation from clients....

Problem description

===============

The above relationship data is available in the Facility_obligor relation ship table in the following way.

Facility obligor

F1 O1

F2 O1

F2 O2

F3 O2

F4 O2

F4 O3

F4 O4

F5 O5

F6 O6

If I give input to the query either one F1 or F2 or F3 or F4, then I should get the all the related facilities and obligors which are in the above relational form.

Solution which i have given

=================

with graph as (

select facility as node_from,obligor as node_to from facility_obligor

union all

select obligor,facility from facility_obligor

)

select distinct node_from from graph connect by nocycle prior node_from = node_to start with node_from = 'F4' ;

I hope this is very much useful to everyone.