Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a procedure called getCountriesInfo which accepts a country name and gets the number of countries which has the population growth rate that is lower
Create a procedure called getCountriesInfo which accepts a country name and gets the number of countries which has the population growth rate that is lower than the given country's population rate (from country id 60 through 65). Then, invoke the procedure from an anonymous PL/SQL block and provide the country name (Republic of Peru). Display the number of countries which has the population growth rate that is lower than the Republic of Peru's population rate in the PL/SQL block. Use Countries table from your workspace. Sample output: History Republic of Peru population growth rate: 1.32 Country id: 60 Population growth rate: 1.78 Country id: 61 Population growth rate: .85 Country id: 62 Population growth rate: 1.41 Country id: 63 Population growth rate: 1.8 Country id: 64 Population growth rate: .99 Country id: 65 Population growth rate: 1.42 No. of countries less than population growth rate in Republic of Peru: 2
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started