Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select * from TABELA t
- WHERE TRUNC(T.DATASTAMP) BETWEEN '&DATA_INICIAL' AND '&DATA_FINAL'
- AND ( CASE WHEN &CT IS NOT NULL THEN T.CENTRO_TRABALHO = &CT END );
- ...
- and (&CT is null or T.CENTRO_TRABALHO = &CT)
Add Comment
Please, Sign In to add comment