I would like to be able to export data from the grid in a way to resue that data as a WITH clause for a select statement.
Maybe with consideration of thie current NLS settings if any type conversions are needed.
WITH testdata (col1, col2, col3)
as (select date '2018-09-04', 1, 'Test row 1' from dual union all
select date '2018-09-04', 2, 'Test row 2' from dual union all
select date '2018-09-04', 17, 'Test row 3' from dual
if we then add
select * from testdata;
we can run this on any database and use it for easy data exchange and data testing.