Software Developer Diary
Thursday, April 26, 2012
how to export data into excel from oracle sql developer 3.0.04
Retrieve the data you need with the select statement.
Select all the required data.
Right click and then you can find the export button.
Select the xls for excel sheet and then follow the instructions.
The path where you have saved the sql file will give you the exported table data.
How to select 'n' number of rows in oracle?
Use this query,
select * from table_name where rownum < 'n';
table_name is your table name.
'n' is number of rows you want to retrive.
Newer Posts
Older Posts
Home
Subscribe to:
Comments (Atom)