ThatJeffSmith

Tag: sqldev

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 […]

Oracle SQL Developer: Database Object Shortcuts?

An interesting question popped up on the forum, and I thought I’d share my ‘answer’ with you folks. I figure this is something a lot of folks do several hundred times a day – pulling up a frequently used database objects in the browser. The question: Is there a way to define a shortcut to […]

Oracle SQL Developer: What’s Next?

Software development never really stops. The development cycle is truly a circle. Once a release is ready, the developers don’t go on break awaiting orders. There’s always the next sprocket to build or widget to refactor. And so comes one of the best parts of my job: helping figure out what those widgets and sprockets […]

Oracle SQL Developer Data Modeler v3.3 is Now Available

Oracle’s free data modeling solution, Oracle SQL Developer Data Modeler, has been updated with the release of version 3.3. I’ve already previewed a few of the new features here, and I’ll continue to talk more about the latest and greatest features. You can see the full list of new features and download the tool on […]

Oracle SQL Developer Report: Tables By DataType

When I’m doing demonstrations of Oracle SQL Developer, I’m frequently asked about our support for datatypes like XML, BLOBS, Timestamp, etc. When I’m put on the spot like that, I have a tendency to forget that I already have tables setup for this. So I end up writing a query to find a table that […]

How to Create or Open a Data Model in Oracle SQL Developer

The Oracle SQL Developer family currently has two ‘SQL Developer’ branded products: Oracle SQL Developer Oracle SQL Developer Data Modeler Oracle SQL Developer is the database IDE and Oracle SQL Developer Data Modeler is our dedicated data modeling solution. Where it gets interesting is that the entire Data Modeler product also runs inside of SQL […]

Managing Table and Column Comments in Oracle SQL Developer

An interesting question came up on the ORACLE-L mailing list this morning regarding table comments: Just wanted to get a general opinion on using comments in the database. For example COMMENT ON COLUMN table.column “No comment”. Does anyone do this as a regular best practice? I would prefer to see this abstraction in a data […]

Four Oracle SQL Developer Preferences You Should Know

In an earlier blog post I listed my ‘Top 10 Preferences to Tweak…’ Instead of amending that to Top 14, I wanted to give a fresh and updated take on some features that directly impact productivity and data quality. After doing three customer calls in three consecutive days, I realized I was spending a lot […]

Why Can’t I See My Tables in Oracle SQL Developer?

Because you don’t have any tables. I hate to be the bearer of bad news, but you don’t actually ‘OWN’ any tables. What you mostly likely DO have are SYNONYMS that point to tables in a application schema. When you log on to Oracle, you are seeing this: The solution is simple! Enable Synonym Support […]

Locks and Killing Sessions in Oracle SQL Developer

Getting the Windows ‘busy’ hourglass cursor is sure to raise anyone’s blood pressure. Sometimes you’re left there waiting because a resource you’re attempting to access is already being used by someone else. So you get to WAIT. You are being BLOCKED because what you want is LOCKED. How can you see what the hold-up is? […]

Oracle SQL Developer Data Modeler: Using Displays…

…to Create Alternate Visual Presentations of your Diagrams Your data model tells a story, and we all learn as small children that the best stories have pictures – the more the better! There’s a reason I try to always have at least one picture in my blog posts – even adults are easily distracted. We […]

How to Plug vi into Oracle SQL Developer

Love vi? Prefer emacs? Want the power of the 80′s added to Oracle SQL Developer? You can do that via our External Tools feature. And you can even have SQL Developer throw over your open file into vi, edit it, save it, and refresh the buffer in the worksheet to reflect the file changes. Here’s […]