ThatJeffSmith

Viewing Complex Types in Oracle SQL Developer Data Modeler

Instead of having a column of type VARCHAR2 for a ‘Country,’ you might want to create an COUNTRIES type. Said COUNTRY would have an ID, NAME, and LOCATION. To make things even more fun, LOCATION would also be a custom type of LOCATIONS, having even more attributes/columns. To model these from scratch, you would build […]

3 More Oracle SQL Developer Bloggers

I’m on vacation this week – so in order to keep you folks entertained, I thought I would spotlight a few of our developers who also blog. Kris Rice Kris is one of the two original developers of SQL Developer. He’s also my boss, but don’t blame him for me. Lately, he’s been into all […]

Clearing the Script Output Buffer in Oracle SQL Developer

Quick Question: Is there a way in SQL Developer to have the DBMS Output window clear when you execute a block? Quick Answer: CLEAR SCREEN [Oracle Docs] SQL Developer supports many, and soon to be ALL, SQL*Plus commands. CLEAR is one of them. So just add this to the top of your script. When you […]

Off Topic: Some Advice on Submitting Conference Abstracts

I like to experiment and play with new shiny objects. LinkedIn recently added a blogging platform to their site. I’ve decided to publish a little thing on how to do a better job on writing abstracts for conferences. A few disclaimers: I’m no expert, but I write and review a TON of these Many people […]

Oracle Database 12c SQL Translation Framework: Fixing Bad SQL

One of the new Database 12c features is the SQL Translation Framework. Developed primarily to help customer migrate their 3rd party applications and databases to the Oracle stack, it also offers application DBAs an opportunity to substitute poorly performing SQL with their own custom SQL – without changing the application itself! Do I have your […]

My Favorite SQL Developer Data Modeler Features

I’m doing a talk on this very subject next week at ODTUG’s KScope14 conference, and I’ll put up the slides on Slideshare after the show, but I wanted to give a quick shout-out to the things you COULD Be using today to get the most out of your models and design experience. Search SubViews Reports […]

Configuring Memory Usage in Oracle SQL Developer

Sometimes you need more memory. Here’s an example: you want to model a database that has 1500 tables in it. What would that even look like? If you zoom out far enough… Now, ‘large’ is a subjective term. But lets put it this way – if you’re dealing with more than several hundred tables or […]

Managing Scripts in Oracle SQL Developer

You backup your databases, right? You backup you home computer – your media collection, tax documents, bank accounts, etc, right? You backup your handy-dandy SQL scripts, right? Ok, now that I’ve got your head nodding, I want to answer a question I get every so often: How can I manage my scripts in SQL Developer? […]

Oracle SQL Developer: Single Object Compare

There’s a nasty rumor going around that you can’t compare database objects and/or code in Oracle SQL Developer. So let’s put that to bed right now. First, here’s how to compare: PL/SQL to PL/SQL or a SQL statement to another SQL statement So now that that’s settled, why don’t we take a look at how […]

On SQL Developer and TNSNAMES.ORA

Tnsnames.ora [DOCS] is a configuration file for SQL*Net that describes the network service names for the databases in your organization. Basically, it tells Oracle applications how to find your databases. This post is just a quick overview on how to get SQL Developer to ‘see’ this file and define a connection. There’s only a single […]

Oracle SQL Developer is for Oracle Database

What is Oracle SQL Developer? Well, according to this document on OTN… What is SQL Developer? Date: May 2014 Oracle SQL Developer is the Oracle Database IDE. A free graphical user interface, Oracle SQL Developer allows database users and administrators to do their database tasks in fewer clicks and keystrokes. A productivity tool, SQL Developer’s […]

Oracle SQL Developer: Fetching SQL Statement Result Sets

Running queries, browsing tables – you are often faced with many thousands, if not millions, of rows. Most people are happy with looking at the first few rows. But occasionally you need to see more. SQL Developer doesn’t show you all records, all at once. Instead, it brings the records down in ‘chunks,’ or as-needed. […]

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