Answer Detail: RE: Data Conversion

GeekInterview.com > Interview Questions > Oracle > SQL

Print |

Question: Data Conversion

Answer: Have 2 table Emp1 (Column Name: Ename), 2nd table Emp2 (Column Name: First and Column Name: Last

Table Name :Emp1
EName
Hunt, Michael
Graham, Smith
Nelson, Ryan

Table Name: Emp2
First Last
Michael Hunt
Smith Graham
Ryan Nelson

Need to write a SQL query to convert the data from Emp1 to Emp2 in this way.
Can any body help me.

Thanks

July 07, 2009 01:53:40	#9
Nehasinha	Member Since: July 2009 Total Comments: 2
RE: Data Conversion
CREATE TABLE emp3 AS SELECT * FROM emp2; DROP TABLE emp2; RENAME emp1 TO emp2; RENAME emp3 TO emp2;

Back To Question