create view as select to_number(person_no) from tb
create view as select to_number(nvl(person_no,0)) from tb
可以转了。但是我那个字段的号码太长,to_number后有问题了。
create table person( p_no varchar2(5), pname varchar2(20), sex char(1), age number(3), address varchar2(50)); SQL> select * from person ;P_NO PNAME SEX AGE ADDRESS ----- -------------------- --- ---- -------------------------------------------------- 1001 James M 56 Mexco--P_NO左对齐,说明是字符类型 1002 Scott F 22 Tokyo 1003 Smith M 18 Beijing 1004 yeeXun M 22 China 1005 Lili -- create view view_person as select to_number(nvl(p_no,0)) p_no,pname,age from person; SQL> select * from view_person; P_NO PNAME AGE ---------- -------------------- ---- 1001 James 56--P_NO右对齐,说明是number类型 1002 Scott 22 1003 Smith 18 1004 yeeXun 22 1005 Lili
select to_number(person_no) from tb
select to_number(nvl(person_no,0)) from tb
create table person(
p_no varchar2(5),
pname varchar2(20),
sex char(1),
age number(3),
address varchar2(50));
SQL> select * from person ;P_NO PNAME SEX AGE ADDRESS
----- -------------------- --- ---- --------------------------------------------------
1001 James M 56 Mexco--P_NO左对齐,说明是字符类型
1002 Scott F 22 Tokyo
1003 Smith M 18 Beijing
1004 yeeXun M 22 China
1005 Lili
--
create view view_person
as
select to_number(nvl(p_no,0)) p_no,pname,age from person;
SQL> select * from view_person; P_NO PNAME AGE
---------- -------------------- ----
1001 James 56--P_NO右对齐,说明是number类型
1002 Scott 22
1003 Smith 18
1004 yeeXun 22
1005 Lili