Oracle Tutorial
How to parse a string in Oracle PL/SQL
When you want to parse a String in Oracle based on delimiters, you can use the Instr function to determine where the delimiters are.
Oracle DBA metrics
Oracle keeps a lot of metrics about the database. These can be query'd from the database. This tutorial gives examples.
Create a virtual table with numbers
This article describes how you can create a virtual table with increasing number.
Oracle autonomous transaction
An autonomous transaction is an independent transaction that is initiated by another transaction (the parent transaction). An autonomous transaction can modify data and commit or rollback independent of the state of the parent transaction.
Import/Export with Oracle datapump
The Oracle data pump is the improved version of imp/exp funtion in Oracle. With the data pump you can move data and metadata from one database to another.
Regular Expressions in Oracle SQL
Since Oracle 10g you can use regular expressions in the database. Regular expressions enable you to search for patterns in string data by using standardized syntax conventions.
Overview of Oracle Timestamp
The data datatype in Oracle in actually a date/time datatype. Next to the date a time in stored with an accuracy of seconds.
GRANT/REVOKE privileges in Oracle
This tutorial shows how to grant and revoke privileges in Oracle. With the GRANT statement you can grant: System privileges to users and roles. Roles to users and roles. Both privileges and roles are either local, global, or external.
How the start with CONNECT BY clause in Oracle works
This page explains the hierarchical query using the (start with) connect by clause in an Oracle SQL Query.