ThatJeffSmith

Category: General

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

What’s Wrong with this Create Table Statement?

I recently got this request for help via a YouTube video comment. I’m sharing it here, because I see this type of question A LOT. And it scares me. “When I run this script it reads = Error starting at line : 1 in command – What am I doing wrong? Before I show the […]

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

On Conferences and User Groups…on a Saturday?

I’m writing this at my departure gate in Denver, waiting for my flight home from the Training Days ’14 event hosted by the Rocky Mountain Oracle Users Group (RMOUG.) The RMOUG conference is the unofficial kick-off for Oracle conferences for the new year, and it’s one of my favorites. I helped put together a panel […]

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