adspace
write a sql query retrive all xml data.
how to retrive xml data wit single sql query.
Answer Posted / Abhilash Mishra
SQL does not directly handle XML data natively. To work with XML in SQL, you would typically use Extensible Stylesheet Language (XSL) or XQuery depending on the database management system you're using. However, storing XML as Binary Large Object (BLOB) and reading it back into a string can be done with SQL:
```sql
SELECT BINARY_TO_CHAR(xml_column) AS xml_data FROM table_name;
```
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category