For those who can write SQL but don't understand PL/SQL: An explanation from basic syntax to practical pitfalls

An explanation from basic syntax to practical pitfallsYou can use SQL to search for data and retrieve records by specifying ...
techtarget

Executing SQL statements using prepared statements and statement pooling

A prepared statement is a SQL statement that has been compiled, or prepared, into an access or query plan for efficiency. A prepared statement is available for reuse by the application without the ...
Hackaday

Get Your SQL Statements Right The First Time With SQL Lint

What’s your average success rate of getting a SQL statement right on the first try? In best case, you botched a simple statement without side effects and just have to try again with correct syntax or ...
Network World

Chapter 3: Examples of SQL Server Implementations

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 ...
Simon Fraser University

EXECUTE Statement

In some SAS/ACCESS interfaces, you can issue an EXECUTE statement directly without first explicitly connecting to a DBMS (see CONNECT Statement). If you omit the CONNECT statement, an implicit ...
techtarget

Using a LEFT OUTER JOIN vs. RIGHT OUTER JOIN in SQL

In this excerpt from SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL, John L. Viescas and Michael J. Hernandez discuss the LEFT OUTER JOIN vs. the RIGHT OUTER JOIN and offer ...