Re: help with sql

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Fri, 07 Jul 2006 01:52:28 GMT
Message-ID: <Xns97F8C002C446Bianalvistahotmailcom@70.169.32.36>

"Brian (withholding surname)" <brianb000001_at_hotmail.com> wrote in news:1152184136.691073.115660_at_j8g2000cwa.googlegroups.com:

> Hi, I am using Java to query 10g database. I have table containing this
> information
>
> ID EMAILTO
> ---- ---------------------------------
> 1 Sangster, Derek; Williams, Mary G; Phillpot, Mark
> 17 Williams, Mary G
> 29 Cunningham, Peter; Richards; Peter
>
> I want to turn this into columns LASTNAME and FIRSTNAME
> 1 Sangster Derek
> 1 Williams Mary G
> 1 Phillpot Mark
> 17 Williams Mary G
> 29 Cunningham Peter
> 29 Richards Peter
>
> I am query database so can only use SQL and not procedures PLSQL. How
> can I do this? URGENT.

URGENT?
You can have the answer good, fast or free. Pick any two. Received on Thu Jul 06 2006 - 20:52:28 CDT