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 a record in a database?

989

Which one is better subquery or joins?

1007

Does a user_objects view have an entry for a trigger?

958

how does a local variable is defined using t-sql? : Transact sql

945

How to look at the current sql*plus system settings?

1076

What is procedure and function in sql?

927

what is transaction? : Sql dba

958

Which join is default?

894

what are the types of join and explain each? : Sql dba

989

What is memory optimized table?

984

tell us something about heap tables. : Sql dba

1047

what is a record in a database ? : Sql dba

992

Is sql a microsoft product?

894

What is difference between pl and sql?

990

What is foreign key and example?

883