ThatJeffSmith

Tag: oracle

SQL Developer: Give me a Google Translator for SQL!

So you’re in Tweetdeck and someone mentions you in Portuguese or Swedish. You have no idea what it says, but you’re pretty sure it’s not a compliment. Thank goodness there’s the one-click ‘translate’ feature to bail you out. It’s often saved me from my elementary Spanish. How many times have you used Google’s translation services […]

Similar Posts by Subject Areas: , ,

Visualize Spatial Data with SQL Developer

Spatial data in its raw format is ugly. The shapes and places it represents can be very enlightening. Here’s some raw spatial data followed by their visualization. If you worked with spatial data, what would you prefer? You can probably figure out what you’re looking at, but wouldn’t it be nice if you could get […]

Similar Posts by Subject Areas: ,

SQL Developer Tip: Viewing REFCURSOR Output

If you work with PL/SQL, then this feature might be the #1 reason I recommend you immediately upgrade to at least version 3.0 of Oracle SQL Developer – SQL Developer now automatically renders SYS.REFCURSOR output from your PL/SQL calls. Prior to version 3.0, you needed to use the SQL*PLUS PRINT command to view the refcursor […]

Similar Posts by Subject Areas: , , ,

Simple Bar Chart Reports with SQL Developer

There are many good articles out there that go into detail for creating reports with Oracle SQL Developer. I was reading my predecessor’s write up in Oracle Magazine (May 2007) on the subject, and keyed into the following snippet: Building a Chart When creating a report with the Chart style, the rule of thumb is […]

Similar Posts by Subject Areas: , , ,

SQL Developer does XML

If you’re looking for insight or guidance on XML, XML in the database, or XMLDB – then please keep looking. I have not much to add here. What I am here to talk about is some of the support that SQL Developer offers for XML in the database. You may have heard me say ‘I […]

Similar Posts by Subject Areas: , ,

The PL/SQL Debugger Strikes Back: Episode V

I’ve already discussed how the Rebel scum go about figuring out what’s wrong with their code. Now I want to get into the nitty-gritty details of how to start a debug session in SQL Developer. There are some prerequisites, but I promise it won’t take but a few moments to setup. Ensure that you have […]

Similar Posts by Subject Areas: , , ,

Code Completion Insight with Oracle SQL Developer

Most third generation language (3GL) IDEs have trained hackers like me to expect the tool to write some of the code for them. Regular internet folks are already used to having search terms and URLs auto-completed in their browsers. I don’t want to get into a debate over whether this makes us lazier AND dumber, […]

Similar Posts by Subject Areas: , , , ,

Free Beer or How to Get Free Demo Data from iTunes

Are you sick and tired of playing with the same sample data? Do you shudder at even the mention of the name, ‘Scott?’ First of all, if you’re still using SCOTT, you should try out HR instead. And if you want some beefier tables and need to experiment with partitioning, then SH is the way […]

Related Posts Plugin for WordPress, Blogger...

Similar Posts by Subject Areas: ,