insertdirector.sql

来自「oracle 9培训基础教程」· SQL 代码 · 共 9 行

INSERT INTO "SCOTT"."DIRECTOR" ("DIRECTOR_ID" ,"NAME" ,"ZHICHENG" ,"ZHIWU" ) 
                 VALUES (200201 ,'张三丰' ,'博导' ,'系主任');
INSERT INTO "SCOTT"."DIRECTOR" ("DIRECTOR_ID" ,"NAME" ,"ZHICHENG" ,"ZHIWU" )
                 VALUES (200202 ,'张翠山' ,'硕导' ,'室主任');
INSERT INTO "SCOTT"."DIRECTOR" ("DIRECTOR_ID" ,"NAME" ,"ZHICHENG" ,"ZHIWU" ) 
                 VALUES (200203 ,'张无忌' ,'硕导' ,'所主任' );
INSERT INTO "SCOTT"."DIRECTOR" ("DIRECTOR_ID" ,"NAME" ,"ZHICHENG" ,"ZHIWU" )
                 VALUES (200204 ,'宋远桥' ,'博导' ,'系副主任' );