Sample 2

CREATE TABLE STUDENT
    (Sl_No NUMBER(2),
    Name VARCHAR(20),
    Id NUMBER(10),
    Dept VARCHAR(10));
INSERT INTO STUDENT values('1','Sneha','10045','IT');
INSERT INTO STUDENT values('2','Lavanya','10067','IT');
INSERT INTO STUDENT values('3','Hari','20139','CSE');
INSERT INTO STUDENT values('4','Deepti','30384','MECH');
INSERT INTO STUDENT values('5','Kayal','10628','IT');
INSERT INTO STUDENT values('6','Mithra','40453','ECE');
INSERT INTO STUDENT values('8','Sam','50726','EEE');
DELETE FROM STUDENT WHERE Name='Sam';
SELECT * FROM STUDENT;