Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle CTE problem

PSULionRPOct 16 2013 — edited Oct 17 2013

We are in version PL/SQL Release 11.2.0.3.0 - Production

I have this SQL...

WITH 

      MemberSpanLast  AS  (

          SELECT  MEMBER.CONTRACT_NBR,

                  COUNT(*)  AS Contract_Count

          FROM    AMIOWN.MEMBER

          GROUP BY  MEMBER.CONTRACT_NBR

          ORDER BY MEMBER.CONTRACT_NBR)

SELECT  *

FROM    MemberSpanList

;

When I run it I am getting this error...

ORA-00942: table or view does not exist

00942. 00000 -  "table or view does not exist"

*Cause:   

*Action:

Error at Line: 9 Column: 9

What am I doing wrong???

Hoping someone can help me out.

Thanks in advance.

PSULionRP

This post has been answered by L-MachineGun on Oct 16 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 14 2013
Added on Oct 16 2013
3 comments
1,085 views