Gilberto Ramos giraam

## oracle-validate-email.sql
SELECT NVL(LOWER(T.EMAIL),'-')EMAIL
FROM TABLE_NAME T
WHERE REGEXP_LIKE(NVL(LOWER(T.EMAIL),'-'), '^[a-zA-Z0-9!#$%''\*\+-/=\?^_`\{|\}~]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}$');

## generate-random-seed.java
import java.util.Random;
import javax.xml.bind.DatatypeConverter;

/**
 * Generate random seed
 *
 * @param seedlength Seed length in bytes unit
 * @return seed
 */
public String generateSeed(int seedlength) {

## string-to-sha1.java
import java.io.*;
import java.util.logging.*;
import javax.xml.bind.DatatypeConverter;

/**
 * Hashing with SHA1
 *
 * @param input String to hash
 * @return String hashed
 */
	SELECT NVL(LOWER(T.EMAIL),'-')EMAIL
	FROM TABLE_NAME T
	WHERE REGEXP_LIKE(NVL(LOWER(T.EMAIL),'-'), '^[a-zA-Z0-9!#$%''\*\+-/=\?^_`\{\|\}~]+@[a-zA-Z0-9._%-]+\.[a-zA-Z]{2,4}$');
	import java.util.Random;
	import javax.xml.bind.DatatypeConverter;

	/**
	* Generate random seed
	*
	* @param seedlength Seed length in bytes unit
	* @return seed
	*/
	public String generateSeed(int seedlength) {
	import java.io.*;
	import java.util.logging.*;
	import javax.xml.bind.DatatypeConverter;

	/**
	* Hashing with SHA1
	*
	* @param input String to hash
	* @return String hashed
	*/