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

thatjeffsmith SQL Developer 7 Comments

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’ to cover things such as: …

Migrating Oracle SQL Developer Connections (with Passwords!)

thatjeffsmith SQL Developer 68 Comments

So you just got your brand new machine at work. Party time, excellent*! Amazon.com 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 not. And really, who has …

SQL Developer: Preferences for Delimited Text Exports

thatjeffsmith SQL Developer 19 Comments

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 and the next begins. A …