Problema
Boa tarde,
estou com o seguinte problema, estou fazendo a seguinte conta abaixo onde eu preciso saber se o valor que me retornar for maior que 60000 eu quero que retorne um valor randomico rand(55000,55959) Alguém consegue me ajudar???
(COALESCE(((MT.HORA_FINAL - HORA_INICIO) -
(SELECT HORAFINAL - HORAINICIAL
FROM MOV_PARADASSERVICOS MP
WHERE MP.CONTROLE = TT.CONTROLE)),0)) AS TOTAL,
Subject
Views
Written By
Posted
Problema
3304
May 10, 2012 11:06AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.