RSS Feeds  RSS Feeds

SQL Snippets: Tutorials for Oracle Developers

Sample Code for Real Life

Welcome to SQL Snippets, a place where Oracle developers can find free tutorials on common coding topics. Each topic is packed with lots of "snippets" (bits of sample code) that quickly and clearly demonstrate how SQL features and coding techniques work.

Use the Site Map, the navigation links at the top and left, or the Search Box in the page banner to find a topic. SQL Snippets is new, but constantly growing. Check back often to see what's new or subscribe to one of the available RSS Feeds.

Latest Additions and Updates

Change Topic Published On
New Tutorial SQL Features Tutorials: Materialized Views 2008-03-19
New Tutorial Regular Expressions: REGEXP_COUNT 2007-12-16
Updated Topic SQL Techniques Tutorials: Rows to Columns 2007-12-02
Updated Tutorial Nulls: Nulls and Equality 2007-12-02
New Blog Post SnippetyJoe's Blog: Happy First Anniversary SQL Snippets! 2007-11-18
New Tutorial Columns to Rows: UNPIVOT (11g) 2007-11-18
New Tutorial Nulls: Nulls and Aggregate Functions 2007-09-08
New Tutorial Integer Series Generators: Multiple Integer Series 2007-07-29
New Tutorial String to Rows: Hierarchical Methods 2007-07-29
Updated Tutorial Integer Series Generators: CONNECT BY LEVEL Method 2007-07-29
New Tutorial SQL Techniques Tutorials: Pattern Matching Over Rows 2007-07-09
New Tutorial SQL Techniques Tutorials: Varying IN Lists 2007-07-02
New Blog Post SnippetyJoe's Blog: And Now for Something Completely Different 2007-06-28
New Blog Post SnippetyJoe's Blog: Google Street View 2007-06-08
New Tutorial Transformations: Numbers to Words 2007-06-07
New Tutorial SQL Features Tutorials: Dates and Times 2007-06-07
New Blog Post SnippetyJoe's Blog: Getting IT Right 2007-06-07
New Tutorial SQL Features Tutorials: PL/SQL Collections 2007-05-31
New Tutorial SQL Techniques Tutorials: Rows to Columns 2007-05-16
New Tutorial Rows to String: MAX DECODE Method 2007-05-16