Posts by RENATO • 7 points

• 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 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 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, 3 months ago RENATO 7