#1 - When exporting data from data grid 'Export Dataset' as 'Insert Statements' to clipboard, it's either putting a linefeed after the first column, even though the values are displayed correctly. e.g.
Insert into EMPLOYEES
(EMPLOYEE_ID,
FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE,
JOB_ID, SALARY, COMMISSION_PCT, MANAGER_ID, DEPARTMENT_ID)
Values
(202, 'Pat', 'Fay', 'PFAY', '603.123.6666',
TO_DATE('08/17/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_REP', 6000, NULL, 201,
20);
OR
#2 - If there are a more than 5 columns it puts all the columns on one line, but puts the values in blocks of 5
Insert into EMPLOYEES
(EMPLOYEE_ID, FIRST_NAME, LAST_NAME, EMAIL, PHONE_NUMBER, HIRE_DATE, JOB_ID, SALARY, MANAGER_ID, DEPARTMENT_ID)
Values
(202, 'Pat', 'Fay', 'PFAY', '603.123.6666',
TO_DATE('08/17/1997 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MK_REP', 6000, 201, 20);