Advanced Search

Welcome To Snipplr

Everyone's Recent Snippets Tagged Oracle

A few examples of the LENGTH function
0 539 posted 7 years ago by bbrumm
A few examples of the Oracle LTRIM function.
0 570 posted 7 years ago by bbrumm
A few examples of the Oracle INSTR function.
0 601 posted 7 years ago by bbrumm
A few examples of the Oracle RTRIM function.
0 592 posted 7 years ago by bbrumm
A few examples of the Oracle CASE expression
0 499 posted 7 years ago by bbrumm
A few examples of the Oracle REPLACE function
0 517 posted 7 years ago by bbrumm
A few examples of the GREATEST function
0 588 posted 7 years ago by bbrumm
A few examples of the Oracle LEAST function
0 562 posted 7 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0 879 posted 7 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0 596 posted 7 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0 570 posted 7 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0 519 posted 7 years ago by bbrumm
These are some examples of the Oracle TO_DATE Function
0 516 posted 7 years ago by bbrumm
This only shows public procedures, not the privates one declares only in packages body.
0 593 posted 9 years ago by Igeco
La première commande liste les sessions bloquantes, la deuxième les kill
0 645 posted 9 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 941 posted 10 years ago by supupoff
List locked object Oracle Database using V$LOCKED_OBJECT view
0 596 posted 10 years ago by ceduard0
This SQL would help you to transpose a rows into columns in SQL
0 2055 posted 10 years ago by mprabhuram
ver tablas que tiene un usario asiganadas por privilegio
0 3279 posted 11 years ago by thescorpion
Uso de Grant y Revoke de objetos masivos de distintos user
0 560 posted 11 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 533 posted 11 years ago by thescorpion
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0 762 posted 11 years ago by thescorpion
Borrar archivos Log con Rman
0 1236 posted 11 years ago by thescorpion
comando para cambiar el tablespace de un objeto
0 1016 posted 11 years ago by thescorpion
find what profile values are set for a particular user
0 657 posted 11 years ago by theonlyalterego
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0 692 posted 12 years ago by jstrawther
AP-SLA-GL Link Query
0 966 posted 12 years ago by theonlyalterego
can be used to track Oracle Apps concurrent program performance
0 902 posted 12 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 974 posted 12 years ago by theonlyalterego
Query to find the most recent logins for a particular user ( find 1 years worth )
0 833 posted 12 years ago by theonlyalterego