Batch Loading Your Oracle Database Cloud Services via the SQL Developer Command-Line Interface

thatjeffsmith SQL Developer 3 Comments

I recently talked about how to load up your Oracle Cloud service with your local data. In that scenario, you’re in the graphical user interface, clicking buttons, doing things more ad-hoc. But what if you wanted to build an automated process to load up data from an on-premise Oracle Database? You won’t have a GUI available then, so what’s available? …

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: …