Excel Export and SQL Query

[JP Durandeau]

Hi,

I was hoping to be able to get the SQL query I have created with Excel when doing the export of a complex select. That was a functionality I was used to when I was using PL/SQL Developer back in v7.

I have not been using Oracle database for the last 6 years and only have a trial version of v12 for the time being.

I have checked in Preferences that I am exporting the SQL Query (and checked in the forum Files -> Format...)

Has something changed ? Is it due to a limitation of a trial version ?

Thanks in advance.

Jean-Pierre

 

[Marco Kalter]

The preference only applies to the "Copy to Excel" function when right-clicking on a result set. The "Export" functions do not include the SQL statement.