sugumar1985
Last Activity: Sep 28 '07, 10:46 AM
Joined: Sep 28 '07
Location:
-
doubt in un known block
anonymous blocks are stored inside the database or not ? -
ORA-00907: missing right parenthesis
[code=oracle]
select * from test where sal in ( case sal
when (sal < 5000) and (sal > 2000) then 2000
else 3000
end)
SQL> /
when (sal<5000 and sal>2000) then 2000
*
ERROR at line 2:
ORA-00907: missing right parenthesis
[/code]
if i executing this stmt , i m getting an error message
No activity results to display