Welcome To Snipplr


Everyone's Recent SQL Snippets



1 2 3 4 5 6 ... 18
A few examples of the Oracle CHR function.
0 797 posted 8 years ago by bbrumm
A few examples of the Oracle CEIL function.
0 904 posted 8 years ago by bbrumm
A few examples of the EXP function.
0 1045 posted 8 years ago by bbrumm
A few examples of the TO_NUMBER function
0 1081 posted 8 years ago by bbrumm
A few examples of the Oracle RPAD function, with some tables being set up.
0 916 posted 8 years ago by bbrumm
A few examples of the LENGTH function
0 853 posted 8 years ago by bbrumm
A few examples of the Oracle LTRIM function.
0 877 posted 8 years ago by bbrumm
A few examples of the Oracle INSTR function.
0 934 posted 8 years ago by bbrumm
A few examples of the Oracle RTRIM function.
0 921 posted 8 years ago by bbrumm
A few examples of the Oracle CASE expression
0 785 posted 8 years ago by bbrumm
A few examples of the Oracle REPLACE function
0 802 posted 8 years ago by bbrumm
A few examples of the GREATEST function
0 921 posted 8 years ago by bbrumm
A few examples of the Oracle LEAST function
0 920 posted 8 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0 1261 posted 8 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0 965 posted 8 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0 904 posted 8 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0 799 posted 8 years ago by bbrumm
These are some examples of the Oracle TO_DATE Function
0 791 posted 8 years ago by bbrumm
De las tareas que di­a a di­a necesitamos realizar en una base de datos
0 1091 posted 8 years ago by systemergon
SQL Server query sample using rank/dense_rank
0 863 posted 9 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 833 posted 9 years ago by systemergon
Alternativas para formato de datos en sql server
0 1023 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 871 posted 9 years ago by systemergon
This lite fiuntion is a simple organizator rowcount for all datatables for one single database.
0 914 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 1077 posted 9 years ago by ktrout
procedure to throw application defined error
0 1055 posted 9 years ago by ktrout
calculate rank ( with ties ) over points table
0 1164 posted 9 years ago by ktrout
clone table with structure and indexes
0 1213 posted 9 years ago by ktrout
unroll variable length string list to normalised form.
0 1057 posted 9 years ago by ktrout
search for tables in mysql catalog ( information_schema )
0 1076 posted 9 years ago by ktrout
1 2 3 4 5 6 ... 18