Posts by RENATO • 7 points

3 posts

0
votes

1
answer

823
views

A: Check valid date on oracle

I managed to solve after hours testing, but God is good all the time and allowed me to find the solution, below follows the solution: SELECT * FROM TB_TESTE_DATA_01 b WHERE b.DATA_ADMISSAO = (CASE…

oracle oracle11g oracle12c oracle11c
answered 4 years, 4 months ago RENATO 7
-2
votes

1
answer

823
views

Q: Check valid date on oracle

I need a help, I’m trying to bring the valid dates of the bank because there are dates with invalid formats in it, below follows the code I’m using, can someone give me a hand? I’ve done it all...…

oracle oracle11g oracle12c oracle11c
asked 4 years, 4 months ago RENATO 7
-2
votes

1
answer

370
views

Q: Test date field in Oracle query

need to ask a question, I am using this to_date shown below, for now we have no validation and sometimes the user puts the character (...) or other invalid character in the field date, breaking thus…

oracle
asked 4 years, 7 months ago RENATO 7