Develop PL/SQL program Create a program that asks for an instructor ID. Find a) the full name of the instructor b) How many sections instructor teaches print both instructor full name and number of sections by that instructor.

Q: Given a table students in SQL. Write a SQL query to add a column Address Varchar(30) in the student…

A: Given Table: students  We have to add a new column Address Varchar(30) to the given table students.…

Q: Create a Procedure in PL/SQL takes employee_id, rate_salary, rate_commission. This function will…

A: Find the required procedure in PL/SQL given as below :

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: Write the T-SQL scripts for the following tasks: - Write a query to list all the Employee's details…

A: let us see the answer:- Introduction:- We are going to use a select query to list all the Employees…

Q: Write a PL/SQL program using an explicit cursor that displays all patients PLCO_ID numbers from…

A: Here we write PL/SQL program using explicit cursor :…

Q: in pl/sql ,use Cursor to get all the records from table  job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

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

A: given table Student Stuid Name Age Major

Q: Write the T-SQL scripts for the following tasks:   Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: In Sql Oracle Apex application, Using GROUPING SETS, write a query to show the following groupings:…

A: First query performs a grouping on two columns Department_Id and Job_Id Group By X, Y means put all…

Q: Oracle SQL Packages Create a stored procedure to display top three of cheapest course in terms of…

A: To return the smallest value of the selected column we use the MIN( ) function. And to return the…

Q: Pl/sql Program to increase the salary of employee whose id is 400 based on the following conditions…

A: here we have given a Pl/sql Program to increase the salary of employee whose id is 400 based on, If…

Q: Examine this executable section of a PL/SQL block: BEGIN FOR worker_record IN pay_cursor LOOP Worker…

A: PL/SQL is a combination of SQL and the procedural  languages  Developed by oracle  above question…

Q: Sondt File Student Number Student Name Address Telephone (v) Corse File Course Number Description…

A: SELECT courseNumber, description FROM courseFile WHERE professorNumber=(select professorNumber from…

Q: When we say that SQL is a declarative language, we mean that (a) it is possible to describe directly…

A: Declarative programming is a programming paradigm, or a way of creating the structure and parts of…

Q: What does SQL's Like operator do?

A: When a value is compared to other similar matters, the SQL LIKE clause employs wildcard operators to…

Q: We have employee table contains (emp-no, emp-name, emp-age, emp-salary, emp-department) write a…

A: Given Employee table contains the attributes: emp_no, emp_name, emp_age, emp_salary, emp_department

Q: Write a PL\SQL program to increase the salary of employee whose ID is 400 based on the following…

A: Given:-   Here is  Pl/sql Program to increase the salary of employee whose id is 400 based on, If…

Q: Run these program in sql and description errors and print number of errors and correct to error…

A: Given that Run these program in sql and description errors and print number of errors and correct to…

Q: Write the syntax for AUTO_INCREMENT in sql databases.

A: Question. Write the syntax for AUTO_INCREMENT in SQL databases. Answer. AUTO_INCREMENT:…

Q: 2) Create in PL/SQL a stored procedure called 'Del Details' to delete the record of orderedProduct…

A: 2. The SQL query is given below: CREATE PROCEDURE [dbo].[Del Details] -- Add the parameters for the…

Q: Write the following inserts, deletes, or updates in SQL, using the universityschema. Insert every…

A: Explanation: In the below query, “insert, select, into, from and where” are the keywords used. The…

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: We have a single customer with the surname  "Ashworth", write the SQL to return the Firstname,…

A: -- create a tableCREATE TABLE customers (  FirstName  varchar(255),Surname  varchar(255),Phonenumber…

Q: Write a SQL query to find the member number (member_no) of each faculty whose department

A: SELECT Member_no FROM COMPANY WHERE DEPARTMENT_BUILDING  IN (SELECT DEPARTMENT_BUILDING FROM COMPANY…

Q: IN SQL write a query to get the names of all Students who passed the exam from the table…

A: Required:

Q: Create a PL/SQL a cursor program that will increase the employee salary to 25% who are having the…

A: SQL stands for Structured Query Language. It is used for storing and managing data in relational…

Q: Explain the DML transactions in PL/SQL briefly and write down their general syntax.

A: Given: Data Manipulation Language (DML) These SQL commands deals with the manipulation of data…

Q: Write queries in SQL to answer each of the following questions:…

A: Below are the required queries: As per our company guidelines we are supposed to answer only first 3…

Q: 1. The management of the organization has decided to increase the salaries of all employees to 15%…

A: PL/SQL: PL/SQL contains elements of procedures such as conditions and loops. It enables constants…

Q: In a database, Write SQL query to show table structure of table name Guardians.

A: Given you are present in the database where the table exist, to show the structure of any table in…

Q: In sql get to know the HR database, its tables, and their contents. Show the SQL query and the…

A: Steps: Display employees where the first name or last name starts with S.   Display manager ID…

Q: te An SQL Query To Fetch “FIRST_NAME” From Worker Table Using The Alias Name As <WORKER_NA

A: Lets see the solution.

Q: In SQL, create Object-Identity and Reference Types

A: Introduction: Use REF(type-name) in a SQL query, where type-name denotes the referenced type. In…

Q: Enter the first name: Lewis Enter the last name: Crow Enter the date of birth: 16-OCT-49 Enter…

A: SQL is the structured query language, it is used to extract and manipulate the data from the table.…

Q: 2.Write a program in PL/SQL to input a number and calculate its Factorial.

A: CODE: DECLARE    fact_no number :=1;   num number := &amp;1;BEGIN    while num &gt; 0 loop…

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

A: Algorithm: Start Read radius Using the formula 2*3.14*radius calculate perimeter Display perimeter…

Q: Write a script to create a PL/SQL procedure that modifies the next date of appointment of certain…

A: write a script to create a PL/SQL procedure that modifies the next date of appointment of ceratin…

Q: 3. Write a program in PL/SQL to calculate factorial of n.

A: Given:

Q: Write PL/SQL program to print the highest digit value of an integer entered by the user? Ex:

A: ANSWER :  Program : FUNCTION  FBIG(N NUMBER) RETURN NUMBERIS R NUMBER; M NUMBER; S NUMBER;BEGIN M :=…

Q: In the SQL Oracle Application Write one query to return the employee_id, job_id, hire_date, and…

A: COMMANDS USED: Select command is used for the purpose of selecting the data from the database. The…

Q: 5. Write a SQL query to find the maximum, minimum, and average salary of the employees. 6. Write an…

A: Given, Table EmployeeDetails: EmpId FullName ManagerId DateOfJoining City 121 John Snow 321…

Q: how to delete department id in pl/sql from department id - 60 otherwise raise an exception

A: To delete department id in pl/sql from department id - 60, use the following. Since you are not…

Q: Write a PL/SQL script to display two outputs on the screen: 1) the most recent registration date and…

A: Answer 1)    SELECT Registration_Date FROM STUDENT ORDER BY Registration_Date DESC LIMIT 1;

Q: A. Write the following queries in SQL: i. List the Part Names which are not used to service the…

A: The given problem has to be solved in SQL queries where the tables Part and Service are already…

Q: Consider the following table: Instructor (Instructor_Id, Instructor_Name, specialization, Address,…

A: The syntax for writing the PL/SQL function is-  CREATE  [OR REPLACE] FUNCTION function_name…

Q: 1- Create the following table in PL/SQL language and show the table; | ID | NAME | AGE | ADDRESS |…

A: PL/SQL is a Procedural Language / Structured Query Language that is used to retrieving, update,…

Q: In sql how would you write a stored procedure with two parameters and check if those two are subsets…

A: Creating a SQL Stored Procedure with Parameters To create a stored procedure with parameters using…

Q: Perform the following operation in sql for insertion, updating and deletion using the referential…

A: Four tables are created using the below table scripts. The table design it already taking the…