Question: 1 . Create a program script that uses a PL / SQL anonymous block to perform the following:Use a host variable AREA to store the
Create a program script that uses a PLSQL anonymous block to perform the following:Use a host variable AREA to store the result. Declare a local variable RADIUS with numeric data type. Declare a constant PI with value Assign a value to the variable RADIUS by using a substitution variable. Calculate area of a circle by using formulaAREA PI RADIUS RADIUSThen print result in SQLPlusWrite a PLSQL block to find the square, cube, and double of a number inputted with a substitution variable, and print results using builtin package DBMSOUTPUTWrite a PLSQL block to swap the values of two variables. Print variables before and after swappingWrite a PLSQL program to input hours and rate. Find gross pay and net pay. The tax rate is Print your resultsWrite a PLSQL program with two variables for the first name and the last name. Print the full name with last name and first name separated by comma and a spaceOPTIONAL Write a PLSQL program to retrieve the full name of a given employee id Print the full name with last name and first name seperated by comma and a space.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
