Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change the datatype of a column in views

user13614933Jun 25 2021 — edited Jun 25 2021

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?

This post has been answered by mathguy on Jun 26 2021
Jump to Answer
Comments
Post Details
Added on Jun 25 2021
15 comments
2,882 views