To force type CHAR in a view

(excuse me, my inglish is not very good)

When i create the view V1 I will want to create a column NEW_COL1 CHAR(10) and not VARCHAR2(10)

Because I have a utility which at the time of the joint of the view V1 and a table with a column in char(10),
detects the difference in type.

SQL> create table t1 (col1 varchar2(8));

SQL> desc t1

 Name                         Type
 ---------------------- -----------------
 COL1                        VARCHAR2(8)

SQL> CREATE OR REPLACE VIEW V1 AS
select col1,

       rpad(col1,10,' ') new_col1
  from t1
/

SQL> desc v1

 Name                       Type
 --------------------- -----------------
 COL1                       VARCHAR2(8)
 NEW_COL1            VARCHAR2(10)

I will want to create a column NEW_COL1 ==> CHAR(10)

Thanks in Advance..
With My Best Regards...
Christophe Received on Mon Oct 07 2002 - 08:21:23 CDT