You want the create script for a table. You want the create script for ALL of your tables. You want the tablespace. But not the constraints. How do you configure this in our tools? SQL Developer: The Preferences & the Wizards Go to the preferences. Database, utilities, export. SQLcl: SET DDL HELP SET DDL SET DDL And now run the …
Exporting Multiple Tables to Multiple Excel Spreadsheets
We love getting enhancement requests from our users. A good deal of the development in SQL Developer is guided by what our users are asking for. It does pain me a bit though when someone asks for a feature what we already have. Example: We frequently have a requirement to export working data (especially for data modeling purposes) to spreadsheets. …
Exporting a PL/SQL Package Just the Way Monty Likes in SQL Developer
Got a quick question from my favorite President today. So basically, Monty was asking how to get a PL/SQL Package Spec & Body to: a single file with a SET DEFINE OFF with the schema prefix in the CREATE or REPLACE Now, there’s more than one way to get one or more objects in the database out to a file. …
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’ to cover things such as: …
Migrating Oracle SQL Developer Connections (with Passwords!)
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 …
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 subject: Viewing BLOBs as pictures …
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 and the next begins. A …
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 your query to only include …
