KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I am using Oracle's XML DB to create user profiles. I stored user profiles in a single XMLTYPE column with other relational columns (id, username, password) in the table. The XML is of the following format: <profile> <subject>I <action>like <object>sports</object> ... <object>music</object </action> </subject> </profile> I used the following query, SELECT * FROM user, XMLTABLE( '//profile' PASSING user.profile return COLUMNS action VARCHAR2(20) PATH '/subject/action', object VARCHAR2(30) PATH '/subject/action/object' ); which gives me nothing. How could I make this thing work?
Tags (comma-separated)
Save Edits
Cancel