ThatJeffSmith

Category: Database Stuff

Dragging and Dropping Files into Oracle SQL Developer

There are many ways to open a file. File > Open is one, but apparently that’s too boring for many of our friends out there. For you new-fangled mouse people, let’s look at drag-and-drop. From the View > Files Panel Ok, But What About from Explorer or Finder Same difference, but there is one ‘trick’ […]

Finding Calculated View Columns

Imagine you have 300 or so views, and within those views, are a bunch of business rules. Like, we’re going to calculate someone’s salary as their salary + their (commission percent * sales). Now imagine your views, and their columns, aren’t documented. They’re not documented in the data model, and they’re not documented via the […]

More Column Copy Tricks in Oracle SQL Developer

I normally don’t blog on Sundays. But I was going through our Exchange, triaging your enhancement requests, and I found one that is ALREADY in the product. Actually I found a dozen or so that are already in the product, but I thought I’d talk about this one in particular. From Describe (Shift-F4) allow “Copy […]

SQL Developer Video Tutorial: Split Those Grids

I’ve talked about how to make your really long sections of code easier to navigate by splitting your editors, but did you know we can make it easier to browse your tables and views too? No? Watch the movie then, you have 2 minutes to spare, yes? And seriously, don’t do the April Fool’s prank […]

How To Version Control Your SQL Developer Data Modeler Designs

Today I want to talk about how to version control your Data Modeler designs with Subversion. Oracle SQL Developer Data Modeler is free. Subversion is free. So for no money, you can design your database objects, and version control them for one or more people. I’ve put together some slides for your enjoyment: Oracle SQL […]

SQL Developer 4.0 Patch Release Now Available

We actually have THREE patches for you: Oracle SQL Developer 4.0.1 Oracle SQL Developer Data Modeler Oracle REST Data Services, formerly Oracle APEX Listener, 2.0.6 Bug Fixes, Mostly SQL Developer had a few dozen or so bugs that have been addressed. A few major fixes of note include the new ASH/AWR stuff not working when […]

How to Start the PL/SQL Debugger

Starting the debugger CAN be as simple as hitting this button in Oracle SQL Developer: But But, you need to make sure of the following: You have compiled for debug You have the privs You have a breakpoint set OR you have set the debugger preferences to start with a ‘Step Over’ On Database 12c, […]

How I Setup SQL Developer to Look and Run

I do a lot of live presentations and demonstrations. I’m frequently asked, ‘why does your SQL Developer look that way?’ or ‘How can I make SQL Developer work that way?’ It’s all about the preferences (or options.) So here’s what you can do if you want to be like me. By the way, I can’t […]

Auto-Replace in Oracle SQL Developer?

I get this question every few months, and I got it again last week in Denver – How can we setup auto-replace in SQL Developer? If I accidentally type ‘form’ I want it to come out as ‘from’ for example. I’m not a huge fan of the IDE ‘automatically’ doing things with my editor text. […]

Introducing the OTN Developer Day Database 12c VirtualBox Image

If you’re looking for an already configured Oracle Database 12c environment with a database already setup and all the software you need to learn database programming, design, and administration concepts, then look no further: This Stuff is all FREE The virtualization software is VirtualBox – that’s free. And it runs on any OS, including Windows, […]

How to Open the Data Modeler in Oracle SQL Developer

You are using Oracle SQL Developer, and you want to create or open a design in the Data Modeler. How do you GET to the Modeler? Oracle SQL Developer Data Modeler is a standalone solution that is also shipped in SQL Developer as an extension. The user interface of the Modeler is folded into SQL […]