python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - clob

Getting the last character in an Oracle CLOB column

I am having an issue with getting the last character from an Oracle CLOB column. The same SQL that works on an VARCHAR column doesn't work on a CLOB column and can't figure out why or how to make it w...
test-img

brent thomas

oracle

substr

clob

Votes: 0

Answers: 2

Latest Answer

Works for my simple test case: SQL> create table test (col clob); Table created. SQL> insert into test (col) values ('This is a cloB'); 1 row created. SQL> select substr(col, length(col),...
test-img

Littlefoot

CLOB to Zip file

I have CLOB column in Oracle DB which contains XML files. How can I create single zip file which will contain all xml files from clob column? Only one row is there in table which has this CLOB column ...
test-img

ninad

xml

oracle

plsql

clob

Votes: 0

Answers: 1

Latest Answer

You can leverage the APEX_ZIP package to query your CLOB column(s) and add them all to a zip file that will be stored in a BLOB. You can then do whatever you need with that BLOB. DECLARE l_temp_bl...
test-img

EJ Egyed

Posts

Questions

Blogs

Jobs