ThatJeffSmith

Tag: oracle

Building your WHERE IN () Lists

Have you ever needed to write a query and filter your results with a WHERE EXISTS or a WHERE IN list of values? Your list will be comma delimited, and you’ll need to quote the strings appropriately. Not so bad if you have a few values, but what if you have 42 or 420 or [...]

SQL_IDs, Plans, and Baselines, Oh My!

Do you run a 3rd party application that uses Oracle RDBMS under-the-hood? Do you experience performance issues? Frustrated that you do not own the application SQL that is causing the issues? Maybe an upcoming upgrade to 11g might give you some relief. Many of the customers I speak with are unaware of a new 11g [...]

Kscope11 Database Development Symposium

The Oracle Development Tools User Group’s (ODTUG) annual convention in Long Beach, CA kicks off on a Sunday with several Symposiums. There will be one dedicated to tools (link), and I’ve been asked to present Toad and how it helps with instrumenting your PL/SQL code. – ODTUG KScope11 June 26-30 (Details) – One of the [...]

Is Your Query Running?

You better run and catch it then! You know you’re getting old when the new crop of kids don’t get this joke, or even worse, don’t understand what a prank phone call is. I’m pretty sure that folks still get phone calls from frustrated people who want to know how much time is left before [...]

More PL/SQL Fun in Toad version 11

You have some SQL in your PL/SQL program, and you need to execute it to see if it’s doing what you want. Today that means you need to extract the inputs, replace with binds, and remove the INTO syntax. What if Toad had a ‘magic button’ to do this work for you? In version 11, [...]

What is Your Test Plan?

Is that an offensive question? Does it assume to much? I can’t imagine asking ‘Do you have a test plan?’ I was working with an Oracle group this week, and after hearing about a big application upgrade schedule to go in April, I had a few questions for them. I was most curious how they [...]

Toad Tricks for PL/SQL Professionals

My first experiment with SlideShare! Interested in a free training session for Toad for Oracle? In about 60 minutes I can go over most of the features Toad has to offer for someone who works with PL/SQL. Take a look at the below presentation, and if you are interested, let me know. I can schedule [...]

Trade Show/User Group Season

Think the NHL or PGA seasons are brutally long? Try keeping up with all of the SQL Server and Oracle events. The friendly folks in Denver, CO tend get the conference ball rolling with the Rocky Mountain Oracle User Group (RMOUG) Training Days event. I had the pleasure to attend a couple of years ago [...]

Capture and Replay Oracle Activity

Sound familiar? Perhaps you have heard of Oracle’s Real Application Testing (RAT) (docs)? An excellent feature, although you will pay for it. If you need a cheaper alternative, then Quest Software might have what you are looking for in Benchmark Factory for Databases (product details). New for v6.5, Benchmark Factory (BMF), now assists you in [...]

Partitioning and DBMS_REDEFINITION

Unscientific research and Twitter gossip reveals that fewer than 15% of folks out there take advantage of Oracle’s partitioning (Oracle Docs) support for tables and indexes. Folks that build their own solutions in-house are more likely to discover and use partitioning. If you use a packaged 3rd-party database solution and it uses partitioning, then I [...]

My Oracle Twitter List

Are you new to Twitter, and need people to follow to get the conversation started? If you work with Oracle, then please continue reading. Don’t forget to check out @BrentO’s Twitter Book! I harangued (definition) my colleague and close friend this morning until he relented in joining Twitter. He specializes in Oracle, so I thought [...]

Elevenses

Everyone likes to read into numbers and significant dates. Numerology (wiki) attributes a connection from the world of numbers to the physical world. Even though I don’t believe in such things, I can’t help but take advantage of the opportunity to focus on the number ‘11.’ It’s eleventh day of 2011. Toad’s Development Manager is [...]

Three (4) Ways to get Data into Excel with Toad

I have been really hard on Excel lately. Excel is an excellent tool. Tools can be misused and abused, but it’s not their fault. I should know this being an advocate for Toad, but I digress. Updated on 1/5/2011 to include 4th Method and add note on ‘Display all results in grid’ option. You want [...]

Must Have Scripts

My former boss, and current friend, bought an Android phone for himself and his wife last week and asked me for a list of my must-have apps. I’ll list them here for the morbidly curious, but that got me thinking – what are my must-have scripts for managing my Oracle database? I know we’re supposed [...]

Trailing or Leading Commas?

For me, it’s leading. If I have a code or syntax problem, I find it easier to see the line missing the comma if I can look at the first char position. Of course you may say that’s crazy, and any reasonable programmer would demand trailing commas. I’m guessing your IDE offers formatting options that [...]