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

(SQL) Creacion de DBLINK con Full name service - thescorpion

Sat, 20 Oct 2012 04:18:47 GMT

Cuando se da el caso que tienes 2 servidores diferentes y el ServiceName de oracle es el mismo...En el momento de crear un dblink hay que especificar bien la cadena de coneccion para que se direccione al otro servidor y no escoja el serviceName del el mismo servidor en el cual estamos

(SQL) Mostrar JOB - thescorpion

Sat, 20 Oct 2012 01:29:31 GMT

mostar los job registrados en oracle

(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.

(SQL) Mostrar Objetos que hacen Referencia a un Objeto Especifico - thescorpion

Fri, 12 Oct 2012 02:59:07 GMT

Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle

(SQL) Aumentar tamaño al Tablespace en oracle - thescorpion

Fri, 05 Oct 2012 05:38:37 GMT

incremento del table space en oracle

(SQL) Consultar el MB los tamaños y porcentaje libre de TableSpace Oracle - thescorpion

Fri, 05 Oct 2012 05:31:49 GMT

Consular los tablespace y mostrar su tamaño , uso y espacio libre en Megabyte

(SQL) Borra archivos LOG Oracle usando RMAN - thescorpion

Sat, 29 Sep 2012 02:33:27 GMT

Borrar archivos Log con Rman

(Java) Recoger Cursor de Oracle en Java - thescorpion

Fri, 21 Sep 2012 03:58:00 GMT

Obtener el cursor de oracle y recorrerlo para sacar los datos

(PL/SQL) Retornar Cursor Oracle para Java - thescorpion

Fri, 21 Sep 2012 03:34:14 GMT

Procedimiento para retornar un Cursor y recorrerlo en Java

(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) MSSQL Cursor - simi23

Wed, 11 Jan 2012 22:52:59 GMT

basic definition for a cursor in MSSQL

(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.

(SQL) boolean column for oracle database tables - geekzspot

Tue, 07 Dec 2010 15:53:32 GMT

Boolean values (usually represented as Checkboxes in a User Interface) This is efficient because is does not suffer the clumsy and inefficient case problems of WHERE UPPER(column) = UPPER(variable);

(SQL) Cursor FOR LOOP - mprabhuram

Wed, 08 Sep 2010 02:21:52 GMT

You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched.

(SQL) Elapsed Time Calculation & SLEEP - mprabhuram

Tue, 31 Aug 2010 12:54:01 GMT

Elapsed Time Calculation

(SQL) Return Database Version - mprabhuram

Tue, 31 Aug 2010 12:26:55 GMT

Returns database's version

(SQL) Dynamic SQL - Stored procedure - mprabhuram

Mon, 30 Aug 2010 13:48:22 GMT

other links : http://tinman.cs.gsu.edu/~raj/880/su98/pldsql/node6.html

(SQL) Variable Declaration Using Database Objects %rowtype - mprabhuram

Mon, 30 Aug 2010 10:29:21 GMT

In the examples so far we have declared variables as a separate object using one of PL/SQL’s standard datatypes. Normally a PL/SQL variable is closely tied to a database object and uses the same datatype. For example, if the variable will hold the book title from the book table , the variable definition must be of the exact same type and size as the table column. But what happens when the DBA changes the book table so that book_title is defined as a varchar2(60) instead of a varchar2(40)? It’s important to program in such a way that when the tables are changed, the PL/SQL code does not always need to be changed