Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2008

    Unanswered: What is DB2 WITH query Concept in Oracle

    What is DB2 WITH query Concept in Oracle?

    I want to store a query result set temporarily and then to join again different table.

  2. #2
    Join Date
    Nov 2003
    Provided Answers: 8
    If you mean the construct known as common table expression ("WITH ... SELECT .."), then Oracle supports the same thing. But there is far too little information to answer your question.

    I don't understand "store a query result". Why can't you simply join it?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts