OraFAQ Forum: SQL & PL/SQL » ORA-00923: FROM keyword not found where expected error

Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00923: FROM keyword not found where expected error

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00923: FROM keyword not found where expected error [message #607095]

Sun, 02 February 2014 23:40

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Hi,

I found ORA-00923: FROM keyword not found where expected error , when i run this query why?

select empno,nvl(to_char(mgr),'no manager'))  from emp

Thank You

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607096 is a reply to message #607095]

Sun, 02 February 2014 23:42

manubatham20
Messages: 566
Registered: September 2010
Location: Seattle, WA, USA

Senior Member

Count the brackets.

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607097 is a reply to message #607096]

Sun, 02 February 2014 23:44

Rajesh@
Messages: 22
Registered: January 2014
Location: Hyderabad

Junior Member

Thanx manubatham20 , got it.. Smile

select empno,NVL(TO_CHAR(mgr), 'NO Manager') from emp

Report message to a moderator

Re: ORA-00923: FROM keyword not found where expected error [message #607098 is a reply to message #607095]

Sun, 02 February 2014 23:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SQL> select empno,nvl(to_char(mgr),'no manager'))  from emp;
select empno,nvl(to_char(mgr),'no manager'))  from emp
                                           *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected

2 open & 3 close

Report message to a moderator

Previous Topic:	Synonym - DB link
Next Topic:	seperate out the string occured between particular characters

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 20:58:24 CDT 2024