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;

Oracle

1 750 posted 13 years ago by mprabhuram

SQL Return Database Version

Returns database's version

Oracle

0 459 posted 13 years ago by mprabhuram

SQL Dynamic SQL - Stored procedure

other links : http://tinman.cs.gsu.edu/~raj/880/su98/pldsql/node6.html

Oracle

1 590 posted 13 years ago by mprabhuram

SQL Variable Declaration Using Database Objects %rowtype

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...

Oracle

1 619 posted 13 years ago by mprabhuram

SQL Remove duplicate entries / rows from mySQL

This is the quick method and painless way to Remove duplicate entries from MySQL

mysql

2 666 posted 13 years ago by lixonic

SQL Logic to subtract months from a date field and extract run_yr_mo

Logic to subtract months from a date field and extract year and month

Oracle

0 696 posted 13 years ago by mprabhuram

SQL Oracle Sequence

Sequence is used to generate auto incrementing numbers

Oracle

0 492 posted 13 years ago by mprabhuram

SQL Get record count for a specific database

1 631 posted 13 years ago by edwinet

SQL Update one table from another

update

2 603 posted 13 years ago by ChrisCantley

SQL Find Stored Procedures with specified name or contains specified text

2 708 posted 13 years ago by lance

SQL Using temporary TABLE

table

1 460 posted 13 years ago by RealRover

SQL Find string anywhere in Sql Database

find
sql

4 758 posted 13 years ago by emregulcan

SQL MySQL Blob Compression performance query

0 507 posted 13 years ago by j4kp07

SQL Timezone database

You can run this sql scripts in your database. Firstly it creates a database and after insert records (timezones)

4 746 posted 13 years ago by emregulcan

SQL SQL Searh And Replace in ALL DataBase

Stored Procedure for search and replace a string in all fields of all tables of one DataBase

2 731 posted 13 years ago by Eloi

SQL SQL Searh in ALL DataBase

Stored Procedure for search a string in all fields of all tables of one DataBase

1 574 posted 13 years ago by Eloi

SQL Push_subq Oracle hint - Execute the sub query before the parent query

Oracle

0 685 posted 13 years ago by mprabhuram

SQL Create/ View/ Delete DB Links in oracle

See the DBLinks that you have created in the past

Oracle
sql

0 613 posted 13 years ago by mprabhuram

SQL Oracle TimeStamp to Char conversion

use this to convert the oracle time stamp into a character.

Oracle
sql

0 693 posted 13 years ago by mprabhuram

SQL Return Multiple Values Stored Procedure

1 611 posted 13 years ago by vedgiee

SQL mysql query to populate table from data in file

0 840 posted 13 years ago by breign

SQL Clean SQL Injection from your tables

This snippet just updates your tables which infected "<script> </script>" code blocks. You must update all columns one by one.

2 700 posted 13 years ago by emregulcan

SQL Regular expression to convert alphanumeric field into numeric field

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)