Hi All i have a problem in writing a procedure in oracle
the scenario is like this

There is a source table which has Employee id and manager id And there is anothere reference table where we eill look for the gradenumber for the corresponding manager id
if it is less than 57 we have look for the managaer id for the referrring id and we have to do this thing recursively till we get the actual manager id.

and if the manager id is <=57 then isert a row in the target with the relation type = SUP(Supervisior) and start searching for the real manager id and then if the actula manager id ius found then insert a aorw in the target with the relation type = MGR(Managare)


C Chandra Guptan,►►
Software Engineer,
Datawarehousing Center.
Where There's A Will There's A Way ...

_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Information transmitted by this EMAIL is proprietary to iGATE Group of Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL immediately notify the sender at iGATE or [Email address protected]
and delete this EMAIL including any attachments
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Oracle LazyDBA home page