Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number, the program then calculates 1. Circumference and 2. Area of a circle, then prints both as follows: You entered radius as 5 The circumference is 31.4159 The area is 78.5398 If the area is less than 50 then print 'Please enter bigger radius'. Otherwise print 'Your radius is Ok'. Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dot

Q: Student Name: Student Number: Write a PL/SQL Program to do the following Your Program should request…

A: Answer is given below-

Q: in sql ,create  a  program that prompts the user for a number. This number will be top (cap) number.…

A:

Q: Fill in the appropriate relational and logical operators to complete each of the following…

A: Since programming language is not mentioned, I am assuming python. Relational operators include…

Q: What types of relationships between values can you test with relational operators?

A: There are six relational operators:- 1) <: less than 2) <=: less than or equal to 3)…

Q: Computer Science * IN SQL* Write an SQL statement that selects all customers with a city starting…

A: selects all customers with a city starting with any character, followed by "land".

Q: The following code would include: SELECT P_DESCRIPT, P_PRICE FROM PRODUCT WHERE P_PRICE < ANY (…

A: Your answer is given below.

Q: What is the final value of variable num DECLARE num NUMBER := 5; BEGIN num = num + 2; IF num> 8 THEN…

A: From the given block of code : initially num=5 after that num = num +2                num = 5 + 2…

Q: Fill in the appropriate relational operator to complete each of the following conditions. A. Check…

A: A.   Check to see if the color is Blue.  solution :           if (color == "Blue"):

Q: a class (an class to it) encapsulates the ales tax rates in the 50 U.S. states over the last 10…

A: Given Write a class (and a client class to test it) that encapsulates the evolution of the sales tax…

Q: 17. Write the SQL statement that will display the following (do not hardcode 'George', 'Lorraine',…

A: Using self join between these two table we will get the results for George and Lorraine and to…

Q: Assume cur is a Cursor object, the variable name_input references a string and the variable…

A: Solution:   Here's an a complete Python statement that uses a parameterized SQL statement to add a…