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

How can I tell if sql is running?

1014

Which is faster view or stored procedure?

898

what is offset-fetch filter in tsql? : Transact sql

902

what is the difference between char_length and length? : Sql dba

1005

What is constant in pl sql?

986

What is a primary key sql?

1012

What sql does db2 use?

946

What is graph sql?

947

What is Difference Between Unique and Primary Key Constraints?

1073

Explain the advantages and disadvantages of stored procedure?

1096

Is sql a backend?

977

Define concurrency control. : Transact sql

1127

What is a heap in sql?

1008

What is execution plan in sql?

997

What is linq to sql?

1086