CLOB and BLOB both fall in the category called a LOB .ie large object.
BLOB stands for binary large object and CLOB stand for character large object.
- BLOB is used for Pictures, Music, Word documents.
- CLOB is used for text data such as Text, HTML, XML or Rich Text (RTF).
When we query a table containing BLOB or CLOB using SQL assistant it will ask you to provide a filename that will be used to store the data on your local machine.Each LOB data value will be written to a separate file.
Name we provide will be used as base and then followed by a number for each row.
Support for large objects was added to SQL Assistant in version 6.2.
Some (older) versions of SQL Assistant require that you set the ODBC DSN option "Use Native Large Object support" for this to work.
give some example command for clob & blob.
ReplyDeleteIt will be useful to use.
Is there a way to force CLOBs to strings without having to have multiple casts in your query, which is ugly.
ReplyDeletespark training
ReplyDeletescala training
azure devops training
tableau training
SAP BW on Hana training
sap sd training
osb training