Posts by Douglas Heliston • 1 point

• 0

  votes

  2

  answers

  849

  views

  A: Condition within the WHERE clause

  You can filter as follows: select * from TABELA t WHERE TRUNC(T.DATASTAMP) BETWEEN '&DATA_INICIAL' AND '&DATA_FINAL' AND 1 = ( CASE WHEN &CT IS NOT NULL AND T.CENTRO_TRABALHO = &CT…

  oracle select pl-sql oracle11g where

  answered 5 years ago Douglas Heliston 1