Write PL/SQL cursor to find the commission amount for all the employees whose job_id is SA_MAN Use the employees object of Oracle Live SQL HR Scheme, Employees object descriptions is given here. Column Null? Туре NOT NULL EMPLOYEE_ID NUMBER(6,0) VARCHAR2(20) FIRST NAME NOT LAST NAME NULL VARCHAR2(25) NOT EMAIL NULL VARCHAR2(25) PHONE NUMBER VARCHAR2(20) NOT HIRE DATE NULL DATE NOT JOB ID NULL VARCHAR2(10) SALARY NUMBER(8,2) COMMISSION_PCT NUMBER(2,2) MANAGER ID NUMBER(6,0) DEPARTMENT ID NUMBER(4,0)

Q: Write SQL command that returns the name of aircraft (MOD_NAME in MODEL table), number of trips each…

A: The sql query is solved in step2

Q: Use following oracle table Display the first name and salary*10000 of all employees who works for…

A: Required:     Display the first name and salary*10000 of all employees who works for department 50.

Q: TB JOB_HISTORY EMPLOYEE ID START DATE JOB_ID ST CLERK END DATE DEPARTMENT_ID 114 3/24/2006…

A: The Structured Query Language (SQL) is used to access databases, as well as insert, delete, and…

Q: QL Help I need to create a PL/SQL trigger called aprove_rental that will prevent an INSERT if a…

A: Code  create table client (client_num char(4), client_lname varchar2(15) not null, client_fname…

Q: In SQL, write the appropriate statements to insert default values for these three tables, each table…

A: Prescription table: INSERT INTO prescription (pre_no,pre_date,pre_amount)VALUES (10,12,1200); INSERT…

Q: Question 2 (Q2.sql): ExNumber: int Mark: float Description: ntext Exercises CourselD: int Has…

A: Introduction: This question involves creating SQL queries for a database schema consisting of three…

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

A: conclusion:In the nested block:v_customer holds a numeric value of 201 with a data type of…

Q: ber(11) ID P DISCOUNT JO na veDISCOUNT_ID Write a to display user name and password. Password should…

A: The Answer is in below Steps

Q: PL/SQL Create a simple loop that prints instructor names, where instructor IDs are in the range…

A: Required:   PL/SQL Create a simple loop that prints instructor names, where instructor IDs are in…

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: You are given the following data tables: Employees(Employeel D, LastName, FirstName, BirthDate,…

A: Given that there are two tables Employee and Orders. The attributes of each table are:…

Q: How does the STUFF function help in manipulating string data in SQL?

A: The STUFF function in SQL is used to manipulate string data by inserting, replacing, or deleting…

Q: (i) mgr=null, ename=3rd character is N, not known anything else (ii) Give single example with sql…

A: SQL has a large number of character functions.Manipulative Character Functions CONCAT, LENGTH,…

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: A simple database composed Tollowing tables: PATIENT, TOR, DRUG, PRESCRIPTION, is now loaded with…

A: As per the guidelines we have given answer for the first three queries. You can find the solution in…

Q: How does the PATINDEX function help in string pattern matching in SQL?

A: Relational databases are managed and worked on using the programming language SQL (Structured Query…

Q: Write a query to display maximum bus tickets fare and give an alias name as MAXIMUM_AMOUNT

A: We use SELECT statement for selecting the data from relational database, the result will be stored…

Q: UPDATE NONCAT SET Category =NULL WHERE ITEM_ID = UF39; Task 7: In the NONCAT table, change the…

A: Solution: UPDATE NONCAT SET Category =NULL WHERE ITEM_ID = 'UF39';

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

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

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

A: Below are the advantages:

Q: Oracle supports creating objects and collections using type. Write SQL code for the following…

A: Answer :

Q: Using Salesforce Only: Write a SOQL query on account object and try to get the 5 fields value which…

A: What is SOQL: SOQL stands for Salesforce Object Query Language. You can use SOQL to read information…

Q: CREATE TABLE Fielding( Player CHAR(25), CareerSpan VARCHAR(20), Matches INT, Innings INT, Catches…

A: SQL Query Use inner join to join the 3 tables and get the required result from query

Q: instrument category category name varchar(255) varchar(255 rchar(255) instrument id Ezzzzz

A: Answer: In this subquery First of all with the help of join we will connect three table Instrument,…

Q: Imagine that you are a database manager at a company that makes custom shirts. One column in the…

A: Create the sample table shirts having columns idshirt as integer and autoincremented, wholesaleprice…

Q: Use following oracle sql table Display the first name, last name and salary of all employees hired…

A: Required: Display the first name, last name and salary of all employees hired after “01-JAN-2006‟.

Q: 4. Create the Order_Product table as follows: • id is the primary key and its data type is serial…

A: 4. Query: CREATE TABLE Order_Product(    ID serial NOT NULL PRIMARY KEY,    quantity int NOT NULL…

Q: Write sql code for Use derived tables and joins to create a list of players who have scored more…

A: Fielding Table is not given but it is mentioned to consider same as other table. So, we can join all…

Q: Q2: Insert the following data in the following tables: A. carrier CarrierID CarrierName Phone range…

A: INSERT is the keyword used to insert a row into a table and let's see the statements to insert…

Q: plz fix the following so it runs on sql developper or sql live CREATE TABLE DONORS ( donor_id INT…

A: Need to fix the given query :CREATE TABLE DONORS (donor_id INT NOT NULL,donor_name varchar(255) NOT…

Q: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family…

A: Since I don't have access to the database, I am writing the general syntax of deleting the rows from…

Q: Lab 3 Q1. Create the following tables: A. Carrier Attribute name carrierID Туре Varchar2 Size…

A: Question 1) Crate table queries The "CREATE TABLE" command is used in sql to create table in a…

Q: *Develop a SQL Query Display all the resorts names whose star-rating ranges between 4 and 5. Sort…

A: Given: Display all the resorts name whose star rating ranges between 4 and 5. Sort the results set…

Q: database: sql Q1. Create the following tables:   Carrier   Attribute name Type Size Constraint…

A: here in the question ask for a query to create this tables.