Ords 3 Make A Copy Of P02a Sql Naming It P02b Sql A Prompt For Semester Year And Term W S F To Restrict The Resul 1 (99.75 KiB) Viewed 44 times
3. Make a copy of P02a.sql naming it P02b.sql: a. Prompt forsemester year and term (W, S, F) to restrict the result set to aspecific term b. Allow for the semester term (W, S, F) to beentered in upper or lower case c. Pass the semester year and termto the cursor as parameters d. Display only enrollments with nonumeric or letter grades for the specified term (semester year andterm) e. semester_year is a NUMBER data type. Do not enter spacesinto the input field
ords 3. Make a copy of P02a.sql naming it P02b.sql: a. Prompt for semester year and term (W, S, F) to restrict the result set to a specific term b. Allow for the semester term (W, S, F) to be entered in upper or lower case c. Pass the semester year and term to the cursor as parameters d. Display only enrollments with no numeric or letter grades for the specified term (semester year and term) e. semester year is a NUMBER data type. Do not enter spaces into the input field 1 f. semester_term is a one-byte character field. Entering more than one character, including a space will return an error Input: ENTER SEMESTER_YEAR Output: :ENTER SEMESTER_TERM S Year: 2019 Term: S Section Project 2 Enrollment Missing Grade Verification 10034 10034 10034 10035 ▬▬▬▬▬ 7 Student No Value 1006 1007 1009 1001 2019 Enroll Date 2019-07-01 2019-02-03 2019-11-12 2019-03-25 Focus E ENG US O 10:37 AM 2022-06-29 100
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!