Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets

1 ... 5 6 7 8 9 ... 18
AP-SLA-GL Link Query
0 2005 posted 14 years ago by theonlyalterego
can be used to track Oracle Apps concurrent program performance
0 1789 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 2273 posted 14 years ago by theonlyalterego
Can use second, Minute and many other from the url above
0 1421 posted 14 years ago by jsturtevant
Where clause to select multiple rows of unique values
0 1586 posted 14 years ago by the_construct
Query to find the most recent logins for a particular user ( find 1 years worth )
0 1802 posted 14 years ago by theonlyalterego
This code allows you to create an ID field value for inserts into a table that does not auto increment itself
0 1670 posted 14 years ago by ezerick
Searches for duplicate entries in the DataBase table
1 1313 posted 14 years ago by Neven
intfield has this format: YYYYMMDD
0 4032 posted 14 years ago by wnasich
0 1734 posted 14 years ago by danfsmith
0 1156 posted 14 years ago by amos24c
A slight adaptation on the sql in the Oracle Forum
0 1887 posted 14 years ago by theonlyalterego
Boiler Plate for T-Sql Error handling
1 1829 posted 14 years ago by amos24c
0 1734 posted 14 years ago by cesarkohl
Sintáxis y clausulas más habituales para consulas SQL con cláusula DELETE que elimina uno o varios registros de la tabla que se especifica.
0 1300 posted 14 years ago by alberomo
Sintáxis y clausulas más habituales para consulas SQL con cláusula UPDATE que actualiza/modifica uno o varios registros de la tabla que se especifica.
0 1434 posted 14 years ago by alberomo
Sintáxis y clausulas más habituales para consulas SQL con cláusula INSERT INTO que añade un nuevo registro a la tabla que se especifica.
0 1368 posted 14 years ago by alberomo
Sintáxis y clausulas más habituales para consulas SQL con cláusula SELECT que generen una nueva tabla con el resultado de la consulta. Su sintáxis genérica es SELECT [campos] FROM [tablas] WHERE [criterio]
0 1404 posted 14 years ago by alberomo
Kill connections to a database to perform maintenance that requires a connectionless DB
0 1076 posted 14 years ago by sommertim
The inner join could be nested too
0 1900 posted 14 years ago by preasha
0 1383 posted 14 years ago by georgemathewkunnathoor
0 1478 posted 14 years ago by lostumbrellas
Select rows that are 3 months ahead or 3 months behind from the current date.
0 1362 posted 14 years ago by jafar
run these in the SQL tab
0 1500 posted 14 years ago by xcsteve99
1 ... 5 6 7 8 9 ... 18