how to read values in field clob.

georgipa · #1 (**permalink**) 02-02-12, 11:18

Hi colleagues,
Somebody can say me how to read a values in a table with data type clob?
Thank you for advanced.

n_i · #2 (**permalink**) 02-02-12, 11:39

Code:

select myclob from mytable

georgipa · #3 (**permalink**) 02-02-12, 16:13

excuse me before i do not explain me fine, i have the followind table.
create table xxxxx
( aaa int,
bbb char(20),
ccc varchar(200),
ddd clob(5000))

I need read the values in field ddd. ¿ How to do this operation?

Thank you for you help.

n_i · #4 (**permalink**) 02-02-12, 16:25

Code:

select ddd from xxxxx

stolze · #5 (**permalink**) 02-02-12, 17:45

Let me ask a different question: why do you believe that a CLOB is different from a VARCHAR? From an application's point of view, both are strings of characters and you deal with them in the same way.

Internet Services

Web Development

Digital Marketing

Consumer Tech