Home » SQL & PL/SQL » SQL & PL/SQL » Error in if then else condition.
Error in if then else condition. [message #322805] Mon, 26 May 2008 05:15 Go to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
Hi,


SELECT PLAN.FINAL_BALANCE,PLAN1.FINAL_BALANCE,
(PLAN.FINAL_BALANCE-PLAN1.FINAL_BALANCE) VAR
FROM
PLAN,
PLAN PLAN1
WHERE
IF VAR=0 THEN " " ELSE "VAR"


There is any mistake in above function which i used in my sql query.
But it showing error"invalid relational operatoe".How can i slove this one.Any one help.

[Updated on: Mon, 26 May 2008 05:20]

Report message to a moderator

Re: Error in if then else condition. [message #322810 is a reply to message #322805] Mon, 26 May 2008 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The mistake is that you didn't read SQL Reference.
With 70 posts It is hard to understand why you didn't open it yet.

Regards
Michel
Re: Error in if then else condition. [message #322814 is a reply to message #322810] Mon, 26 May 2008 05:26 Go to previous messageGo to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
please tell me solution.
Re: Error in if then else condition. [message #322819 is a reply to message #322814] Mon, 26 May 2008 05:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Open SQL Reference and search for CASE.

Regards
Michel
Re: Error in if then else condition. [message #322822 is a reply to message #322819] Mon, 26 May 2008 05:49 Go to previous messageGo to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
CASE Function also showing same error
Re: Error in if then else condition. [message #322823 is a reply to message #322822] Mon, 26 May 2008 05:52 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
why don't you copy and paste the error ? I am not able to see any statement or any error in your posting.

Regards

Raj
Re: Error in if then else condition. [message #322829 is a reply to message #322823] Mon, 26 May 2008 06:30 Go to previous messageGo to next message
tondapi
Messages: 99
Registered: August 2007
Location: usa
Member
"invalid relational operatoe".This is error it showing
Re: Error in if then else condition. [message #322834 is a reply to message #322829] Mon, 26 May 2008 06:45 Go to previous messageGo to next message
S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom
Senior Member
I didn't ask you to type. For example what you have typed is wrong. It is having a spelling mistake.
Quote:
invalid relational operatoe

I asked you to copy and paste from your sql*plus session.

Regards

Raj
Re: Error in if then else condition. [message #322885 is a reply to message #322829] Mon, 26 May 2008 10:57 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
tondapi wrote on Mon, 26 May 2008 13:30
"invalid relational operatoe".This is error it showing


oh my... here we go again.
Userid does 'ring a bell'...
Previous Topic: want SQL or PLSQL procedure to make a column as right justified (Merged)
Next Topic: How to Read Registry from Oracle
Goto Forum:
  


Current Time: Fri Dec 02 22:54:59 CST 2016

Total time taken to generate the page: 0.11520 seconds