[Database Series 06] Understand Bind Variables! Basic Techniques to Prevent SQL Injection and Improve Performance

The content of this article might be a bit difficult for those with no programming experience.This is because, in my ...
Hosted on MSN

PostgreSQL case statements explained with simple examples

PostgreSQL CASE statements make it possible to add conditional logic directly into SQL queries, working similarly to IF ELSE statements in programming languages and spreadsheet tools. This tutorial ...
techtarget

How to use SQL Developer to run SQL statements

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

How to prevent SQL injection with prepared statements

Structured Query Language, or SQL, is a programming language used with databases. SQL injection attacks -- when malicious SQL statements are inserted into an input query to gain access to a database - ...