Snipplr

(PL/SQL) PL/SQL - Optional conditions in where-clause - geekzspot

Tue, 23 Oct 2012 06:59:09 GMT

Good for searching and filtering data for reports

(PL/SQL) PL/SQL Elapsed time - geekzspot

Fri, 19 Oct 2012 06:16:25 GMT

Calculate and display the elapsed time for PL/SQL code

(PL/SQL) DBMS_OUTPUT - geekzspot

Fri, 19 Oct 2012 03:06:33 GMT

Print to screen. Useful for debug.

(PL/SQL) Mover de TableSpace un Objeto o tabla - thescorpion

Fri, 21 Sep 2012 03:12:03 GMT

comando para cambiar el tablespace de un objeto

(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) Oracle - Iterating Cursor - Hisoka

Sat, 23 Apr 2011 00:55:03 GMT

this code is for iterating through a cursor

(PL/SQL) MISSING GRANTS - kamilch

Fri, 01 Oct 2010 20:00:20 GMT

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

Tue, 28 Sep 2010 00:44:56 GMT

(PL/SQL) Desc in Oracle - darkapple

Fri, 16 Apr 2010 01:30:54 GMT

(PL/SQL) 找到耗CPU比较高的语句 - mifly

Thu, 25 Mar 2010 20:36:53 GMT

(PL/SQL) Hold concurrent requests by name - kitzelh

Sun, 29 Nov 2009 22:06:42 GMT

(PL/SQL) Kill all sessions from host in Oracle - kamilch

Thu, 06 Aug 2009 06:10:30 GMT

(PL/SQL) Create new Oracle user - kamilch

Thu, 06 Aug 2009 06:07:54 GMT

(PL/SQL) Oracle TO_DATE function - kamilch

Thu, 06 Aug 2009 06:03:41 GMT

(PL/SQL) Kill oracle session - kamilch

Thu, 06 Aug 2009 06:02:06 GMT

(PL/SQL) Drop sequences in current schema - kamilch

Thu, 06 Aug 2009 05:58:14 GMT

(PL/SQL) Drop all tables in Oracle - kamilch

Thu, 06 Aug 2009 05:56:07 GMT

(PL/SQL) Kill locked session - tenkyu

Thu, 14 May 2009 06:38:13 GMT

(PL/SQL) Efficiently compare columns from two tables - stews

Wed, 17 Sep 2008 17:26:59 GMT

This compares selected columns between 2 tables that you think might have differences. It lists the rows and values that are different between the two sources You can add WHERE clauses as appropriate. You could also use this to compare the results of two queries. This is from Tom Kyte (www.asktom.com). I can't say I understand exactly how it works, but it's much faster than other methods I've seen. It has the advantage of only looking through each table once.