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. To stay up to date on new topics subscribe to one of the available RSS Feeds.

Latest Additions and Updates

Change	Topic	Published On
New Topic	Non-leaf PTFs	2018-06-23
New Topic	Unicode: Code Points in SQL or PL/SQL	2011-08-25
New Tutorial	SQL Features Tutorials: Unicode	2011-01-01
New Blog Post	Joe's Blog: 15 Mintues of Fame	2009-07-25
New Tutorial	SQL Features Tutorials: Grouping Rows with GROUP BY	2009-06-09
Updated Tutorial	Columns to String: Comma Separated Values (CSV)	2008-03-28
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	Joe'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	Joe's Blog: And Now for Something Completely Different	2007-06-28
New Blog Post	Joe's Blog: Google Street View	2007-06-08
New Tutorial	Transformations: Numbers to Words	2007-06-07

Linking to SQL Snippets ™

To link to this page in Oracle Technology Network Forums or OraFAQ Forums cut and paste this code.

[url=http://www.sqlsnippets.com/en/home.html]SQL Snippets[/url]

To link to this page in HTML documents or Blogger comments cut and paste this code.

<a href="http://www.sqlsnippets.com/en/home.html">SQL Snippets</a>

To link to this page in other web sites use the following values.

Link Text : SQL Snippets
URL (href): http://www.sqlsnippets.com/en/home.html

SQL Snippets ™: Tutorials for Oracle Developers