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

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

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter10: Data Analysis With Power Tools And Creating Macros

Section: Chapter Questions

Problem 6AYK

See similar textbooks

Similar questions

Student Name: Student Number: Write a PL/SQL Program to do the following Your Program should request the user to enter the temperature. Then based on the users input your program should display the following messages a. Print "Hot" if the temperature is above 80 degrees, b. Print "Nice Weather" if it's between 50 and 80 degrees, c. Print "cold" if it is less than 50 degrees Test 40, 55 and 85 as inputs; Guideline: Create a unique code Add Comments to the program ● Take clear screen shots of the program source code and the outputs Explain the code block briefly You must submit the code as one .sql file and paste all the screenshots in the Word document and upload it to Moodle before deadline. 99+ DELL
write SQL code that involve calculation by using if else statement
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;
Databases are used to store different kinds of data such as names, currency, text, graphics, etc. Determining the appropriate data type for each attribute is important for database performance, storage size, and conducting accurate analysis on databases. As with other programming languages, SQL supports many data types. However, you will mostly use two categories while writing SQL queries: Characters, and numbers. Consider the following standard SQL data types: Characters char varchar Numbers integer decimal float Different data types could be used for the same attribute. For example, both char and varchar could be used to store “names” in a database. Examine the attributes for the Characters and Numbers data types. Using specific examples, compare data types for each category. For example, why you should choose char rather than varchar or opposite?
Assume that you have a product code that has the following format: XXXXNNN Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero). Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be: Product Name is: ABC Serial Number is: 031
Assume that you have a product code that has the following format: XXXXNNN Where X is a character and N is a digit. Notice that the length of the character part is not fixed, it may range from 2 to 4 characters, while the length of the second part may range from 2 to 3 digits but the first digit from the left is always 0 (zero). Write a PL/SQL program to separate the code into its two parts as shown in the following example: if the input is ABC031, the output should be: Product Name is: ABC Serial Number is: 031 Hints: Use the following functions if needed: instr( string1, string2 [, start_position [, nth_appearance ] ] ) substr( string, start_position, [ length ] ) length( string ) DBMS_OUTPUT.PUT_LINE( )
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.
What types of relationships between numeric values can you test with relational operators?
SQL PROGRAM Create a function that takes Celsius temperature and returns a Fahrenheit
For the remaining questions, use the following table of people: people (id (pk), firstname, lastname, spouse_id (fk)) The table was created as: CREATE TABLE people (id INT NOT NULL AUTO INCREMENT PRIMARY KEY, firstname VARCHAR(30), lastname VARCHAR (30), spouse id INT, CONSTRAINT spouse fk FOREIGN KEY (spouse id) REFERENCES people (id)); This is some sample data: Participation Activity 9 +---- | id | firstname | lastname | spouse_id | + 1 | Marty 2 | Jennifer | McFly | Parker | McFly | Tannen | McFly | | 3 | Lorraine 4 | Biff 5 | George NULL | NULL | 5 | NULL | 3 | +----+--
Pl/sql
Computer Science * IN SQL* Write an SQL statement that selects all customers with a city starting with any character, followed by "land".