Login / Register

Share Snipplr

Follow @Snipplr

Welcome To Snipplr

Everyone's Recent SQL Snippets

« Prev 1 ... 5 6 7 8 9 ... 18 Next »

SQL Oracle AP-SLA-GL Link Query

AP-SLA-GL Link Query

Oracle

0 931 posted 12 years ago by theonlyalterego

SQL Oracle - get concurrent program runtime / eval performance

can be used to track Oracle Apps concurrent program performance

Oracle

0 869 posted 12 years ago by theonlyalterego

SQL Query to find Parameters and Value Sets associated with a Concurrent Program

This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name

Oracle
sql

0 937 posted 12 years ago by theonlyalterego

SQL Sql Date Difference

Can use second, Minute and many other from the url above

date
sql

0 506 posted 12 years ago by jsturtevant

SQL Where clause to select multiple rows of unique values

Where clause to select multiple rows of unique values

mysql
sql

0 607 posted 12 years ago by the_construct

SQL Oracle SQL - get a list of most recent user logins

Query to find the most recent logins for a particular user ( find 1 years worth )

Oracle
sql

0 804 posted 12 years ago by theonlyalterego

SQL Auto Incremementing Id for Insert in T-SQL table

This code allows you to create an ID field value for inserts into a table that does not auto increment itself

sql

0 673 posted 12 years ago by ezerick

SQL Find duplicate entries

Searches for duplicate entries in the DataBase table

sql

1 477 posted 12 years ago by Neven

SQL Convert integer to date using SQL in iSeries DB2

intfield has this format: YYYYMMDD

date
sql

0 2571 posted 12 years ago by wnasich

SQL Find rows with last date of month

date
sql

0 610 posted 12 years ago by danfsmith

SQL Maps an existing database user to a SQL Server login.

security

0 839 posted 12 years ago by edwinet

SQL TSQL COVERING INDEX

sql

0 411 posted 12 years ago by amos24c

SQL Login to Drupal while site in maintenance

drupal

0 587 posted 12 years ago by athome

SQL Oracle - Find which users have FND Diagnostic profile value set

A slight adaptation on the sql in the Oracle Forum

Oracle
sql

0 851 posted 12 years ago by theonlyalterego

SQL T-SQL Error Handling

Boiler Plate for T-Sql Error handling

error

1 662 posted 12 years ago by amos24c

SQL Connect string for Oracle with sqlplus

Oracle
sql

1 614 posted 12 years ago by blackthorne

SQL if mysql_query is not empty

mysql
query

0 706 posted 12 years ago by cesarkohl

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo DELETE

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.

sql

0 471 posted 12 years ago by alberomo

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo UPDATE

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.

sql

0 519 posted 12 years ago by alberomo

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo INSERT INTO

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.

sql

0 497 posted 12 years ago by alberomo

SQL Sintaxis bÃ¡sica/habitual SQL para consulta tipo SELECT

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]

sql

0 545 posted 12 years ago by alberomo

SQL List and kill active DB connections

Kill connections to a database to perform maintenance that requires a connectionless DB

sql

0 394 posted 12 years ago by sommertim

SQL Restore MSSQL database from backup (.bak)

backup
sql

0 624 posted 12 years ago by plugables

SQL Update table with values selected in a subquery

The inner join could be nested too

0 750 posted 12 years ago by preasha

SQL Schema for the database DVD

database

0 585 posted 12 years ago by georgemathewkunnathoor

SQL Cursor in Mysql

mysql

0 545 posted 12 years ago by georgemathewkunnathoor

SQL SQL Update With Join

update

0 579 posted 12 years ago by lostumbrellas

SQL SQL SELECT 3 MONTHS +/-

Select rows that are 3 months ahead or 3 months behind from the current date.

date
sql

0 520 posted 12 years ago by jafar

SQL Replace local db with new URL

run these in the SQL tab

0 577 posted 12 years ago by xcsteve99

SQL Oracle - Find all responsibilities and concurrent program names based on the executable Name

0 807 posted 12 years ago by theonlyalterego

« Prev 1 ... 5 6 7 8 9 ... 18 Next »