Did you look instr,substr and to_char up in the docs? The name might be
problematic since some might have a middle name or a JR etc. Bad practice
to store names that way. Anyway you need to look up those functions in the
SQL Reference manual. (look in the table of contents, they are listed right
there.)
You can go to otn.oracle.com and sign up for free and have access to the
documentation and even down load it.
Jim
--
Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
with family. Remove the negative part, keep the minus sign. You can figure
it out.
"rishi" <richadha_at_hipusa.com> wrote in message
news:d1741a2f.0306100557.7c556527_at_posting.google.com...
> Folks
>
> I have to extract data from a table in the HR database.
>
> The columns in the table are Name, DOB, SS, STATUS and the data appears as
such:
> NAME DOB SS STATUS
> doe, john 01/01/77 11-11-1111 A
>
>
> The data needs to be placed in the following format:
>
> Last Name First Name Last 4 SS Month Year Status
> Doe John 1111 01 77 A
>
>
> The process needs to run every day.
> How can I get these results?
>
> Thanks in advance
Received on Tue Jun 10 2003 - 09:42:42 CDT
