Hi All
I want to change the datatypes of a column in views. I use cast(column name as char(3 char)) as column name
but it give me varchar2(). I want to change the datatype of a column from varchar2() to char. Is it because the whole column contain null values that cause it to remain as varchar2() instead of char?