Hi SQL Dev Gurus
I read that is posible to extend SQL Dev to add new features, so I present my case for an extension:
Many times I need a small dataset brought from tables in one schema to be used in another.one.
With many schemas and diverse level of access to them (select at least), create multiple dblinks is not an option.
So I use that I call an export as select from dual. Here an example:
I have a given query that dump this:
CODE DESCRIPTION
1134 REPORT ABCD
1254 REPORT JKLM
2568 REPORT PQRS
I need to generate a single SQL statement that dumps the same stuff, something like:
select '1134' as code, 'REPORT ABCD' as description from dual union
select '1254' as code, 'REPORT JKLM' as description from dual union
select '2568' as code, 'REPORT PQRS' as description from dual;
Then just copy/paste this SQL statement in the "another" schema and voilà!. The dataset can be used.
So here comes the question: Can I extend SQL Dev in some way to get this script from result grid?
Thanks in advance
Oscar
PS: I think this export as select from dual could be a nice option in export wizard