Unless otherwise stated, the sample code and sample output on this site were written for and derived from SQL*Plus against either an Oracle 10g Express Edition (XE) Release 10.2.0.1.0 database running on Windows XP or an Oracle 11g Enterprise Edition Release 22.214.171.124.0 database running on Oracle Enterprise Linux 5.0. Your results may differ from the results displayed depending on factors such as your database version, your client tools, your database configuration, and your operating system.
Running any of the code from this site on your own systems may produce undesired consequences. For example, if your system has a table called LOG_TABLE and you run some SQL Snippets code that drops its own test table with the same name, you will lose your original LOG_TABLE. Other consequences may include, but are not limited to,
results that differ from those shown on this site.
If you choose to run any SQL Snippets code on your own systems it is your responsibility to do it safely. Consider using Oracle's
Oracle Database 10g Express Edition
to create a safe test environment for experimenting with sample code.
use a production system or any system that may affect a production system.
If you adapt any SQL Snippets code or techniques for your own applications it is your responsibility to do it safely and accurately. Keep in mind that this site's content is for educational purposes only. Sample code and techniques may not work as expected on your systems.
Some of the logic on this site is demonstrated using stand-alone procedures and functions for brevity and clarity. In production applications I almost always implement such logic with packaged procedures and functions. If you implement similar logic in your own systems consider using packaged modules instead of stand-alone ones.
The content on this site has not been proofread or technically reviewed by anyone other than the author.
Please read the SQL Snippets
Terms and Conditions of Use
pages before continuing.
Nothing is perfect. The content on this site may contain errors. In fact, just to be safe you should assume it does.
Please report any errors you find to the email address listed in the
About: Feedback page. Corrections will be applied to the page where they are located. Check the "first published" and "last updated" dates at the bottom of each page to see if the content has changed since the last time you viewed it.