use pl/sql to make a program Create a metric distant conversion program.. Ask user three questions and collect them with & substitution values 1st: from where (it could be cm , mt, km , mm) 2nd : to where: (it could be cm , mt, km , mm) 3rd : amount For instance if 1st and 2nd entry same send a print message “ same metric conversion is not possible “ and stop the program If for instance, 1st variable value is from km then 2nd variable is to where cm and 3rd variable amount is 1 then result will be 1km = 1000cm. === I can do only substitution values , I don't know how to do the asking and the same metric conversion is not possible

Q: Display the list of students who are involved in the IT club Display the details of all the…

A: First get the studid from Club table and then get those Student details This can be done using inner…

Q: Using SQL Write a function called ValidSupplier(SupplierID) that takes as its only input a…

A: The ask is to write a SQL function which does the following: - take a Supplier Id as input - Check…

Q: Please develop PL/SQL program that asks for a radius of a circle. After user enters a radius number,…

A: Syntax to implement IF statement: IF condition THEN       statements; ELSEIF condition THEN…

Q: Q1 Write a program in PL/SQL to print a list of names employees and the names of the departments to…

A: Textual PL/SQL Code :- -- create a table --CREATE TABLE Employees (  id INTEGER PRIMARY KEY,  Name…

Q: Topic: SQL StoredProc Create a stored proc that returns all the students from schools with revenue…

A: Let's see the answer

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

A:

Q: Write a PL/SQL code to print 'PASS' if the student has scored above 40. Choose an answer A declare…

A: C is the correct option Declare m number:= 80;begin if m>40 dbms_output.put_line('Pass') ; end…

Q: reate a PL/SQL block using a FOR loop to generate a payment schedule for a donor’s pledge, which is…

A: ANSWER:-

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: The given PL SQL program uses a cursor to process a multi-row query. A cursor is  a work area which…

Q: Develop a small PL/SQL programs. 1. Enter an instructor ID from the keyboard. The program then…

A: The PL/SQL code is given below in the next step

Q: Suppose a database in SQL write IF THEN ELSE Statement in PL SQL Block to check if the quantity in…

A: IF Product 2319.QuantityOnHand <= 120 THEN MESSAGE 'Stock is getting less.'; ELSEIF Product…

Q: Assignment  : PL/SQL Practice   Note: PL/SQL can be executed in SQL*Plus or SQL Developer or…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: Imagine a student table with following columns:      Student(Stuid, Name , Age, Major) Write a…

A: given table Student Stuid Name Age Major

Q: Online shopping system & online book store: Rebuild View/Edit cart and checkout pages using PL/SQL…

A: {"generalGuidance"::"sections":[{"sectionId":"50c4cd6a-2383-4c53-b65d-4c2b1304a00d","title":"","text…

Q: Write a PL/SQL block of code that performs the following tasks: Read a Book id provided by user at…

A: I have used PL/SQL Cursors to solve the given problem SET SERVEROUTPUT ON; DECLARE v_author…

Q: Develop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then…

A: here i mentioned PL/SQL small two programs for given problem. also handled NO_DATA_FOUND and…

Q: 3.Write a program in PL/SQL to display sum of odd numbers from 1 to n.

A: CODE: DECLARE   num NUMBER(3) := 1;   tot NUMBER(4) := 0; BEGIN   dbms_output.Put_line('Odd numbers…

Q: Question 7 Writes a PL/SQL function that calculates the factorial of a number passed as a parameter.…

A: I give the PL/SQL code along with its output screenshot

Q: Write a SQL code that returns the Name of ALL Customers (based on CUS_FNAME and CUS_LNAME in…

A: The question is solved in step2

Q: Write all the sql code (including create, insert and select)

A: #use the below query to create users tablecreate table users(account int primary key,name…

Q: Program 2: Create a PL/SQL program that calculates the discount of all the treatments in the…

A: Find the required PL/SQL program given as below :

Q: Write SQL queries for the following statements. 1) Write a stored procedure which takes an integer…

A: Create proc using create command  Create a variable as input parameter Declare incrementation…

Q: The hospital would like to set up a relational database corresponding to this form. a. Normalize the…

A: Normalization Normalization is the term used to describe the process of organizing the data in the…

Q: Rewrite the following in SQL O A.p>100 X Product A.s=S. S II X A.a, C.y A.x = C.x Store II c.x, C.y…

A: The equivalent of Projection πA(R) is SELECT The equivalent of Selection σC(R) is WHERE The…

Q: Given: class SuperClass { SuperClass(int x) { System.out.println("Super"); } } public class SubClass…

A: Here, we are going to find out the suitable line n1 from given options. Code is in Java language and…

Q: Write SQL queries for the following database: id Customers name email Categories id name id…

A: Since there are multiple parts to a single question, the first three subparts are answered for you.…

Q: Write PL/SQL or T-SQL procedures to accomplish the following tasks: A: obtain the name and credit…

A: Actually, SQL stands for Structured Query Language.

Q: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

A: In PL/SQL cursors are used to store the data row-wise and can store multiple rows, which can be…

Q: In the preceding PL/SQL block, determine the values and data types for each of the following cases.…

A: PL/SQL block, the values and data types for each of the following cases are:   a) The value of…

Q: In SQL Server, specify the differences between the two character data types as follows: NVARCHAR…

A: According to the information given:- We ahev to define the differences between the two character…

Q: Create a PL/SQL database programming block with DECLARE BEGIN   END; In Declare section define…

A: Below is the PLSQL block code:

Q: Instructor (Instructor_Id, Instructor_Name, specialization, Address, #Department_Id) Write in…

A: First we have to create a table Instructor with details such as Instructor_name, Specialization,…

Q: Write a function and a call program in PL/SQL to sum the even integers between 1 and any number that…

A: given to write pl/sqlprocedure function for sum of 1 to n even numbers: Below is the procedure of…

Q: Write the pl/sql block of code to call the above created package by passing the employee number in…

A: Pl/SQL program to display the Employee detail if Employee id is present in the Database then his…

Q: QUESTION Given the sample of the GPADatabase in a file, write SQL Stored function called…

A: Steps to create a SQL stored function to calculate the semester GPA:   Step – 1: Connect to your SQL…

Q: In Oracle PL/SQL programming language, %TYPE keyword would give you some advantages when you are…

A: Below are the advantages:

Q: Write a PL/SQL block of code that performs the following tasks: i. Read a Book id provided by user…

A: For taking user input you have to use "&" this special character because in PL/SQL user can be…

Q: T-SQL procedure for MICROSOFT SQL SERVER   A: obtain the name and credit limit of the customer…

A: Given : T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer…

Q: OM = ' || vEname || 'Adresse= ' || vAddress ); exception    when MANYROWS  then ( . . . . . . . . .…

A: Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in…

Q: Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in…

A: Solution SELECT * FROM departments where department_id =90; BULK COLLECT Clause for Selecting…

Q: ISBN Title Author 12345678 The Hobbit J.R.R. Tolkien 45678912 DaVinci Code Dan Brown Your student ID…

A: Hey there, I am writing the required solution based on the above given question. Please do find the…

Q: QUESTION 2. Write a PL/SQL PROCEDURE that can list the Top-N customers (id and name) and the amounts…

A: ANSWER: PL/SQL Procedure:

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.