Bonjour
Mon souci est de faire une exportation de résultats de SQL developer vers Excel , est ce que c'est possible?
Je vous remercie d'avantage
Combien cela coûte-t-il au total ? Quelles aides apportent l'état et les acteurs du marché pour alléger cette charge non choisie ? Tous les détails sur Commentçamarche.net.
* Right-click the table name, EMPLOYEES, in the object tree view.
* Select Export.
* Select CSV. The Export Data window shows up.
* Click Format tab.
* Select Format as: CSV.
* Enter File as: \temp\MyTeam.csv.
* Click Columns tab.
* Check columns: FIRST_NAME, LAST_NAME, MANAGER_ID
* Click Where tab.
* Enter Where clause as: MANAGER_ID=100.
* Click Apply.
Your CSV file, \temp\MyTeam.csv, is ready. Open it, you will see:
"FIRST_NAME","LAST_NAME","MANAGER_ID"
"Gerald","Cambrault","100"
"Lex","De Haan","100"
"Alberto","Errazuriz","100"
"Adam","Fripp","100"
"Michael","Hartstein","100"
"Payam","Kaufling","100"
"Neena","Kochhar","100"
...
CSV files can be open by Microsoft Excel.
cité de http://dev.fyicenter.com/faq/oracle/oracle_introduction_sql_developer_4.php