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 the difference between inner join and outer join?

1002

How do I run a sql trace?

966

What is a record in a database?

1071

What is function and procedure in pl sql?

1057

Why truncate is faster than delete?

1121

Can we insert data into view?

910

What is pl sql commands?

1050

what is data manipulation language? : Sql dba

1026

Why trigger is used in sql?

980

How do I trace sql profiler?

995

can a stored procedure call itself or recursive stored procedure? : Sql dba

1039

what is the difference between clustered and non clustered index in sql? : Sql dba

1134

What is the need of a partition key?

991

Is sql an operating system?

1023

What is the default isolation level in sql server? : Transact sql

1040