The field is specified as Long. No length is specified. I think It can take beyond 4000bytes also.


A) What to do, if it is > 4000bytes.

B)
For the long < 4000, can i write a pl/sql block to
1) read from one table into a cursor
2) open cursor
3) from cursor insert into another table.
Badrinath.