table "test" has col1 which is varchar2(10)
create view testv as (select substr(col1,1,3) firstthree from test);
Name Null? Type
Why is this varchar2(9) instead of varchar2(3)?
Results 1 to 4 of 4
Thread: view column length problem
Click Here to Expand Forum to Full Width