miércoles, 12 de enero de 2011

DATA MASKING

NUMEROS FIJO
STRING FIJO
DATE FIJO
RANDOM DATES
select to_date(to_char(to_date('01/01/2000','dd/mm/yyyy'),'J') + trunc(dbms_random.value(1,11280)),'J') from dual
RANDOM DATE ULTIMOS 30 DIAS
select sysdate - trunc(dbms_random.value(1,30)) from dual
RANDOM DIGITS
select trunc(dbms_random.value(0,9)) from dual
RANDOM NUMBERS POSITIVO – NEGATIVO
select round(dbms_random.value(-999999999,999999999)) num from dual
RANDOM NUMBERS POSITIVO
select round(dbms_random.value(1,999999999)) num from dual
RANDOM NUMBERS NEGATIVO
select round(dbms_random.value(-999999999, -1)) num from dual
RANDOM NUMBER ENTRE 0-1
select round(dbms_random.value(0, 1)) from dual
RANDOM STRING ALPHANUMERICOS
select dbms_random.string('X', 20) from dual
RANDOM STRING LOWERCASE
select dbms_random.string('L', 20) from dual
RANDOM STRING UPPERCASE
select dbms_random.string('U', 20) from dual
RANDOM STRING LOWERCASE-UPPERCASE
select dbms_random.string('A', 20) from dual
RANDOM STRING PRINT CHARACTERS
select dbms_random.string('P', 20) from dual
VALOR NULO
TABLA – COLUMNA
NOMBRES
APELLIDOS