This is the XML doc i have,
I want to do name search with Contains() or BeginsWith(), Oracle text search, I m not to figure out the steps to create index for these kind of XML nodes. Can some one help me out on this?
It would be great help if you guys explain me with some example since i am new to OracleXML DB.
Thanks for your response. Sorry if i was not clear.
Actually in relational tables, we are having contains search right, in the same way i would like to search with name in XMLTYPE data like below.
SELECT empid FROM EMP_DOC WHERE Contains('/Node/id["Name"]/Node1/value/response','Raja')>0 -- This syntax may not be right, But this is want i want to perform.
To do this, we need Oracle text indexes ,If i search with name in Oracle XMLTYPE, it should be faster, this is my aim.
Can you please help me out on this?
When i read the document, i am not finding exactly how should i create Text index for specific node "Name"(in my case), Also when i create text indexes to XMLTYPE, it's not at all getting created.
If you could let me know the steps to do this operation from Index creation for specific PATH, it would be really helpful.