Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select fun_cracha, fun_descricao from cadfun
- where to_char(FUN_DATA_NASCIMENTO, 'dd/mm/yyyy') = '00/00/0000' or to_char(FUN_RG_EMISSAO, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_DATA_DE_ADMISSAO, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_DATA_DE_DEMISSAO, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(C12, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(TITULO_DATA, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_CTPS_EMISSAO, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_HABILITACAO_VAL, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(DATEXAME, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(NOVFERIAS, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(DATAVT, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_DATA_NASC_CONJUGE, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_DATA_CAD_PIS, 'dd/mm/yyyy') = '00/00/0000' or
- to_char(FUN_DATA_ESTABIL, 'dd/mm/yyyy') = '00/00/0000'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement