write a sql query retrive all xml data.
how to retrive xml data wit single sql query.
- 1 Answers
- 2463 Views
- TCS, I also Faced
- E-Mail Answers
Answer / 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 |
what is the difference between a web service and SOA?
Explain about SOAP with an example of Industry usage.
what is the diffrence between xmlparsing and json parsing?
Inside the soapui where groovy script can be used?
What are the tools used for testing web services?
State the syntax rule for soap message?
What are the advantages and disadvantages of soap?
List out important characteristics of soap envelop element?
Explain about HTTPS in SOAP?
what is SOAP envelop element?
How can user use the facilities that are provided by soap?
Can soap use rest?
HTML DHTML 
