Question: - Create an anonymous block that inserts new rows into the gl_professors_copy table - Declare variables using the %ROWTYPE and %TYPE attributes - Use bind/host

- Create an anonymous block that inserts new rows into the gl_professors_copy table - Declare variables using the \%ROWTYPE and \%TYPE attributes - Use bind/host variables to prompt for the input data - Alow for mixed case when entering the school code - Alow for mixed case when entering the first and last names and format names with first character in upper case and the remaining character in lower case - Include an INSERT statement in the execution section that inserts one row into the gl_professors_copy table - Run the block three times to insert the following rows into the table: - Verify the three rows were inserted correctly
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
