transfering 1 column to several [message #8198] |
Sun, 03 August 2003 04:24 |
Stephen
Messages: 26 Registered: January 2000
|
Junior Member |
|
|
hy everyone, im having this problem
i am transferring data from one table to another table, but there is compatability issues, as in one table, this is contact which can have numerous amounts in, usually less than 3 people, for example
S Scott, Mr Scott Smith, Scott Smith
as you can see they are in different formats, but are always seperated by a comma, the above is only an example and can be different people
and i need to transfer it, into another table.
with title
inits
name
surname
as the requirements.
this one has me seriously stumped.
thanx
|
|
|
Re: transfering 1 column to several [message #8213 is a reply to message #8198] |
Mon, 04 August 2003 06:13 |
Shesh
Messages: 16 Registered: July 2003
|
Junior Member |
|
|
Can you please explain the problem in detail?
I am not getting the Problem.
According to me if I am right..
You are about to transfer data from one table to another and this can be done using..
SQL>Insert into table2 Select Col1,Col2... from table1;
Or If you want to create the second table then you can use
SQL> Create table2 as select Col1,Col2... from table1;
Hope this will help you
Thanx
Shesh
|
|
|