Computer Programming and Analysis DBS301 Lecture Notes - Lecture 8: Savepoint
Document Summary
Add two rows to table my_employee as following by using. Insert statement without column names (dunn will have no salary for now). Add third and fourth row as following, where both scott and rita will lcheng ddunn opopov. Into my_employee values (126, "popov", "olga", "opopov", 8500) Into my_employee values (127, "chen", "ling", "lcheng", 14500) Into my_employee values (128, "dunn", "david", "ddunn", "") Populate your table my_employee by inserting rows from table. Employees under condition that only programmers are inserted i. e people who have prog in their job title. It is up to you to determine which syntax option will achieve this task. Assume that column userid may be populated with the same generic value called generic" (for all employees who do not have user_id assigned yet). Verify what is stored in your table my_employee and undo your transaction. You will change last name and salary for employee gomez (who. 3. was without pay) to become jones with earning of .