Video: ‘Dan’s Dozen’ Quick Toad Tips – Tip #1 – Toad Insights
Video: ‘Dan’s Dozen’ Quick Toad Tips – Tip #1 – Toad Insights
Welcome to my new quick video series, Dan's Dozen Toad Tips! Here's today's tip:...
Oracle Coding Best Practices: Making a CASE for the CASE statement
Oracle Coding Best Practices: Making a CASE for the CASE statement
This article will discuss the CASE statement. PL/SQL has had the CASE statement since Oracle9 I believe (an eternity for most of today’s coders). I will also illustrate a little-known fact: The CASE...
Oracle Coding Best Practices – Part 6
Oracle Coding Best Practices – Part 6
Hi, This article is a continuation of part 5 of this series (click here to see Part 5) in which I will discuss the Native Dynamic SQL and how I used dynamic SQL to solve tough parallel SQL performance...
How I became an author, how it helped my career–and how you can do it too
How I became an author, how it helped my career–and how you can do it too
Hi, This is the time of year we look back and consider what we’re thankful for. I am thankful for the opportunity to be well-published. I have always enjoyed sharing my knowledge with others and I ha...
Oracle Coding Best Practices – Part 5
Oracle Coding Best Practices – Part 5
Introduction This article series illustrates two ways of doing dynamic SQL, that is, SQL that is programmatically generated and submitted for execution. I have used one of the methods to solve parall...
VIDEO: Customizing Toad with Shortcuts and Using Templates
VIDEO: Customizing Toad with Shortcuts and Using Templates
Customize Toad with shortcuts and using templates....
Oracle Coding Best Practices – PL/SQL Tips and Techniques Part 4
Oracle Coding Best Practices – PL/SQL Tips and Techniques Part 4
Hi, This article will discuss some timings from last month’s FORALL load times. I had a student from a class share his timings using newer syntax that he learned in my class. I will talk about some ...
Scary Situations: Management Bullies, Tight Deadlines, and More
Scary Situations: Management Bullies, Tight Deadlines, and More
Hi, This month pulls from my programming and consulting days: how I solved working with management bullies, and used technology to solve short time frames and to assist in a screen-conversion project ...
VIDEO TUTORIAL: Toad Advanced Explain Plan Tips and Techniques
VIDEO TUTORIAL: Toad Advanced Explain Plan Tips and Techniques
Welcome to my new video blog! Our first tutorial: Toad Advanced Explain Plan Tips and Techniques. I hope you find it useful. Drop me a line and let me know if you have any comments or questions. Dan...