Oracle Ocean: Benefits of PLSQL over SQL

One of the benefits, mentioned below, might be very useful in term of performance improvement while inserting huge number of records through multiple INSERT statements script.

The SQL statements are sent to the Oracle server one at a time. Each SQL statement results in a separate call to the Oracle server and hence higher performance overhead.

However if all these statements are grouped into one PLSQL block, all statements are passed to the Oracle server as one call and hence giving a significant performance improvement by reducing the network traffic.

You can test it yourself.

Execute the attached 2 scripts, SQL.sql and PLSQL.sql (Place these in C drive) one after another and you will see the significant difference between the times taken by 2 scripts.

SQL > @C:\SQL.sql

SQL_INSERT_START_TIME

--------------------------

23-NOV-2010 10:15:35

SQL_INSERT_END_TIME

--------------------------

23-NOV-2010 10:19:50

Here time taken to insert 250 records (As present in the script) is 255 Seconds.

SQL > @C:\PLSQL.sql

PLSQL_INSERT_START_TIME

--------------------------

23-NOV-2010 10:21:21

PLSQL_INSERT_END_TIME

--------------------------

23-NOV-2010 10:21:25

SQL >

Here time taken to insert 250 records (As present in the script) is just 4 Seconds.

Execution time is reduced by 64 times J J

-- SQL.sql

SET TIMING OFF

SET FEEDBACK OFF

SET TERMOUT OFF

DROP TABLE emp;

CREATE TABLE emp

(

empid NUMBER

,empname VARCHAR2(10)

,deptid NUMBER

);

SET TERMOUT ON

SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') SQL_INSERT_START_TIME

FROM DUAL;

SET TERMOUT OFF

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(1,'A1',1001);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(2,'A2',1002);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(3,'A3',1003);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(4,'A4',1004);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(5,'A5',1005);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(6,'A6',1006);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(7,'A7',1007);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(8,'A8',1008);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(9,'A9',1009);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(10,'A10',1010);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(11,'A11',1011);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(12,'A12',1012);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(13,'A13',1013);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(14,'A14',1014);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(15,'A15',1015);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(16,'A16',1016);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(17,'A17',1017);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(18,'A18',1018);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(19,'A19',1019);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(20,'A20',1020);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(21,'A21',1021);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(22,'A22',1022);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(23,'A23',1023);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(24,'A24',1024);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(25,'A25',1025);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(26,'A26',1026);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(27,'A27',1027);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(28,'A28',1028);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(29,'A29',1029);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(30,'A30',1030);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(31,'A31',1031);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(32,'A32',1032);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(33,'A33',1033);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(34,'A34',1034);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(35,'A35',1035);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(36,'A36',1036);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(37,'A37',1037);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(38,'A38',1038);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(39,'A39',1039);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(40,'A40',1040);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(41,'A41',1041);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(42,'A42',1042);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(43,'A43',1043);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(44,'A44',1044);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(45,'A45',1045);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(46,'A46',1046);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(47,'A47',1047);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(48,'A48',1048);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(49,'A49',1049);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(50,'A50',1050);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(51,'A51',1051);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(52,'A52',1052);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(53,'A53',1053);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(54,'A54',1054);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(55,'A55',1055);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(56,'A56',1056);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(57,'A57',1057);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(58,'A58',1058);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(59,'A59',1059);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(60,'A60',1060);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(61,'A61',1061);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(62,'A62',1062);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(63,'A63',1063);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(64,'A64',1064);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(65,'A65',1065);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(66,'A66',1066);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(67,'A67',1067);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(68,'A68',1068);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(69,'A69',1069);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(70,'A70',1070);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(71,'A71',1071);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(72,'A72',1072);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(73,'A73',1073);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(74,'A74',1074);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(75,'A75',1075);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(76,'A76',1076);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(77,'A77',1077);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(78,'A78',1078);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(79,'A79',1079);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(80,'A80',1080);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(81,'A81',1081);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(82,'A82',1082);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(83,'A83',1083);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(84,'A84',1084);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(85,'A85',1085);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(86,'A86',1086);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(87,'A87',1087);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(88,'A88',1088);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(89,'A89',1089);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(90,'A90',1090);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(91,'A91',1091);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(92,'A92',1092);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(93,'A93',1093);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(94,'A94',1094);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(95,'A95',1095);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(96,'A96',1096);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(97,'A97',1097);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(98,'A98',1098);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(99,'A99',1099);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(100,'A100',1100);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(101,'A101',1101);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(102,'A102',1102);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(103,'A103',1103);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(104,'A104',1104);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(105,'A105',1105);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(106,'A106',1106);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(107,'A107',1107);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(108,'A108',1108);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(109,'A109',1109);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(110,'A110',1110);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(111,'A111',1111);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(112,'A112',1112);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(113,'A113',1113);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(114,'A114',1114);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(115,'A115',1115);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(116,'A116',1116);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(117,'A117',1117);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(118,'A118',1118);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(119,'A119',1119);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(120,'A120',1120);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(121,'A121',1121);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(122,'A122',1122);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(123,'A123',1123);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(124,'A124',1124);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(125,'A125',1125);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(126,'A126',1126);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(127,'A127',1127);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(128,'A128',1128);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(129,'A129',1129);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(130,'A130',1130);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(131,'A131',1131);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(132,'A132',1132);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(133,'A133',1133);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(134,'A134',1134);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(135,'A135',1135);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(136,'A136',1136);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(137,'A137',1137);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(138,'A138',1138);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(139,'A139',1139);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(140,'A140',1140);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(141,'A141',1141);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(142,'A142',1142);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(143,'A143',1143);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(144,'A144',1144);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(145,'A145',1145);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(146,'A146',1146);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(147,'A147',1147);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(148,'A148',1148);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(149,'A149',1149);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(150,'A150',1150);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(151,'A151',1151);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(152,'A152',1152);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(153,'A153',1153);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(154,'A154',1154);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(155,'A155',1155);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(156,'A156',1156);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(157,'A157',1157);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(158,'A158',1158);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(159,'A159',1159);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(160,'A160',1160);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(161,'A161',1161);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(162,'A162',1162);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(163,'A163',1163);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(164,'A164',1164);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(165,'A165',1165);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(166,'A166',1166);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(167,'A167',1167);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(168,'A168',1168);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(169,'A169',1169);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(170,'A170',1170);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(171,'A171',1171);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(172,'A172',1172);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(173,'A173',1173);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(174,'A174',1174);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(175,'A175',1175);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(176,'A176',1176);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(177,'A177',1177);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(178,'A178',1178);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(179,'A179',1179);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(180,'A180',1180);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(181,'A181',1181);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(182,'A182',1182);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(183,'A183',1183);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(184,'A184',1184);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(185,'A185',1185);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(186,'A186',1186);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(187,'A187',1187);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(188,'A188',1188);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(189,'A189',1189);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(190,'A190',1190);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(191,'A191',1191);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(192,'A192',1192);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(193,'A193',1193);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(194,'A194',1194);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(195,'A195',1195);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(196,'A196',1196);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(197,'A197',1197);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(198,'A198',1198);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(199,'A199',1199);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(200,'A200',1200);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(201,'A201',1201);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(202,'A202',1202);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(203,'A203',1203);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(204,'A204',1204);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(205,'A205',1205);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(206,'A206',1206);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(207,'A207',1207);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(208,'A208',1208);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(209,'A209',1209);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(210,'A210',1210);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(211,'A211',1211);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(212,'A212',1212);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(213,'A213',1213);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(214,'A214',1214);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(215,'A215',1215);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(216,'A216',1216);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(217,'A217',1217);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(218,'A218',1218);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(219,'A219',1219);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(220,'A220',1220);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(221,'A221',1221);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(222,'A222',1222);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(223,'A223',1223);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(224,'A224',1224);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(225,'A225',1225);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(226,'A226',1226);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(227,'A227',1227);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(228,'A228',1228);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(229,'A229',1229);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(230,'A230',1230);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(231,'A231',1231);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(232,'A232',1232);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(233,'A233',1233);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(234,'A234',1234);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(235,'A235',1235);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(236,'A236',1236);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(237,'A237',1237);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(238,'A238',1238);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(239,'A239',1239);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(240,'A240',1240);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(241,'A241',1241);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(242,'A242',1242);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(243,'A243',1243);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(244,'A244',1244);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(245,'A245',1245);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(246,'A246',1246);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(247,'A247',1247);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(248,'A248',1248);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(249,'A249',1249);

INSERT INTO EMP (EMPID,EMPNAME,DEPTID) VALUES(250,'A250',1250);

SET TERMOUT ON

SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') SQL_INSERT_END_TIME

FROM DUAL;

SET FEEDBACK ON

/*******************************************************************************/

--PLSQL.sql

SET TIMING OFF

SET FEEDBACK OFF

SET TERMOUT OFF

DROP TABLE emp;

CREATE TABLE emp

(

empid NUMBER

,empname VARCHAR2(10)

,deptid NUMBER

);

SET TERMOUT ON

SELECT TO_CHAR(SYSDATE,'DD-MON-YYYY HH:MI:SS') PLSQL_INSERT_START_TIME

FROM DUAL;

SET TERMOUT OFF

BEGIN