Advanced Search

Welcome To Snipplr

Everyone's Recent SQL Snippets

1 ... 9 10 11 12 13 ... 18
1 1585 posted 15 years ago by cjcdeleon
Elapsed Time Calculation
0 1460 posted 15 years ago by mprabhuram
GET_HASH_VALUE Function This function computes a hash value for the given string. Syntax DBMS_UTILITY.GET_HASH_VALUE ( name VARCHAR2, base NUMBER, hash_size NUMBER) RETURN NUMBER;
1 1947 posted 15 years ago by mprabhuram
Returns database's version
0 1428 posted 15 years ago by mprabhuram
other links : http://tinman.cs.gsu.edu/~raj/880/su98/pldsql/node6.html
1 1678 posted 15 years ago by mprabhuram
In the examples so far we have declared variables as a separate object using one of PL/SQL’s standard datatypes. Normally a PL/SQL variable is closely tied to a database object and uses the same datatype. For example, if the variable will hold the...
1 1809 posted 15 years ago by mprabhuram
This is the quick method and painless way to Remove duplicate entries from MySQL
2 1868 posted 15 years ago by lixonic
Logic to subtract months from a date field and extract year and month
0 1838 posted 15 years ago by mprabhuram
Sequence is used to generate auto incrementing numbers
0 1452 posted 15 years ago by mprabhuram
2 1693 posted 15 years ago by ChrisCantley
1 1668 posted 15 years ago by RealRover
You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)
4 2127 posted 15 years ago by emregulcan
Stored Procedure for search and replace a string in all fields of all tables of one DataBase
2 2219 posted 15 years ago by Eloi
Stored Procedure for search a string in all fields of all tables of one DataBase
1 1711 posted 15 years ago by Eloi
See the DBLinks that you have created in the past
0 1719 posted 16 years ago by mprabhuram
use this to convert the oracle time stamp into a character.
0 1732 posted 16 years ago by mprabhuram
1 1686 posted 16 years ago by vedgiee
This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.
2 2090 posted 16 years ago by emregulcan
This will take the alpha numeric loan number field and converts it into numeric loan number. If there are any loan numbers with alphabet then it is converted as NULL (basically alpha numeric loan numbers are ignored)
0 1602 posted 16 years ago by mprabhuram
You can use this SP like that; Exec CleanInjection 'INFECTED WORD','CLEAN WORD' (in use : Exec CleanInjection '<script></script>','')
2 2061 posted 16 years ago by emregulcan
Use this logic to avoid double counting in ORACLE SQL
1 1810 posted 16 years ago by mprabhuram
This function can be used to find out if there exists an overlap between two pairs of dates or time. There is an alternate way to calculate the actual overlapping value - Read the snippet "How to avoid double counts"
0 4629 posted 16 years ago by mprabhuram
1 ... 9 10 11 12 13 ... 18