SOL语句: INSERT INTO \(\\) VALUES ('000001' ,'王林' ,TO_DATE('23-1月-1966', 'dd-Mon-yyyy HH:MI:SS AM') ,1 ,'中山路32-1-508' ,'210003' ,'83355668' ,'2' )
INSERT INTO \(\\) VALUES ('010008' ,'伍荣华' ,TO_DATE('28-3月-1976', 'dd-Mon-yyyy HH:MI:SS AM') ,1 ,'北京东路100-2' ,'210001' ,'83321321' ,'4' )
INSERT INTO \(\\) VALUES ('020010' ,'王向荣' ,TO_DATE('09-12月-1982', 'dd-Mon-yyyy HH:MI:SS AM') ,1 ,'四牌楼10-0-108' ,'210006' ,'83792361' ,'1' )
INSERT INTO \(\\) VALUES ('020018' ,'李莉' ,TO_DATE('30-7月-1976', 'dd-Mon-yyyy HH:MI:SS AM') ,0 ,'中山东路102-2' ,'210002' ,'83413301' ,'1' )
INSERT INTO \(\\) VALUES ('102201' ,'刘明' ,TO_DATE('02-9月-1965', 'dd-Mon-yyyy HH:MI:SS AM') ,1 ,'虎踞路100-2' ,'210013' ,'83606608' ,'5' )
INSERT INTO \(\\) VALUES ('102208' ,'朱俊' ,TO_DATE('10-8月-1979', 'dd-Mon-yyyy HH:MI:SS AM') ,1 ,'牌楼巷5-3-106' ,'210004' ,'84708817' ,'5' )
INSERT INTO \(\\) VALUES ('108991' ,'忠民' ,TO_DATE('01-10月-1974', 'dd-Mon-yyyy HH:MI:SS AM') ,1 ,'中山路10-3-105' ,'210003' ,'83346722' ,'3' )
(3)表Salary中插入记录
SOL语句:
INSERT INTO \(\,\,\VALUES ('000001' ,2100.8 ,123.09 )
INSERT INTO \(\,\,\VALUES ('010008' ,1582.62 ,88.03 )
INSERT INTO \(\,\,\VALUES ('102201' ,2569.88 ,185.65 )
INSERT INTO \(\,\,\VALUES ('108991' ,3259.98 ,281.52 )
INSERT INTO \(\,\,\VALUES ('020010' ,2860.0 ,198.0 )
INSERT INTO \(\,\,\VALUES ('020018' ,2347.68 ,180.0 )
INSERT INTO \(\,\,\VALUES ('102208' ,1980.0 ,100.0 )
2、用PL/SOL语句向表Employ、表Departments、表Salary中插入记录:
) ) ) ) ) ) )
4.1.4实践操作4
1、建立索引:
2、实现域完整性:
注:该同学此题完成有误,下面给出另一同学的正确解答
为数据库中的employees表的phonenumber列建立check约束:
3、实现实体完整性:
(1)为表Departments设置主键DepartmentID:
(2)为表Departments的DepartmentName建立唯一性索引:
4实现参照完整性:
4.1.5实践操作5
1、 SELECT语句的基本使用: