select from an XMLview

I have created an view of XMLtypes (create or replace view myView of xmltype with object id ...).

When I make "select count(*) from myView" I get 3 rows, and when I get
"select * from myView" I get the three blocks of XML.

I am interested an adding a where-clause to my select, above, so I can limit the output to one row. Something like:

"select * from myView where account = 1234" (account is part of the flat
table that the view is using)

Anyone has any idea how that is done?

Best regards
Dannie Received on Fri Jan 17 2003 - 12:47:15 CET