select * returns CLOB

Question

I have not used oracle before and I was to modify the clob data as it has my home phone number. But when I do select * from table shows CLOB and I cannot see the data. How can I see the data and how to I Update?

I need the query.

Solution 1

In PL/SQL Developer, select ROWID along with table columns:

SELECT  t.*, t.rowid
FROM    mytable t

This will allow you to edit the table's data.

Then just check a ... button near the CLOB field and edit it.

You can load it from file or just type into the edit field.

Solution 2

What tool are you using to perform the query? sqlplus will truncate select from a clob column to the value of the parameter long. If you are using sqlplus then set long to a large enough value to hold the clob and then doing a simple select should return data. Clobs are just text so it can be query as any other column in a table. If you are using sqlplus and it returns nothing instead of partial, then make sure the column in the table is populated.