Learn how to master the SELECT statement to form truly useful data queries. This article explains functions, clauses, and keywords that will make your life a lot easier. Due to popular demand, we’re ...
Oracle9i offers some great tools to make it easy to view the execution plan and trace information for a SQL statement. Prior to Oracle8i, you had to create a plan table and execute special syntax to ...
Don't be afraid of using your chosen database's command-line client. I might as well say this up front: I don't like using GUI (aka non-command-line or graphical) tools with my databases. This is ...