OraFAQ Forum: SQL & PL/SQL » WITH Clause Help

Home » SQL & PL/SQL » SQL & PL/SQL » WITH Clause Help

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

WITH Clause Help [message #293031]

Thu, 10 January 2008 11:43

kam123
Messages: 13
Registered: January 2008

Junior Member

Hi Everyone,

Here is my query, when I run this query in TOAD I am getting error as "missing select keyword". Please suggest.

WITH eelist AS
(
SELECT al.process_level,al.deptname,al.department,al.emp_status,al.fte_total,al.employee
    FROM lrsuser.v_associatelist al
    WHERE 
      al.group_name='G:ACTIVE'
      AND 
      al.emp_status IN     ('CF','E9','EF','N9','NF','CA','EA','NA','CB','EB','NB')
)

Thank You!

Report message to a moderator

Re: WITH Clause Help [message #293033 is a reply to message #293031]

Thu, 10 January 2008 11:51

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

What do you want to achieve from this?
When you want to use similar queries more than once, you can use WITH.

By
Vamsi

Report message to a moderator

Re: WITH Clause Help [message #293035 is a reply to message #293031]

Thu, 10 January 2008 12:01

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

WITH clause or subquery subfactoring clause is part of SELECT statement that must follow this WITH clause, see syntax diagram http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10002.htm#i2126435.
In what you posted you just have the WITH clause without the SELECT statement that referenced it.
So the error "missing SELECT keyword".

Regards
Michel

[Updated on: Thu, 10 January 2008 12:03]

Report message to a moderator

Re: WITH Clause Help [message #293355 is a reply to message #293035]

Fri, 11 January 2008 14:32

kam123
Messages: 13
Registered: January 2008

Junior Member

Thanks for your help!

Report message to a moderator

Previous Topic:	Is Primary Key Function
Next Topic:	Complex String Query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 17 16:45:53 CST 2025