assim:
IF sales > 50000 THEN
bonus := 1500;
ELSIF sales > 35000 THEN
bonus := 500;
ELSE
bonus := 100;
END IF;
IF sales > 50000 THEN
bonus := 1500;
ELSIF sales > 35000 THEN
bonus := 500;
ELSE
bonus := 100;
END IF;
IF PAGINA = 101 THEN
'7'
ELSE
IF PAGINA = 102 THEN
'8'
ELSE
IF PAGINA = 103 THEN
'9'
ELSE
IF PAGINA = 104 THEN
'10'
ELSE
'0'
END IF
Variavel := CASE
WHEN :APP_PAGE_ID = 101
THEN '7'
WHEN :APP_PAGE_ID = 102
THEN '999'
ELSE '0'
END;
Usuários navegando neste fórum: Tinho e 6 visitantes