Describe the structure the table identify the column names
Practice 8
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, prior to giving the statements to the HR department.
3. Create an INSERT statement to add the first row of data to the MY_EMPLOYEE table from the following sample data. Do not list the columns in the INSERT clause. Do not enter all
rows yet.
|
||||
|---|---|---|---|---|
| 1 |
|
|||
| 2 |
|
|
||
| 3 |
|
|||
| 4 |
|
|||
| 5 |
|
|
Practice 8 (continued)
6. Write an insert statement in a dynamic reusable script file named loademp.sql to load rows into the MY_EMPLOYEE table. Concatenate the first letter of the first name and the first seven characters of the last name to produce the user ID. Save this script to a file named lab_08_06.sql.7. Populate the table with the next two rows of sample data by running the insert statement in the script that you created.
10. Change the last name of employee 3 to Drexler.
11. Change the salary to $1,000 for all employees who have a salary less than $900. 12. Verify your changes to the table.
