Home » RDBMS Server » Server Administration » case
case [message #374843] Thu, 05 July 2001 23:22
ravibabu
Messages: 12
Registered: July 2001
Junior Member
how do we use CASE in oracle?
if i am using case like this i am gettting the following error

SQL> SELECT ename, CASE WHEN sal>1000 THEN 'Over paid' ELSE 'Under paid' END
2 FROM emp;
SELECT ename, CASE WHEN sal>1000 THEN 'Over paid' ELSE 'Under paid' END
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

Report message to a moderator

Previous Topic: Re: Checking Oracle USR/PWD by a Unix shell
Next Topic: higest value
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 03 03:27:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.