Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> help with sql
Hi, I am using Java to query 10g database. I have table containing this
information
ID EMAILTO
---- ---------------------------------
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.
Brian Received on Thu Jul 06 2006 - 06:08:42 CDT