你即將離開本站

並前往https://asktom.oracle.com/pls/apex/f?p=100:11:0::no::p11_question_id:367980988799

Converting CLOBS TO VARCHAR - Ask TOM

select dbms_lob.substr( x, 4000, 1 ) from T; will get me the first 4000 bytes of the clob. Note that when using SQL as I did, the max length is 4000.

確定！ 回上一頁

查詢 「Oracle select CLOB」的人也找了：

  1. Oracle select CLOB
    2.
  2. Oracle CLOB to string
    3.
  3. Oracle CLOB SUBSTR
    4.
  4. TO_CLOB
    5.
  5. Oracle update CLOB
    6.
  6. Oracle CLOB print
    7.
  7. Oracle query CLOB slow
    8.
  8. Oracle CLOB to file
    9.