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.
Answer Posted / mathivanan
select extractvalue(columnname,'/roottag/subtag') from tablename
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What does closing a cursor do?
What is the difference between unique and primary key constraints?
What is execute immediate?
What is sql key?
What are the possible values for the boolean data field?
How is debugging done?
How to select unique records from a table?
What does the base_object_type column shows in the user.triggers data dictionary view?
What is raw datatype in sql?
what is single byte over head in oracle..?
Which sql statement is used to delete data from a database?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is offset in sql query?
Which is better join or subquery?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?