CPF e CNPJ

Pega um valor e transforma em CPF 000.000.000-00 ou cnpj 00.000.000/000-00

SELECT decode(:cpf, null,null,translate(to_char(:cpf/100,'000,000,000.00'),',.','.-'))                               cpf_com_mascara
      ,decode(:cnpj,null,null,replace(replace(replace(to_char(lpad(replace(:cnpj,' '),14,'0'),'00,000,000,0000,00')
             ,',','.'),' '),'.'||trim(to_char(trunc(MOD(lpad(:cnpj,14,'0'),1000000)/100),'0000'))||'.'
             ,'/'||trim(to_char(trunc(MOD(lpad(:cnpj,14,'0'),1000000)/100),'0000'))||'-'))                          cnpj_com_mascara

FROM dual;