table "test" has col1 which is varchar2(10)
create view testv as (select substr(col1,1,3) firstthree from test);
desc testv
Name Null? Type
FIRSTTHREE VARCHAR2(9)
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 |