Create an SQL package specification and body called JOB_PKG, containing the following procedures: Create a procedure called ADD_JOB to insert a new job into the JOBS table. The procedure has job id, job title, minimum salary and maximum salary as parameters. Ensure that the value of maximum salary is greater than minimum salary, raise an exception if this rule is violated (create a private procedure for salary validation).

Q: Task 3: Create(Enter) new product by using a Procedure with IN Parameters Follow these steps to…

A: the answewr is :2. a. --> CREATE PROCEDURE PROD_ADD_SP ( product_name IN VARCHAR2 , description…

Q: Considering Vaccination Database, write queries to: Display the Subject CNIC, Name, Contact, Dose1…

A: The subjects who have been vaccinated different types in Dose1 and Dose2. For instance, subjects who…

Q: Create a stored procedure called print_emp that finds the empno, name, salary, and location of…

A: Given: Create a stored procedure called print_emp that finds the empno, name, salary, and location…

Q: Q2/ write SQL commands to create tables of a Bank database, where these tables will have the…

A:

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

A: By increasing all salaries from the employees and over the age of 40 by 25%. Determining the…

Q: The relational schema shown below is part of a hospital database. The primary and foreign keys are…

A: Here we will use to_char() function which converts date format into string and then we will apply…

Q: Write SQL retrieval commands for each of the following queries: Display the course lD and course…

A: Given: Write SQL retrieval commands for each of the following queries: Display the course lD and…

Q: B5. Write a SQL command to perform the following operations by using this schema: BOOKS(BooklID.…

A: SQL command to ⦁ create the table BOOKS⦁ insert a new row in the BOOKS table⦁ Update the value of…

Q: The Employee database contains a page displaying summary information, including EMPNO, ENAME, JOB,…

A: We need to read the EMP table for the given fields and display the result as per the given…

Q: Q2/ write SQL commands to create tables of a Bank database, where these tables will have the…

A: Syntax for creating sql tables:-  create table tableName(column_name1 datatype, column_name2…

Q: using sql develpper or sql live oralce Create the DONORS table with the following columns:…

A: As per our company guidelines we are supposed to answer ?️only first 3️⃣ sub-parts. Kindly repost…

Q: Use a SELECT statement to view the system variables that enable and disable the binary log and the…

A:

Q: Create a SQL statement for the CLIENTS table using the table structure below

A: According to the question we need to create a SQL statement for the CLIENTS table using the table…

Q: Write the appropriate SQL statement for the following with screen shots of the execution. i. Create…

A: Create table commands   create table supplierdetails (supplierID VARCHAR2(200) PRIMARY KEY,…

Q: Write the validation rule to enter a name starting with S?

A: Validation rules:- Validation rules are used to create a criteria to view a table or a data sheet…

Q: Give the SQL query and attach the output of the workbench after creating the table. Use the desc…

A: Write the SQL query to create the given table and attach the output of the workbench after creating…

Q: Create a table Customer ; ID | NAME |AGE|ADDRESS | SALARY Select * from customers; I IR | NAME | AGE…

A: Triggers are stored programs, which are automatically executed or fired when some events occur.…

Q: You will need to add a CREATE DATABASE and USE database statement at the beginning of the script in…

A: As per our company guidelines I am answering only 1st 3 subparts.

Q: Create a PL/SQL query to display the combined customer name, coin purchased, coin price andthe…

A: THE GIVEN SQL QUERRY FOR THE QUESTION

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: Task 3: Create(Enter) new product by using a Procedure with IN Parameters    Follow these steps to…

A: Solution: Given: Given the procedures and the parameters to find the values of the product in the…

Q: Create a INSERT trigger called checkPubCity to ensure there are no more than two publishers in the…

A: Triggers are consist of procedures that fired or executed whenever any manipulation occurred on the…

Q: lease review this SQL trigger and let me know why instead of just updating the CS_Loyalty level for…

A: First, let's understand how the trigger works? A trigger is a unique form of stored system that…

Q: Write SQL retrieval commands for each of the following queries:a. Display the course ID and course…

A: You didn't provide any tables for query, So I am assume the name of tables and its attributes…

Q: Please match the keyword or operator from the list below to its correct SQL explanation and syntax…

A: Given : Please match the keyword or operator from the list below to its correct SQL explanation and…

Q: Create a stored procedure called print_emp that finds the empno, name, salary, and location of…

A: The Answer is

Q: whats the wrong of my code ?how to fix it ?

A: Before explaining the bug of the program I want to explain exception handling in SQL developers: An…

Q: n Triggers, BEFORE means before the changes are made in memory but after the changes are permanently…

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: Write the appropriate by using Microsoft SQL for the following with screen shots of the execution.…

A: Note: since your question contain multiple sub-parts but we can answer only first 3-subparts at a…

Q: Create a procedure, ADD_EMPLOYEE., to insert a new employee into the EMPLOYEES table. The procedure…

A: Create the ADD_EMPLOYEE procedure to add an employee to the EMPLOYEES table.The row should be added…

Q: Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three…

A: Please give positive ratings for my efforts. Thanks.   ANSWER   SQL Satements to create and insert…

Q: Create(Enter) new product by using a Procedure with IN Parameters Follow these steps to create a…

A: It is defined as a collection of information that is organized so that it can be easily accessed,…

Q: Create an anonymous block in PL/SQL to list all the countries from Country table where Currency…

A: You can write user-defined functions in PL/SQL  to provide functionality that is not available in…

Q: Display the last names of al Global Fast Foods employees who have “e”and“i” in their last names.

A: Note : Here I have created an example table to solve the problem. Algorithm :  Step  : select the…

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: Assume that you have a table Anc that contains two columns: employee name e namen and the salary…

A: Revoke syntax:-  To increase sal column by 15% , use sal+sal*15/100 revoke permissionName on…

Q: Write a PL/SQL block that will allow the user to enter FNo and that will display Customer Name from…

A: A record is a data structure that can hold various types of data items. Records, like rows in a…

Q: TREATMENT Column Name TID PID DNAME TDATE SPECIALTY DataType INT(3) INT(5) VARCHAR(10) VARCHAR(10)…

A: The SQl command of the above following questions are given below :

Q: Draw the ERD _that is implemented by the following SQL code: CREATE TABLE PROJ_USER USER_ID NUMBER…

A: ER diagram: The ER diagram for the given SQL code:

Q: Given the Bank database that contains the following tables (primary keys are underlined and foreign…

A: DECLARE c_Number Client.clientNumber%TYPE; c_FName Client.firstName%TYPE; c_LName…

Q: This is a valid SQL statement: Values stored in a table, but not in an Oracle instance, are stored…

A: Given: This is a valid SQL statement: Values stored in a table, but not in an Oracle instance, are…

Q: reate a Pl SQL package named EMP_PKG which will have the above three functions and procedures as…

A: The PL/SQL stored procedure  is a PL/SQL block which performs one or more specific tasks.  The…

Q: Hello, I received the following assignment questions and I am not sure how to answer them. Can you…

A: The answer is given below:-

Q: Write the SQL code that will create the tables structures for the tables named Books, and Users.…

A: HI THERE I AM ADDING REQUIRED CODE BELOWPLEASE GO THROUGH IT THANK YOU

Q: rite the SQL code to create a copy of EMP_1, naming the copy EMP_2. Then write the SQL code that…

A: Required: SQL code to create a copy of EMP_1, naming the copy EMP_2. Then write the SQL code that…

Q: Describe how you would fix the SQL error depicted below. A good idea would be to copy the code…

A: The Syntax for the SQL CREATE command is: - CREATE TABLE table_name ( Column_name1 data_type[size],…

Q: Execute the following statements using MYSQL: 1. Insert a row with the values (005, "Your name", ,…

A: 1. Insert a row with the values (005, "Your name", , "Your Dept", 50000, 40) 2. Create a trigger…

Q: PLZ HELP WITH THE FOLLOWING

A: All the highlighted parts are the edited code. There were lot of mistakes in the code   CREATE TABLE…

Q: Subject: Database Write the SQL statements for following modification tasks: a) Add constraint to…

A: According to the provided information: We need to create SQL query for the addition of a primary…