How do I get textual contents from BLOB in Oracle SQL

by

First of all, you may want to store text in CLOB/NCLOB columns instead of BLOB, which is designed for binary data (your query would work with a CLOB, by the way).

The following query will let you see the first 32767 characters (at most) of the text inside the blob, provided all the character sets are compatible (original CS of the text stored in the BLOB, CS of the database used for VARCHAR2) :

select utl_raw.cast_to_varchar2(dbms_lob.substr(BLOB_FIELD)) from TABLE_WITH_BLOB where ID = '<row id>';

More Related Contents:

  1. What is it exactly a BLOB in a DBMS context
  2. How to create id with AUTO_INCREMENT on Oracle?
  3. LISTAGG in Oracle to return distinct values
  4. Fetch the row which has the Max value for a column
  5. Oracle SQL: Update a table with data from another table
  6. How to handle a single quote in Oracle SQL
  7. Oracle SQL – How to Retrieve highest 5 values of a column [duplicate]
  8. Fetch the rows which have the Max value for a column for each distinct value of another column
  9. SQL to generate a list of numbers from 1 to 100
  10. How to use BOOLEAN type in SELECT statement
  11. How to show all privileges from a user in oracle?
  12. SQL – How to select a row having a column with max value [duplicate]
  13. Oracle: loading a large xml file?
  14. IF EXISTS condition not working with PLSQL
  15. Group by alias (Oracle)
  16. Using pivot on multiple columns of an Oracle row
  17. Sleep function in ORACLE
  18. Solution to “cannot perform a DML operation inside a query”?
  19. Why can’t I seem to force Oracle 11g to consume more CPUs for a single SQL query
  20. create custom function for date difference excluding weekends and holidays in oracle sql
  21. Custom Order in Oracle SQL
  22. Is there a version control system for database structure changes?
  23. Oracle: Updating a table column using ROWNUM in conjunction with ORDER BY clause
  24. Compare Strings ignoring accents in SQL (ORACLE)
  25. How to check if a column exists before adding it to an existing table in PL/SQL?
  26. How can I solve ORA-00911: invalid character error?
  27. What’s the correct name for an “association table” (a many-to-many relationship) [closed]
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. Exporting a CLOB to a text file using Oracle SQL Developer
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment