In the Save dataset module, If I check the Insert Statement Option, Export selected rows--- the results returned is the only first record selected replicated the number of rows selected.
The Insert Option Export selected rows is defective.
WORKAROUND:
Do not use the Insert Statement Option, Export selected rows.
If one deselects the Insert Option Export option, the entire is returned but at least it is not the same record for the amount of rows selected.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
How to reproduce:
1. Return a data set
2. Using the Shift-click select a block of data along with some rows
3. Export datasetâ?
4. Select Insert Statements
5. If one ticks the Insert Option Export selected rows the results returned is the ONLY first record selected replicated the number of rows selected. For example:
--SQL Statement which produced this data:
--
-- select * from emp
--
Insert into EMP
(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)
Values
(7369, SMITH, CLERK, 7902, TO_DATE(12/17/1980 00:00:00, MM/DD/YYYY HH24:MI:SS),
800, 20);
Insert into EMP
(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)
Values
(7369, SMITH, CLERK, 7902, TO_DATE(12/17/1980 00:00:00, MM/DD/YYYY HH24:MI:SS),
800, 20);
Insert into EMP
(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)
Values
(7369, SMITH, CLERK, 7902, TO_DATE(12/17/1980 00:00:00, MM/DD/YYYY HH24:MI:SS),
800, 20);
Insert into EMP
(EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, DEPTNO)
Values
(7369, SMITH, CLERK, 7902, TO_DATE(12/17/1980 00:00:00, MM/DD/YYYY HH24:MI:SS),
800, 20);
COMMIT;
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center