CODEWITHSUNDEEP
oracle-databasexmltable
Pooja
Pooja

Reputation: 13

query xmltable oracle 10g

I have a query that used XML input to generate a XML table, I give that table an alias "XMLalias". How can I query this table in some other select statement, which is part of same batch.

I want to do something like " select * from XMLalias ".

I am new to oracle so please excuse if this is something really simple.

thanks.

Upvotes: 0

Views: 164

Answers (1)

Hard Worker
Hard Worker

Reputation: 1121

im not sure what you need exactly as i figure what you want is one of this two:

select * from
      (select * from XMLalias ) insider
where insider.col1  /*.....*/

Or you wanted someting like that

    select * 
        from XMLalias  a,
             XMLalias  b
where a.key_col=b.other_key_col
and  a.col1 = /*......  */
and  b.col2 = /*......  */

Upvotes: 0

Related Questions