SQL STATEMENTS
SQL is divided into the following :- Data Definition Language (DDL) Data Manipulation Language (DML) Data Retrieval Language (DRL) Transaction Control Language (TCL) Data Control Language (DCL) DDL – Create, Alter, Drop, Truncate, Rename DML – Insert, Update, Delete DRL – Select TCL – Commit, Rollback, Savepoint DCL – Grant, Revoke DRL COMMANDS CREATE TABLE Syntax: Create table <table_name> (col1 datatype1, col2 datatype2 …coln datatypen); Create table XXSTP_EMP_DETAILS…