This section presents tutorials related to practical Oracle SQL and PL/SQL programming techniques. Background for the basic SQL and PL/SQL features used in these techniques is available under the SQL Features Tutorials section elsewhere on this site.

Keep in mind that snippets in the SQL Features Tutorials section are designed to be instructional whereas the snippets in the SQL Techniques Tutorials section are designed to be practical. Instructional snippets will quickly and clearly demonstrate how certain features work, but they may not be the most efficient way to produce a desired result. Practical snippets, on the other hand, are designed to produce a certain result.