Guest User

Untitled

a guest
Sep 20th, 2018
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.21 KB | None | 0 0
  1. select * from TABELA t
  2. WHERE TRUNC(T.DATASTAMP) BETWEEN '&DATA_INICIAL' AND '&DATA_FINAL'
  3. AND ( CASE WHEN &CT IS NOT NULL THEN T.CENTRO_TRABALHO = &CT END );
  4.  
  5. ...
  6. and (&CT is null or T.CENTRO_TRABALHO = &CT)
Add Comment
Please, Sign In to add comment