update,在满足条件的列前加字符串! 表Employees的phonenumber字段长度不够长,长度只有七位,你可以用desc 命令查看表的结构信息desc Employees 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 一楼说的对。SQL语句没有问题,是字段长度不够。 这是建表:create table Employees( employeeID char(6), name char(10), address char(20), zip char(6), phonenumber char(12), emailaddress char(30), departmentID char(3), birthday date, sex number(1) constraint s_ck check(sex in(1,0)), constraint p_fk foreign key(departmentID)references Department(departmentID) );这是插入的数据: insert into Employees values('000001','王林','中山路','210003','3355668',null,'2',to_date('1956-1-23','yyyy-mm-dd'),1); insert into Employees values('010008','吴荣华','北京东路','210001','3321321',null,'1',to_date('1966-3-28','yyyy-mm-dd'),1); insert into Employees values('020010','王向荣','四牌楼','210006','792361',null,'1',to_date('1972-12-9','yyyy-mm-dd'),1); insert into Employees values('020018','李丽','中山东路','210002','3413301','[email protected]','1',to_date('1950-7-30','yyyy-mm-dd'),0); insert into Employees values('102201','刘明','虎巨路','210013','3606608',null,'5',to_date('1962-10-18','yyyy-mm-dd'),1); insert into Employees values('102208','朱俊','牌楼巷','210004','4708817','[email protected]','5',to_date('1955-9-28','yyyy-mm-dd'),1); insert into Employees values('108991','钟敏','中山路','210003','3346722','[email protected]','3',to_date('1969-8-10','yyyy-mm-dd'),0); insert into Employees values('111006','张石兵','解放路','210010','4563418','[email protected]','5',to_date('1964-10-1','yyyy-mm-dd'),1);为什么会被自动截成7位的?? LINUX 下ORACLE 11g 无法启动listener,求救 转换日期格式问题!!! 美资上市公司 DBA sql语句 列印有记录的表名,存储过程调不通,麻烦看看. 如何知道某一条记录是否被锁定? SQL*PLUS为何不能登录??? ora-01843 无效的月份 该如何处理???解决给分!!!! 有谁用oracle AQ高级消息队列做过大型应用程序? 高分求Oracle类似winhelp的帮助文件,要求可以查sql*plus函数什么的,立马结帐!! oracle 数据库 某名奇妙丢失数据 如何只插入数据库不存在的数据
employeeID char(6),
name char(10),
address char(20),
zip char(6),
phonenumber char(12),
emailaddress char(30),
departmentID char(3),
birthday date,
sex number(1)
constraint s_ck check(sex in(1,0)),
constraint p_fk foreign key(departmentID)references Department(departmentID)
);
这是插入的数据: insert into Employees values('000001','王林','中山路','210003','3355668',null,'2',to_date('1956-1-23','yyyy-mm-dd'),1);
insert into Employees values('010008','吴荣华','北京东路','210001','3321321',null,'1',to_date('1966-3-28','yyyy-mm-dd'),1);
insert into Employees values('020010','王向荣','四牌楼','210006','792361',null,'1',to_date('1972-12-9','yyyy-mm-dd'),1);
insert into Employees values('020018','李丽','中山东路','210002','3413301','[email protected]','1',to_date('1950-7-30','yyyy-mm-dd'),0);
insert into Employees values('102201','刘明','虎巨路','210013','3606608',null,'5',to_date('1962-10-18','yyyy-mm-dd'),1);
insert into Employees values('102208','朱俊','牌楼巷','210004','4708817','[email protected]','5',to_date('1955-9-28','yyyy-mm-dd'),1);
insert into Employees values('108991','钟敏','中山路','210003','3346722','[email protected]','3',to_date('1969-8-10','yyyy-mm-dd'),0);
insert into Employees values('111006','张石兵','解放路','210010','4563418','[email protected]','5',to_date('1964-10-1','yyyy-mm-dd'),1);
为什么会被自动截成7位的??