Can I read CPF/CNPJ Formatting in Oracle Query on EtoBox?

CPF/CNPJ Formatting in Oracle Query by juniomsilva is a document available to read on EtoBox.

What is CPF/CNPJ Formatting in Oracle Query about?

This SQL query selects the code, name, CPF number, and masked CPF/CNPJ number from table BAU010. It filters for records between certain dates where the CPF/CNPJ is not blank and not deleted, and orders by CPF/CNPJ number. Conditional logic is used to apply different masking formats depending on whether the record type is an individual (F) or company (J).

Author

juniomsilva

Language

EN