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
1209
posted 9 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0
1735
posted 9 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0
1267
posted 9 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0
1203
posted 9 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0
1081
posted 9 years ago by bbrumm
De las tareas que dia a dia necesitamos realizar en una base de datos
0
1675
posted 9 years ago by systemergon
Insertar registros bloqueando mientras se realiza el proceso.
0
1265
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
1174
posted 9 years ago by systemergon
This lite fiuntion is a simple organizator rowcount for all datatables for one single database.
0
1289
posted 10 years ago by achavesm302
pivot data. input source query in the form :
+--------+-----------+-------------+-------------+
| name | pivot_fid | pivot_fname | pivot_value |
+--------+-----------+-------------+-------------+
| apple | 1 | is red...
0
2398
posted 10 years ago by ktrout