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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter8: Restricting Rows And Sorting Data

Section: Chapter Questions

Problem 5RQ

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
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?
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;
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( )
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
Write a PL/SQL code to print 'PASS' if the student has scored above 40. Choose an answer A declare m number:= 80;begin if m>40 dbms.output.put_line('PASS'); end if;end;/ B declare m number:= 80;beginif m>40 dbms_output.put_line('PASS');end;/ C declare m number:= 80;begin if m>40 dbms_output.put_line('PASS'); end if;end;/ D declare m:= 80;beginif m>40 dbms_output.put_line('PASS');end if;end;/
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 5The circumference is 31.4159The 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.
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.
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
What types of relationships between numeric values can you test with relational operators?
SQL queries can accept arguments. In an SQL statement, a parameter variable begins with the __ symbol. Question 12 options: # $ @ &