How to use DELETE command in SQL

--====================================================

DML - DELETE

--====================================================

select * from XX_EMP_TL

WHERE  EMP_ID = 100

DESC XX_EMP_TL

DELETE FROM  XX_EMP_TL

WHERE  EMP_ID = 100

COMMIT;

ROLLBACK;

--=====

2:-

--=====

select * from XX_EMP_TL

WHERE  EMP_ID >= 100

DESC XX_EMP_TL

DELETE FROM XX_EMP_TL

TRUNCATE TABLE XX_EMP_TL

COMMIT;

ROLLBACK;

--======

3.

--======

select * from XX_EMP_TL

UPDATE XX_EMP_TL

SET EMP_GRADE = 'L'

COMMIT;

ROLLBACK;