Welcome To Snipplr
Everyone's Recent Snippets Tagged Oracle
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
Some examples of the Oracle LISTAGG function, including setting up the tables.
0
1004
posted 7 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0
714
posted 7 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0
675
posted 7 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0
610
posted 7 years ago by bbrumm
This only shows public procedures, not the privates one declares only in packages body.
0
697
posted 9 years ago by Igeco
La première commande liste les sessions bloquantes, la deuxième les kill
0
752
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
1078
posted 10 years ago by supupoff
This SQL would help you to transpose a rows into columns in SQL
0
2216
posted 11 years ago by mprabhuram
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
651
posted 12 years ago by thescorpion
Mostrar Objetos que hacen Referencia a un Objeto Especifico en Oracle
0
886
posted 12 years ago by thescorpion
Search SQL Server or Oracle database for keyword embedded within stored procedures, functions, triggers, etc.
0
800
posted 12 years ago by jstrawther
can be used to track Oracle Apps concurrent program performance
0
1033
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
1146
posted 12 years ago by theonlyalterego
Query to find the most recent logins for a particular user ( find 1 years worth )
0
951
posted 12 years ago by theonlyalterego