Insertion Queries

Q: Insert Value in one table from another table ?
A: INSERT INTO insertion_tableName SELECT * FROM Existing_tableName
Note:: Be careful with column Name .
Q: Give me an Example of INSERT multiple value with using UNION ?
A: Example :
INSERT INTO USER_DETAIL(UID, FNAME, LNAME, EMAILID)
SELECT 1,'Navneeth','Naik','navneeth@kdmnn.com'
UNION
SELECT 2,'Amol','Kulkarni','amol@kdmnn.com'
UNION
SELECT 3,'Anil','Bahirat','anil@kdmnn.com'
UNION
SELECT 4,'Murthy','Belluri','murthy@kdmnn.com'