Tag: export

Shopping for CSV with SQL Developer’s Cart

A friend of mine asked how he could generate CSV for 40 Oracle tables in Oracle SQL Developer. He could of course use Tools > Database Export to accomplish this. But, it was always the same 40 tables. And using the object picker in the wizard can get tedious, especially if it’s the same 40 […]

Similar Posts by Subject Areas: , , , ,

30 SQL Developer Tips in 30 Days, Day 8: Use the Cart to Build Deployment Scripts

Let’s say you have some objects you need to quickly create somewhere else. And you want to it such that it can be scripted/scheduled. I am using the Cart right now to build out a demo environment for folks that want to show off some SQL Developer features. For instance, I’m building a ‘shopping list’ […]

Similar Posts by Subject Areas: , , , ,

Migrating Oracle SQL Developer Connections (with Passwords!)

So you just got your brand new machine at work. Party time, excellent*! Widgets And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer. But when you go to use it, none of your connections are there. Or maybe the connections are there, but the connection passwords ARE […]

Similar Posts by Subject Areas: , , , ,

Exporting Multiple BLOBs with Oracle SQL Developer

BLOBs are cool. Optimized such that you can store files basically in the database, with the power of SQL AND no performance hit. That sounds like a pretty good deal. I get asked questions a lot about accessing BLOBs once they’re in the database. And that’s led to quite a few posts here on the […]

Similar Posts by Subject Areas: , ,

SQL Developer: Preferences for Delimited Text Exports

Yes, it’s true. Some people export their data to formats other than Excel. Another popular format is ‘delimited,’ where fields are defined by a delimiter. The most famous of these is CSV, a comma separated values file. So your data can be read by another program quite easily because it knows where one field stops […]

Similar Posts by Subject Areas: , , , ,

Copying Columns from Grid to Clipboard in SQL Developer

There are several ways to get data from a query or a table|view to the clipboard. You know the tried and true, copy and paste. But what if you only want one or more columns, not every column? There are several ways to do this, let’s see if we can’t identify all of them. Write […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , , , ,