ThatJeffSmith

Tag: tips

Stupid Copy & Paste Tricks

The Late Show with David Letterman used to have a bit called, ‘Stupid Pet Tricks.’ I quit watching because I prefer his Scottish and funnier future-replacement, Craig Ferguson. But I will take advantage of some Google-Fu to drive some traffic to ye olde blog (can you tell I’m in the UK this week?) So most […]

Similar Posts by Subject Areas: , , ,

SQL Developer: Tastes Great, Less Filling?

The ‘Holy Grail’ of software tools is the environment where things are made easy, but not at the expense of usability or simplicity. You use a tool because it makes something ‘easier’, but some software products are anything but. SQL Developer is fairly scaled down. You have a few toolbars, several menus, and 2 driving […]

Similar Posts by Subject Areas: , , ,

SQL Developer Quick Tip: Pretty It Up a Bit

No, not your code. I want you to take a quick look at the visual preferences for SQL Developer. In an earlier post I pontificated on the top 10 options to tweak before starting to use SQL Developer. Now once you have the tool operating the way you want, I think it’s time to make […]

Similar Posts by Subject Areas: , ,

RMOUG’s Training Days Conference

On February 14-16, I’ll be at the Colorado Convention Center in Denver, Colorado for RMOUG’s Training Days Conference. This is the largest regional Oracle User Conference in North America and attracts presenters from all around the country and the globe. I’ll be presenting: Presentation Name: SQL Developer Tips and Tricks for Developers Abstract: You use […]

Similar Posts by Subject Areas: ,

SQL Developer Quick Tip: GOTO in the Schema Browser

It’s a relational database, so it’s only a matter of time before you stumble across an object that’s dependent on another object, right? If you are looking at a table in the browser, be sure to check out the ‘Dependencies’ page. This page displays the database objects that will be upset if the selected table […]

Similar Posts by Subject Areas: ,

Scheduling Jobs with Oracle SQL Developer

DBMS_SCHEDULER is awesome. It’s flexibility is remarkable. From setting up execution windows to remote execution to automatic notifications, there is a LOT to like. That doesn’t mean it’s perfect. For developers and DBAs, it can be a real pain to type out 2000+ characters to simply create a job. Being able to have such a […]

Similar Posts by Subject Areas: , , , ,

SQL Developer Quick Tip: BLOBs and Images

Binary Large Objects – otherwise known as BLOBs. You’ve also got large objects which are composed of text – that would be a CLOB. If you hear people talk about LOB storage, they are referring to how the data in these fields are stored – outside the space reserved for the regular segments (table data.) […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: , ,