Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> How to insert a space after each Manager Starts.
hi,
guys
i have query which given below output given below
manager personlevel person name
2085 1 Howard Wilson1 2085 2 Howard Wilson2 2085 3 Howard Wilson3 2085 4 Howard Wilson4 2085 5 Howard Wilson5 6086 1 Andrew Saxon 6086 2 Andrew Saxon 6086 3 Ian Thompson 6086 4 Ian Thompson 6086 5 Phil Dargan
what i want is after a manager ends i want a null to be inserted for
each of there columns
so that i can distinguish that when a new manager starts
so that output looks like this
manager personlevel person name
2085 1 Howard Wilson1 2085 2 Howard Wilson2 2085 3 Howard Wilson3 2085 4 Howard Wilson4 2085 5 Howard Wilson5 null null null 6086 1 Andrew Saxon 6086 2 Andrew Saxon 6086 3 Ian Thompson 6086 4 Ian Thompson 6086 5 Phil Dargan
Brlliant minds any solution for this..
i know can i loop through the records and do it
and check for a new manager
but i want a better solution ..
give me your ideads folks..
Regards,
Navin Mahindroo
Received on Mon Jun 30 2003 - 03:50:56 CDT