How to query a CLOB column in Oracle

by

This works

select DBMS_LOB.substr(myColumn, 3000) from myTable

More Related Contents:

  1. Splitting string into multiple rows in Oracle
  2. Is there a combination of “LIKE” and “IN” in SQL?
  3. What is the string concatenation operator in Oracle?
  4. REGEX to select nth value from a list, allowing for nulls
  5. SQL to generate a list of numbers from 1 to 100
  6. How to use BOOLEAN type in SELECT statement
  7. SQL recursive query on self referencing table (Oracle)
  8. How can you tell if a value is not numeric in Oracle?
  9. create table with sequence.nextval in oracle [duplicate]
  10. IF EXISTS condition not working with PLSQL
  11. PLS-00428: an INTO clause is expected in this SELECT statement
  12. passing table and column name dynamically using bind variables
  13. SQL error “ORA-01722: invalid number”
  14. WHERE IN condition not accepting String value
  15. Sleep function in ORACLE
  16. Solution to “cannot perform a DML operation inside a query”?
  17. Array in IN() clause oracle PLSQL
  18. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  19. What does the colon sign “:” do in a SQL query?
  20. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  21. Issue when comparing result of to_char(myDate, ‘DAY’) to a string
  22. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  23. How to handle optional parameters in SQL query?
  24. Oracle- Split string comma delimited (string contains spaces and consecutive commas)
  25. How to use Alias in Where clause? [duplicate]
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. Subtracting Dates in Oracle – Number or Interval Datatype?
  28. How to call Oracle MD5 hash function?
  29. Exporting a CLOB to a text file using Oracle SQL Developer
  30. Using bind variables with dynamic SELECT INTO clause in PL/SQL

Leave a Comment