Welcome To Snipplr


Everyone's Recent Snippets Tagged Oracle



A few examples of the LENGTH function
0 1238 posted 9 years ago by bbrumm
A few examples of the Oracle LTRIM function.
0 1267 posted 9 years ago by bbrumm
A few examples of the Oracle INSTR function.
0 1309 posted 9 years ago by bbrumm
A few examples of the Oracle RTRIM function.
0 1311 posted 9 years ago by bbrumm
A few examples of the Oracle CASE expression
0 1118 posted 9 years ago by bbrumm
A few examples of the Oracle REPLACE function
0 1131 posted 9 years ago by bbrumm
A few examples of the GREATEST function
0 1289 posted 9 years ago by bbrumm
A few examples of the Oracle LEAST function
0 1352 posted 9 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0 1802 posted 9 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0 1331 posted 9 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0 1260 posted 9 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0 1134 posted 9 years ago by bbrumm
These are some examples of the Oracle TO_DATE Function
0 1112 posted 9 years ago by bbrumm
This only shows public procedures, not the privates one declares only in packages body.
0 1417 posted 11 years ago by Igeco
La première commande liste les sessions bloquantes, la deuxième les kill
0 1421 posted 11 years ago by Igeco
use This Class to conenct to any database mysql oracle access and postgresql and use functions to select update insert or update data from database --
0 3655 posted 11 years ago by supupoff
List locked object Oracle Database using V$LOCKED_OBJECT view
0 1434 posted 12 years ago by ceduard0
This SQL would help you to transpose a rows into columns in SQL
0 3048 posted 12 years ago by mprabhuram
ver tablas que tiene un usario asiganadas por privilegio
0 5489 posted 13 years ago by thescorpion
Uso de Grant y Revoke de objetos masivos de distintos user
0 1349 posted 13 years ago by thescorpion
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 e...
0 1295 posted 13 years ago by thescorpion
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0 1548 posted 13 years ago by thescorpion
Borrar archivos Log con Rman
0 2098 posted 13 years ago by thescorpion
comando para cambiar el tablespace de un objeto
0 3785 posted 13 years ago by thescorpion
find what profile values are set for a particular user
0 1484 posted 13 years ago by theonlyalterego
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 1421 posted 13 years ago by jstrawther
AP-SLA-GL Link Query
0 1880 posted 14 years ago by theonlyalterego
can be used to track Oracle Apps concurrent program performance
0 1702 posted 14 years ago by theonlyalterego
This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name
0 2098 posted 14 years ago by theonlyalterego
Query to find the most recent logins for a particular user ( find 1 years worth )
0 1692 posted 14 years ago by theonlyalterego