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

What is compiled query?

1081

what are the disadvantages of mysql? : Sql dba

1194

What is the life of an sql statement?

1071

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

1010

How many sql are there?

1047

Does sap use sql?

1035

How can I make sql query run faster?

1060

How to disable a trigger name update_salary?

1307

What is difference between rank () row_number () and dense_rank () in sql?

1157

What is memory optimized table?

1081

Why indexing is needed?

1040

What is a left inner join?

1068

How do I create a sql database?

1048

How does sql*loader handles newline characters in a record? : aql loader

1087

what are the difference between clustered and a non-clustered index? : Sql dba

1079