MURALI KRISHNA
Member²
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
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