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
Allow for mixed case when entering the school code
Allow 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:
Buy plagiarism free, original and professional custom paper online now at a cheaper price. Submit your order proudly with us
https://essayhope.com/wp-content/uploads/2020/02/logo-1-300x75.png00pytahttps://essayhope.com/wp-content/uploads/2020/02/logo-1-300x75.pngpyta2022-06-13 07:37:402022-06-13 07:37:40Create an anonymous block that inserts new rows into the gl_professors_copy table