q17 Given the following tableTABLE EMPLOYEEColumnNull?ТуреEMP_IDNOT NULL NUMBEREMP_LNAMEVARCHAR2 (50)EMP_INITIALVARCHAR2 (50)EMP_FNAMEVARCHAR2(50)EMP_HIREDATEDATEREGION_IDNUMBERThe query that will return the employee's ID and his full name isaSELECT EMP_ID, EMP_FNAME||' ||EMP_INITIAL|| ||EMP_LNAME "Full Name" FROM employee.b OSELECT EMP_ID, Full Name FROM employeeSELECT EMP_ID, EMP_FNAME||" "||EMP_INITIAL||" "||EMP_LNAME "Full Name" FROM employee.d oSELECT EMP_ID, EMP_FNAME||" ||EMP_INITIAL|I ||EMP_LNAME 'Full Name' FROM employee

Answered: The query that will return the…

Engineering

Computer Science

The query that will return the employee's ID and his full name is

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Similar questions

create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id varchar(30)(select salesman_id from salesman); why does my sql server code not work, at the customer table?
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id varchar(30),CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id)); i keep getting…
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id varchar(30),CONSTRAINT FK_salesman_id FOREIGN KEY (salesman) REFERENCES salesman(salesman_id)); i keep getting this…
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
create database GA2gouse GA2gocreate table salesman(salesman_id int primary key, name varchar(30), city varchar(20), commission varchar(30));insert into salesman (salesman_id, name, city, commission) values (5001, 'James Hoog', 'New York', 0.15); insert into salesman (salesman_id, name, city, commission) values (5002, 'Nail Knite', 'Paris', 0.13); insert into salesman (salesman_id, name, city, commission) values (5005, 'Pit Alex', 'London', 0.11); insert into salesman (salesman_id, name, city, commission) values (5006, 'Mc Lyon', 'Paris', 0.14); insert into salesman (salesman_id, name, city, commission) values (5007, 'Paul Adam', 'Rome', 0.13); insert into salesman (salesman_id, name, city, commission) values (5003, 'Lauson Hen', 'San Jose', 0.12); Create table Customer (customer_id int primary key, cust_name varchar(30), city varchar(10), grade varchar(30), salesman_id int,CONSTRAINT FK_salesman_id FOREIGN KEY (salesman_id) REFERENCES salesman(salesman_id));insert into customer…
Suppose that a mattress store has a TABLE1 with sales representatives with an attribute vcode as primary key. It also has a TABLE2 with every mattress sold, the table has an attribute vcode to indicate which sales representative made the sale, and a mt_code to indicate which mattress was sold. Which of the following returns all the sales representatives that haven't closed a sale? a. SELECT * FROM TABLE1 LEFT JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NULL. b. SELECT * FROM TABLE1 JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NULL. c. SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NULL. d. SELECT * FROM TABLE1 RIGHT JOIN TABLE2 ON TABLE1.vcode = TABLE2.vcode WHERE mt_code IS NOT NULL.
I think my query needs temp variables instead of using NEW but I am not sure how. Here is my query: delimiter // DROP TRIGGER trg_pic_hours; create trigger trg_pic_hours after insert on CREW for each row begin IF NEW.CREW_JOB = 'Pilot' THEN update PILOT set PIL_PIC_HRS = PIL_PIC_HRS + ( select CHAR_HOURS_FLOWN from CHARTER where CHAR_TRP = NEW.CHAR_TRP) where EMP_NUM = NEW.EMP_NUM; END IF; END // If I run the query with the NEW.CHAR_TRP entry errors out if I remove NEW from it it will run ok. I have attached the schema
Which of the following SQL statements is invalid and returns an error message? ALTER TABLE books ADD CONSTRAINT books_pubid_uk UNIQUE (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_pk PRIMARY KEY (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_nn NOT NULL (pubid); ALTER TABLE books ADD CONSTRAINT books_pubid_fk FOREIGN KEY (pubid) REFERENCES publisher (pubid); All of the above statements are invalid.
Hi, I have the query below and I get it to run, but it is missing something how to answer the problem. My joins appear to be incorrect, I am using ID_number and S_ID. so I am completely lost there. CREATE OR REPLACE PROCEDURE Moreno_03_insCourseNumsProc(INOUT i_ID VARCHAR(5))LANGUAGE PLPGSQLAS$$DECLAREname VARCHAR(35);tot_courses INTEGER; -- Created this variable to hold the total course taught by the instructor l_exists_count INTEGER := 0; -- This is to identify the existence of the records the table instructor_course_numsBEGINSELECT name INTO name FROM instructor WHERE instructor.id = i_id;SELECT COUNT(*) INTO tot_courses FROM teaches WHERE teaches.id = i_id;SELECT COUNT(*) INTO l_exists_count FROM instructor_course_nums WHERE ID_Number = i_ID; IF l_exists_count > 0THENUPDATE instructor_course_nums SET tot_courses = total_course_nums WHERE ID_Number = i_ID;ELSEINSERT INTO instructor_course_nums VALUES(i_ID, name, tot_courses);END IF;COMMIT; END;
--Creating the tablesUSE Bobs_Home_Repair; DROP TABLE IF EXISTS dbo.BOB_EMPLOYEE; CREATE TABLE dbo.BOB_EMPLOYEE(Employee_ID INT NOT NULL UNIQUE,First_Name VARCHAR(30) NOT NULL,Last_Name VARCHAR(30) NOT NULL,Address VARCHAR(100) NOT NULL,Phone_Number VARCHAR(20) NOT NULL,Hourly_Rate MONEY NOT NULL); DROP TABLE IF EXISTS dbo.CUSTOMER; CREATE TABLE dbo.CUSTOMER(Customer_ID INT NOT NULL UNIQUE,First_Name VARCHAR(30) NOT NULL,Last_Name VARCHAR(30) NOT NULL,Address VARCHAR(100) NOT NULL,Phone_Number VARCHAR(20) NOT NULL,); DROP TABLE IF EXISTS dbo.INVOICE; CREATE TABLE dbo.INVOICE(Invoice_ID INT NOT NULL UNIQUE,Job_ID INT NOT NULL UNIQUE,Customer_ID INT NOT NULL UNIQUE,Material_ID INT NOT NULL UNIQUE,Invoice_Date DATE NOT NULL,Invoice_Amount MONEY NOT NULL,Invoice_Due DATE NOT NULL,Invoice_Paid_Full_Amount CHAR(1) NOT NULL,Balance_Paid MONEY NOT NULL,Balance_Remaining MONEY NOT NULL); DROP TABLE IF EXISTS dbo.MATERIALS; CREATE TABLE dbo.MATERIALS(Material_ID INT NOT NULL UNIQUE,Job_ID…