data type size for the view column
I am creating a view from base table using substr() for some fields. The data type size of the column in the view becomes twice the size of the corresponding column in the base table. Example
SQL> create table temp_sat(name varchar2(20));
Table created.
SQL> create view temp_view as select substr(name,1,10) name from temp_sat;
View created.
SQL> desc temp_view
Name Null? Type
----------------------------------------- -------- ----------------------------
NAME VARCHAR2(40)
Can i specify the size of the column while creating view