Posted By

bbrumm on 03/06/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 03/06/17 03:17pm

Statistics

Viewed 3441 times

Favorited by 0 user(s)

Related snippets

Oracle TO_LOB Function

/ Published in: SQL

A few examples of the TO_LOB function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

CREATE TABLE first_table (
id NUMBER,
longval LONG
);
 
INSERT INTO first_table (id, longval) VALUES (1, 120034);
 
 
CREATE TABLE second_table (
id NUMBER,
clobval CLOB
);
 
INSERT INTO second_table (id, clobval) (
SELECT id, TO_LOB(longval) FROM first_table
);
 
SELECT id, clobval
FROM second_table;