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


Please Help Members By Posting Answers For Below Questions

No New Questions to Answer in this Category !!    You can

Post New Questions

Answer Questions in Different Category