The HR department wants you to create SQL statements to insert, update, and delete employee data. As a prototype, you use the MY_EMPLOYEE table before giving the statements to the HR department. Note:...

INPUT SQL

Extracted text: The HR department wants you to create SQL statements to insert, update, and delete employee data. As a prototype, you use the MY_EMPLOYEE table before giving the statements to the HR department. Note: For all the DML statements, use the Run Script icon (or press [F5]) to execute the query. This way you get to see the feedback messages on the Script Output tab page. For SELECT queries, continue to use the Execute Statement icon or press [F9] to get the formatted output on the Results tab page. Insert data into the MY_EMPLOYEE table. 1. Run the statement in the lab_09_01.sql script to build the MY_EMPLOYEE table used in this practice. 2. Describe the structure of the MY_EMPLOYEE table to identify the column names. DESCRIBE MY_EMPLOYEE Name Null Туре ID NOT NULL NUMBER ( 4) VARCHAR2 (25) LAST_NAME FIRST_NAME VARCHAR2 (25) USERID VARCHAR2 (8) SALARY NUMBER (9,2)