

InterviewSolution
Saved Bookmarks
1. |
Separate DDL and DML Sql commands from the given queries.I. CREATE TABLE EMPLOYEE(Name VARCHAR2(20), Email VARCHAR2(100),DOB DATE);II. DROP TABLE EMPLOYEE;III. ALTER TABLE STU_DETAILS ADD (ADDRESS VARCHAR2(20));IV. INSERT INTO javatpoint (Author, Subject) VALUES ("Sonoo", "DBMS");V. UPDATE students SET User_Name = 'Sonoo' WHERE Student_Id = '3'VI. DELETE FROM Studen_table WHER city= “Peshawar”; |
Answer» | |