ThatJeffSmith

Tag: csv

A Quick 4.1 Trick: SET SQLFORMAT

One of your favorite SQL Developer ‘tricks’ is the ability to pre-format query output. So instead of getting standard output back, maybe you want query results to come back as CSV. But using that requires you to add code to your existing SQLs. Maybe instead it would be cool to set the overall script output […]

Similar Posts by Subject Areas: , , ,

SQL Developer 4.1: Easier Excel Imports

The most read post on this site? ‘How to Import from Excel to Oracle with SQL Developer‘ – and it has been since I published it almost 3 years ago. People really like Excel. Or I should put it this way – Excel is the way information is shared in an organization. It makes no […]

Similar Posts by Subject Areas: , , , ,

Formatting Query Results to CSV in Oracle SQL Developer

You want to run a query or two against an Oracle database. You want to get the data back into a user-friendly and consumable format, such as a comma separated values file. You can do this in SQL Developer, VERY easily. You can watch the movie… …or read on – your choice! Quick ResultSet Exports […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,