SQL Features Tutorials

This section presents tutorials related to common Oracle SQL and PL/SQL features. These tutorials provide background for some of the techniques presented in the SQL Techniques Tutorials 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.