Create an anonymous block that returns the number of students in a section. Prompt for section id. Name the file
. Create an anonymous block that returns the number of students in a section. Prompt for section id.
Name the file
Create an anonymous block that return the average numeric grade for a section. Prompt for section
id and return the average grade.
Complete the following:
• Create a view called gl_stdV1 that returns the required data
• Create an anonymous block that:
o Accesses gl_stdV1
o Uses the %ROWTYPE attribute to define a record structure for the view data
o Prompts for student number and section id
o Output the required information
• 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:
• Verify the three rows were inserted correctly
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
