i have xml source. xml source having lacks of records. i
want extract/retrive xml source data using sql query.
please tell me how to write query.
- 4 Answers
- 7571 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / mathivanan
select extractvalue(columnname,'/roottag/subtag') from tablename
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is join and inner join the same?
Which table is left in join?
What are transaction and its controls?
What is a unique constraint?
How to revise and re-run the last sql command?
What is the primary key?
What has stored procedures in sql?
What are the operators used in select statements?
What do you mean by “trigger” in sql?
What is rollback?
What are stuff and replace function?
Explain raise_application_error.
what are the types of subquery? : Sql dba
How many joins can you have in sql?
How do I remove all records from a table?
