Oracle Snippets


07 December, 2013   

Example code for Oracle Cursor Query

09 April, 2013   

How to "bounce" an Oracle database

14 May, 2012   

PL SQL Descending order in Oracle

29 March, 2015   

When creating an index, the default method Oracle uses to sort the index is in ascending order (SORT). However, if the rows are already stored in the database in ascending order you can use the NOSORT clause to skip the sorting process. If neither SORT or NOSORT is provided, Oracle will use SORT as the clause.

PL/SQL code example to create and call an oracle function

Code example for Connecting to Oracle using Java JDBC

Oracle 10G has enhanced the flashback feature further and has turned it into a much more powerful feature by introducing a number of additional function. Some of the more common ones are discussed here. - Flashback Table - Flashback Drop - Flashback Database

25 October, 2014   

DBCA is what you need to create a test database in only 5 mins.

19 March, 2011   

Showing here an example of PL SQL Query

08 February, 2016   

A type of replacement function within the SELECT statement.

10 September, 2011   

Example code showing how to add a primary constraint. This Oracle constraint is used to identify the primary key for a table. A primary key is a single field or combination of fields that uniquely defines a record. None of the fields that are part of the primary key can contain a null value. A table can have only one primary key. This...

To produce a random character from a specific list of characters (for example 'x', 'y' or 'z')

07 December, 2013   

This code is for iterating through a cursor

Loop through a fixed list of values or strings

12 January, 2013   

Find out an object OR Synonym

07 August, 2014   

All hints except /*+ rule */ cause the CBO to be used. Therefore, it is good practise to analyze the underlying tables if hints are used (or the query is fully hinted.

02 November, 2014   

The RETURNING clause was implemented as part of the Oracle 10g release and is used to return information about the effected rows after issuing Data Manipulation Language (DML) statements.

19 September, 2013   

Function to test for the existence of at least 1 matching row, without having to count them all!

20 April, 2013   

You can create your own Exceptions in PL/SQL

28 June, 2014   

Starting in Oracle 9i, you can use the case statement within an SQL statement. It has the functionality of an IF-THEN-ELSE statement.