Snipplr

(PL/SQL) Hello World - geekzspot

Mon, 06 May 2013 11:34:35 GMT

Hello World

(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 Loop through an Array - geekzspot

Wed, 20 Feb 2013 10:50:32 GMT

Loop through a fixed list of values or strings

(PL/SQL) PL/SQL Loop through a SELECT FROM a_table; - geekzspot

Tue, 12 Feb 2013 07:37:09 GMT

You can put it in a Procedure or Function or run it as an anonymous block of SQL

(PL/SQL) PL/SQL Loop 1 to n times - geekzspot

Tue, 12 Feb 2013 07:34:31 GMT

You can also run this an an anonymous SQL Block

(PL/SQL) Oracle User-Defined Exception - geekzspot

Fri, 01 Feb 2013 08:39:09 GMT

You can create your own Exceptions in PL/SQL

(PL/SQL) Oracle Elapsed Time - geekzspot

Thu, 17 Jan 2013 05:32:44 GMT

Calculate the elapsed time between two points

(PL/SQL) Oracle If Exists - geekzspot

Fri, 11 Jan 2013 03:24:18 GMT

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

(PL/SQL) Oracle Cursor examples - geekzspot

Thu, 10 Jan 2013 05:45:25 GMT

Write to a cursor, with parameters, read, print

(PL/SQL) Oracle Package Procedure Function Name Self-reference - geekzspot

Thu, 03 Jan 2013 12:13:09 GMT

$$PLSQL_UNIT and $$PLSQL_LINE will give a self-reference to the Package Name (or a Procedure Name or a Function Name) and line number. Documentation at http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/fundamentals.htm#sthref557

(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) How To Change The Value Of A Sequence In PL/SQL - rtperson

Sun, 02 Dec 2012 12:39:22 GMT

I'm pretty meh about Oracle's PL/SQL, but its inability to reference and change sequences has been pretty frustrating over the years. Until now. Thanks to the Puget Sound Oracle Users Group's website (psoug.org) for showing me how to do this.

(PL/SQL) Oracle PL/SQL DBMS_OUTPUT Enable - geekzspot

Thu, 29 Nov 2012 08:31:42 GMT

Programatically enable DBMS_OUPUT

(PL/SQL) Oracle send email - geekzspot

Thu, 29 Nov 2012 03:45:08 GMT

Send a test email from Oracle database

(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) "If Exists" PL/SQL Function - geekzspot

Tue, 30 Oct 2012 03:45:23 GMT

Boolean "if exists" Function

(PL/SQL) PL/SQL Constants - geekzspot

Wed, 24 Oct 2012 05:24:13 GMT

Constants are a great way to standardize See also PLSQL Subtypes Here is an example:

(PL/SQL) PL/SQL Subtypes - geekzspot

Wed, 24 Oct 2012 05:22:16 GMT

Subtypes are a great way to standardize See also PLSQL Constants Here is an example:

(PL/SQL) Compile All Invalid Objects - geekzspot

Tue, 23 Oct 2012 08:32:13 GMT

Compile all invalidated code. Just to see if it really is invalid, or just got invalidated.