Please develop PL/SQL program that asks for a radius of a cirle. 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 Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dot. Read and practice chapter 2.

Please develop PL/SQL program that asks for a radius of a cirle. 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 Declare variables for circumference and area in such a way that the result would be rounded to 4 decimal places after the dot. Read and practice chapter 2.

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter11: Sql Server Databases

Section: Chapter Questions

Problem 3MQ2

See similar textbooks

Similar questions

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 5The circumference is 31.4159The 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
Create a PL/SQL Program that asks user to enter 2 numbers, then finds an average of two numbers and displays it with a message: Average of X and Y is Z. Where X, Y are numbers that you entered, Z is an average for X and Y, calculated by the program. Your program may start as follow: DECLARE v_x NUMBER :=&first;v_y NUMBER :=&second; v_result NUMBER; BEGIN -- You calculations here END;
TAL Distributors would like to know the number of months between the current date and the order date of an order. Write an SQL statement in MySQL that displays the order number and the number of months between the current date and the order date. The number of months should display as an integer. (Hint: You can nest one function within another function.) This is the code I haveSELECT FLOOR(MONTHS_BETWEEN(CURRENT_DATE,To_date(ORDER_DATE, 'MM/DD/YYYY')))num_monthsFROM ORDERS;is giving me an errorError Code: 1305. FUNCTION tal.MONTHS_BETWEEN does not exist
INFO 2303 Database Programming Assignment # : PL/SQL Procedure & Function Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Write a script to create a PL/SQL procedure called findSal that displays the doctor’s salary and bonus after passing in the doc_id into the procedure. For example, if you pass in doc_id 504, you will get the following output. execute findSal(504) The salary for Dr.Cotner (504) is: 11500 The bonus is: 7500 PL/SQL procedure successfully completed.
Create a function name BALANCE that returns the status of outstanding amount for each customer. Use the following criteria for your function: Outstanding_amt less than 5000 , returns ‘SMALL AMOUNT’ Outstanding_amt between 5000 and 10000 , returns ‘AVERAGE AMOUNT’ Outstanding_amt greater than 10000 , returns ‘LARGE AMOUNT’ Use function BALANCE in your SQL statements that display the cust_code, cust_name, Outstanding_amt and function BALANCE.
write Sql statements to write query for the given table .. the query statements are. Display first name of doctors whose first name contains any of vowels (a,e,i,o,u). Display names of those patients whose name’s second letter is neither ‘a’ nor ‘d’ Display details of those patients whose name contains less than 5 characters. Display first 4 doctors who are earning least salary. Display details of all patients in such a way that female patients are shown before male patients. Display names of those patients whose names starts with either ‘a’ or ‘b’ or‘d’ and don’t ends on‘s’. Display 1/4 records of patients.
In SQL Server, describe the distinction between the two data types for the characters as follows: NVARCHAR NVARCHAR NVARCHAR
PL/SQL Question I need to build pl/sql block that prompts a user for the number of visitors each day for the past 5 days and then displays the average number of visitors per day. For example; day 1: 19 day 2: 21 day 3: 23 ... The avg number of visitors is: ___ like this.
Computer Science * IN SQL* Write an SQL statement that selects all customers with a city starting with any character, followed by "land".
A cake shop named "Whisk" has an online presence. It has multiple flavors of cakes supplied by various vendors. The manager wants to know the cost of the available quantity. Write a sql query to get the total cost of the available cakes. Code should run on Mysql. Data type along with the sample input and output is mentioned below:- Cake: Column Type Cake_Id int Flavor varchar(100) Cost int Producer varchar(20) Stock int Sample Input :- Cake: Cake_id Flavor Cost Producer Stock 1001 Vanilla 450 Just bake 8 1003 Chocolate 500 Flower Aura 12 1004 Red velvet 600 Bakingo 1 1005 Strawberry 700 Bigbasket 2 1006 Cinnamon 900 Creamy 1 1007 Vanilla 900 Creamy 2 1008 Mango 900 Just bake 2 1009 Strawberry 550 Creamy 2 Sample output - 17200
In SQL Server, character data types may be distinguished as follows: NVARCHAR, NVARCHAR, and NVARCHAR.
** IN SQL ** Write a query sentence to display the names, jobs, dates of appointment and employee numbers so that the employee number appears first