This fifth edition of a well-known title has been updated for Oracle 12c. As with previous editions, the book is very hands-on; you’re introduced to a concept, shown an example, then asked to work ...

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

Intermediate SQL tutorial demonstrating REGEXP for advanced filtering, IF & CASE statements to create categories, SUBQUERIES ...

As you will see in this chapter, companies use SQL Server for many types of applications and on most tiers now. Gone are the days when you would second guess yourself choosing to use SQL Server over a ...

SQL Server Management Studio can help take the guesswork out of creating connection strings for PowerShell applications.

In OpenOffice 2.0 Reports, it's easy to do the simple stuff, like just printing the contents of a table or query. It requires no SQL know-how at all, just the ability to press F4 and click and drag.

Chapter 2, How to use Oracle SQL Developer and other tools This chapter from Murach's Oracle SQL and PL/SQL explains how to work with Oracle SQL Developer and other tools. In this section, learn how ...

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 ...

This is the sixth edition of a well established title that has been updated for the latest version of PL/SQL (21c). The book opens with a checklist of the new features in Oracle 21c before the actual ...