Welcome To Snipplr


Everyone's Recent Snippets Tagged sql



1 2 3 4 5 6 ... 17
A few examples of the Oracle CEIL function.
0 523 posted 7 years ago by bbrumm
A few examples of the EXP function.
0 678 posted 7 years ago by bbrumm
A few examples of the TO_NUMBER function
0 676 posted 7 years ago by bbrumm
A few examples of the Oracle RPAD function, with some tables being set up.
0 590 posted 7 years ago by bbrumm
A few examples of the LENGTH function
0 500 posted 7 years ago by bbrumm
A few examples of the Oracle LTRIM function.
0 537 posted 7 years ago by bbrumm
A few examples of the Oracle INSTR function.
0 571 posted 7 years ago by bbrumm
A few examples of the Oracle RTRIM function.
0 549 posted 7 years ago by bbrumm
A few examples of the Oracle CASE expression
0 458 posted 7 years ago by bbrumm
A few examples of the Oracle REPLACE function
0 481 posted 7 years ago by bbrumm
A few examples of the GREATEST function
0 547 posted 7 years ago by bbrumm
A few examples of the Oracle LEAST function
0 519 posted 7 years ago by bbrumm
Some examples of the Oracle LISTAGG function, including setting up the tables.
0 829 posted 7 years ago by bbrumm
Some examples of the NVL2 function in Oracle, including setup table.
0 552 posted 7 years ago by bbrumm
A few examples of the CONCAT function, including setting up the example tables.
0 531 posted 7 years ago by bbrumm
A few examples of the Oracle TO_CHAR function, which works on numbers and dates.
0 479 posted 7 years ago by bbrumm
These are some examples of the Oracle TO_DATE Function
0 478 posted 7 years ago by bbrumm
Show the output of a query in a more readable vertical format
0 900 posted 7 years ago by rm1984
SQL Server query sample using rank/dense_rank
0 494 posted 8 years ago by ManuelToledo
Insertar registros bloqueando mientras se realiza el proceso.
0 454 posted 8 years ago by systemergon
Conexión a base de datos con los parametros que llega del contructor
0 738 posted 8 years ago by systemergon
Alternativas para formato de datos en sql server
0 603 posted 8 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 521 posted 8 years ago by systemergon
This lite fiuntion is a simple organizator rowcount for all datatables for one single database.
0 563 posted 8 years ago by achavesm302
Created as reply to question on ittoolbox.com:"Need your help in writing a query to pull audit history i.e. Last updated by a user 'XYZ' and for the same record key (ID) the second last record in the audit history table. i.e. Last update by this user...
0 811 posted 8 years ago by bvwatson
Written as reply to question on ittoolbox.com:"I need to execute a query in vb which can find multiple value provided by the user to find from a single column of a table." [http://database.ittoolbox.com/groups/technical-functional/sql-l/query-to-fin...
0 783 posted 8 years ago by bvwatson
Moving a wordpress site for local dev, to staging, to production? This SQL snippet has done the job more often than not. It may not be 100% full proof but it has saved my butt hundreds of times. Please, if you know other tables or enhancements share...
0 733 posted 8 years ago by brownrl
In SQL I can get this by adding AND to the join LEFT JOIN installations i ON a.id = i.app AND i.page = :page This way I get the installation info for an app that has an installation on the page, but I get null values on the columns for app's that...
0 2188 posted 9 years ago by satie83
I thought I share this code snippet because I find this way of SMS sending an easy solution. I believe that even beginners can implement this VB.NET SQL SMS application, but I think some extent of perfection in the SMS technology is required for bett...
0 1190 posted 9 years ago by LoganTurn
This only shows public procedures, not the privates one declares only in packages body.
0 549 posted 9 years ago by Igeco
1 2 3 4 5 6 ... 17