Create an anonymous block that inserts new rows into the gl_professors_copy table

  • 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



Essay Hope