Welcome To Snipplr
Everyone's Recent SQL Snippets
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
A few examples of the Oracle RPAD function, with some tables being set up.
0
1014
posted 8 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0
1474
posted 8 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0
1079
posted 8 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0
1028
posted 8 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0
882
posted 8 years ago by bbrumm
De las tareas que dia a dia necesitamos realizar en una base de datos
0
1355
posted 9 years ago by systemergon
Insertar registros bloqueando mientras se realiza el proceso.
0
999
posted 9 years ago by systemergon
Cuando requerimos hacer consultas que devuelvan todos los registros y al mismo tiempo si se desea filtrar por algunos campos se filtra por los parámetros devueltos
ej. en el
WHERE (U.UnidadAplicativaId = @UnidadAplicativaId OR @UnidadAplicativaId...
0
980
posted 9 years ago by systemergon
This lite fiuntion is a simple organizator rowcount for all datatables for one single database.
0
1054
posted 9 years ago by achavesm302
pivot data. input source query in the form :
+--------+-----------+-------------+-------------+
| name | pivot_fid | pivot_fname | pivot_value |
+--------+-----------+-------------+-------------+
| apple | 1 | is red...
0
1996
posted 9 years ago by ktrout