Hi,
I am using SQL Developer, Oracle 11g client
I need to export result of below query into a csv or excel file, issues is when I execute the query and do right click export, then if I select as excel, then it takes lot of time and sometimes sql developer gets hanged and when I do csv format, it takes around 50 minutes.
Row Count is more than 60 Lakh
I need to know, if there is any faster way, by which this can be achieved. As sometimes data count may exceed 10 Lakh also.
Result of below query needs to be exported.
select * from dcf_profile_ver_attr where profile_version_id in (select id from dcf_profile_ver where profile_id in (select id from dcf_profile where profile_type = 'Price'));
Thanks,
Abhishek