Oracle Database Discussions

hi,
i want to extract the data from existing table and im using this query,

select insert into employee || chr(10)
|| (emp_id,emp_name||chr(10)
|| ,hire_date) || chr(10)
|| values (||to_char(emp_id)||,||chr(10)
||emp_name||,|| chr(10)
||to_date(||to_char(hire_date,mm/dd/yyyy)
||,mm/dd/yyyy),||chr(10))
from employee;

but it showing the error

SQL> @'D:\dml.txt'
select insert into employee || chr(10)
*
ERROR at line 1:
ORA-00936: missing expression


help me out to solve this

thank you

Edited by: 973363 on Nov 27, 2012 1:02 AM