Oracle Articles by it-helten

Here is a list of the Oracle-related articles from it-helten.

Using Connect By in Oracle
A short introduction to hierarichal queries in Oracle. The article includes examples and explanations for Level, Connect By, Start With, Prior and Order By Siblings.
http://it-helten.dk/blog/using-connect-by-in-oracle/

Mimicking a Materialized View in Oracle
A short guide on how to circumvent the restrictions of materialied views in Oracle by mimicking them using actual tables.
Mimicking a Materialized View in Oracle

ORA-01000: Open Cursors in Oracle
This article describes how to solve and how to avoid the ORA-01000 Oracle error. The examples in this article are based on Java.
ORA-01000: Open Cursors in Oracle

Stay tuned, more articles coming soon…..