3 Replies Latest reply on Oct 17, 2013 12:20 PM by Hoek

    Oracle Virtual Tables, Equivalent to Common Table Expression

    PSULionRP

      I hope someone can help me out here. We are on an Oracle platform Release PL/SQL Release 11.2.0.3.0 - Production.

       

      I believe the syntax for creating Oracle Virtual Tables changed with Version 11. but when I try WITH and then SELECT FROM MyTable I get an error Oracle Error ORA-00942: table or view does not exist.

       

      (If I'm in the wrong forum, please tell me...)

       

      I know that I used to use different syntax for creating a virtual table in previous versions of Oracle but I don't know what it was called.

       

      Can someone please help me out here and point me in the right direction as to what the syntax might be for creating an Oracle Virtual Table?

       

      Thanks for your review and am hopeful for a reply.

       

      PSULionRP