Direct query export

I want to export resultant data directly into the either(.csv,.tsv,html,xml)one of these files

but my problem is
i open the sql window but first time i didnt find any EXPORT QUERY RESULT option (it is in result set toolbar)because i didn't execute any query
now i execute
select * from emp;
it gives result grid
now i type
select * from dept; now i select this query only and then EXPORT QUERY RESULT option
and then i choose file type to export

but that file contain emp table data not dept table data
eventhough i select select * from dept query before select
EXPORT QUERY RESULT option

can any one send solution to this.......

thanks in advance

 
Before executing the query, the "Export Query Results" button is available to the right of the SQL Editor, below the history navigation buttons.
 
Back
Top