select extractvalue(columnname,'/roottag/subtag') from tablename

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.

Question Posted / mathivanan

Answer Posted / mathivanan

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can sql developer connect to db2?

1053

What does dml mean?

988

Can we have two clustered index on a table?

1025

What is data definition language?

1093

What are different types of statements supported by sql?

1165

What is the need of a partition key?

987

What is query syntax?

972

What is synchronized subquery?

1169

How to select unique records from a table?

1059

How can I speed up sql query?

963

What is difference between db2 and sql?

1001

explain what is mysql? : Sql dba

1082

How do I view a procedure in sql?

974

what is dbms? : Sql dba

995

what is a database? : Sql dba

1173