create table t_clob_cols (txt clob)Table created.
insert into t_clob_cols (txt) values ('Employee ID: 1
Hire Date: 24-Oct-2013
Name: XXXXX
Department: IT
Employee ID : 2
Name : YYYYY
Hire Date : 20-May-2014
Department: ITIS
Hire Date: 17-May-2017
Department:SMO
Name: ZZZZZ
Employee ID: 3')1 row(s) inserted.
select * from t_clob_cols| TXT | Employee ID: 1 Hire Date: 24-Oct-2013 Name: XXXXX Department: IT Employee ID : 2 Name : YYYYY Hire Date : 20-May-2014 Department: ITIS Hire Date: 17-May-2017 Department:SMO Name: ZZZZZ Employee ID: 3 |
|---|