scissorhand
asked on
Create A View Column with Data Type varchar2(32) and NULL Value
I am trying to create a view in Oracle, inside the view there is a column with null value, but I want the column to be varchar2(32) data type, I try to use cast but the data type still remain as varchar2(0), please advise, the code is roughly as below
create view a
as
select <column>,null from <table>
I make it as below but the data type is still varchar2(0) for the null value
create view a
as
select <column>,cast(null as varchar2(32)) from <table>
create view a
as
select <column>,null from <table>
I make it as below but the data type is still varchar2(0) for the null value
create view a
as
select <column>,cast(null as varchar2(32)) from <table>
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.