Hi All,
I have a view which have a column
create view ABC as
select
EXECUTIVE_SUMMARY
from table EXECUTIVE;
The datatype is varchar2(4000 byte).
this column contain some special character
so when i try to insert its record into a table
using
create table try as select * from EXECUTIVE;
its through an error Actual value in EXECUTIVE_SUMMARY is 4006 where the column is 4000
Please suggest me how i can cast this column to LONG type in this view defination.