Snipplr

(PL/SQL) Selecting a Random Row from Table in MySQL - apphp-snippets

Tue, 12 Mar 2013 22:09:43 GMT

Here the simplest way of selecting random rows from the MySQL database with using "ORDER BY RAND()" clause in the query.

(PL/SQL) Oracle Get the Schema Name in a Script - geekzspot

Tue, 04 Dec 2012 03:07:11 GMT

Get the Schema Name into a Script Bind Variable

(PL/SQL) Oracle Get the Database Name in a Script - geekzspot

Tue, 04 Dec 2012 03:06:08 GMT

Get the Database Name in a Script Bind Variable

(PL/SQL) oracle database scheduler jobs - geekzspot

Wed, 28 Nov 2012 15:30:19 GMT

how to create a job to collect Table size metrics over time, with email notification

(PL/SQL) DBMS_OUTPUT - geekzspot

Fri, 19 Oct 2012 03:06:33 GMT

Print to screen. Useful for debug.

(PL/SQL) Strategy to identify duplicates in an ETL context (for example) - xavsio4

Sat, 09 Jul 2011 00:21:15 GMT

This sql statement enables to detect duplicates entries over a key and creates a seq column which says which one is the sequence of the duplicates. This way you can take only the seq = 1 and still be able to identify all duplicates

(PL/SQL) Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user - theonlyalterego

Thu, 26 May 2011 00:17:22 GMT

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

(PL/SQL) Update da table a table - tuffo19

Tue, 28 Sep 2010 00:44:56 GMT