15. Assume thatthe table EMP hasthe following data EmpNo Surname Firstname 1 Smith Fred 2 Jay...
15. Assume thatthe table EMP hasthe following data
EmpNo Surname Firstname 1 Smith Fred 2 Jay Emma 2 Phelps Mark Consider the following statement: SELECT Firstname || ' ' || Surname FROM Employee
What is displayed?
Homework Answers
We use || ' ' || to concatenate strings with a space between the two strings.
So the query will show the complete name of the employees separated by a space. The output will be:
Fred Smith
Emma Jay
Mark Phelps
Hope this helps.
Add Answer to:
15. Assume thatthe table EMP hasthe following data
EmpNo Surname Firstname 1 Smith Fred 2 Jay...
16. Consider the following statement: SELECT Firstname || ' ' || Surname FROM Employee WHERE INSTR(Firstname,...
16. Consider the following statement: SELECT Firstname || ' ' || Surname FROM Employee WHERE INSTR(Firstname, 'm') > 0 What is displayed?
emp table in bellow: 5. Query data from emp table for each non-deptno 20 employees to...
emp table in bellow:
5. Query data from emp table for each non-deptno 20 employees to display the ename and calculate the number of months between today and the date the employee was hired. Label the column heading to Ename and Months_Worked. Order your results by the number of months employed. Round the number of months to a whole number. Months _Worked - - - - - - - - Ename MILLER KING JAMES MARTIN TURNER CLARK BLAKE WARD ALLEN...
DROP TABLE EMPLOYEE; DROP TABLE JOB; DROP TABLE EMP; DROP TABLE EMP_1; DROP TABLE EMP_2; CREATE...
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE EMP;
DROP TABLE EMP_1;
DROP TABLE EMP_2;
CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION
VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT
NULL,JOB_LAST_UPDATE DATE NOT NULL);
INSERT INTO JOB
VALUES('500','Programmer','35.75','20-Nov-2017');
INSERT INTO JOB VALUES('501','System
Analyst','96.75','20-Nov-2017');
INSERT INTO JOB VALUES('502','Database
Designer','125.00','24-Mar-2018');
CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME
VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL
CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS
NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE));
INSERT...
Need help with Questions 6-8 specifically number 8. Here is what I've got for question 4...
Need help with Questions 6-8 specifically number
8.
Here is what I've got for question 4 which needs to be modified
to answer question 8.
This is what I got so far for questions 6-8
Please help me modify 8. Also do note that the first
statement is 6 then the second is 7 and the last statement that is
highlighted is question 8 in the following screencap:
1 List all project names and manager names in charge projects. 2...
Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3...
Given the following table (Authors table) AuthorID FirstName LastName 1 Paul Deitel 2 Harvey Deitel 3 Abbey Deitel 4 Dan Quirk 5 Michael Morgano What does the following Query produce when executing on the above table: SELECT AuthorID, FirstName, LastName FROM Authors WHERE LastName LIKE 'D%'
1. Create a PL/SQL program block that determines the top students with respect to GPA. Assume...
1. Create a PL/SQL program block that determines the top students with respect to GPA. Assume that the database has four tables. Student(SSN, SName, DOB, Major) , Grade(SSN, CNo, Grade(0,1,2,3,4)) and Course table(CNo,CName, Credit Hour), Prerequisite(CNo, PreCNo); Student and couse data ae given in the following SQL statements a. Accept a number n as user input with SQL*Plus telling top n%. b. In a loop get the SName and GPA of the top n% people with respect to GPA. c....
Lesson 10Create the DEPARTMENT tables based on the following: Column Name ID Name Data Type Number...
Lesson 10Create the DEPARTMENT tables based on the following: Column Name ID Name Data Type Number Varchar2 Length 7 25 Populate the DEPARTMENT table with data from the DEPT table. Include only columns that you need. Create the EMPLOYEE table based on the following table chart: Column Name ID LAST_NAME FIRST_NAME DEPT_ID Data Type Number Varchar2 Varchar2 Number Length 7 25 25 7 Modify the EMPLOYEE table to allow for longer employee last names. Confirm your modification. Confirm that both the...
data base Given the data model shown below, please define the following: 1) Table names 2)...
data base
Given the data model shown below, please define the following: 1) Table names 2) Primary keys for each table. If the key is composite, please indicate. 3) Foreign Keys for each table and what table/field the FK relates to 4) Define which table is the "Parent" and is the "Child" in the relationship. EMPLOYEE(Employee Number, ElastName, FirstName, EAddress, Ecity, EZipCode, EDepartCode) DEPARTMENT(DepartmentCode, DeptName, Dept Div) DIVISION(DivisionCode, DivName, DivvP) EPHONE(PhoneID, EmpNum, Phone Number, Phone Type) TTT Arial 3 (12pt)...
Financial statement Data Table a. In column (1) indicate b. In column (2), indicate whether the...
Financial statement Data Table a. In column (1) indicate b. In column (2), indicate whether the account is a current asset account identification Mark each of the accounts listed in the following tablE asfollows in which stabement-income statement (1S) or balance sheet (BS)-the account belongs (CA), current Sability (CL), expense (E), fxed asset (FA) Select from the drop down menus) Account Name Accounts payable Accounts receivable Accuals Accumulated depreciation Administrative expense Statement Type of Account Account Name Accounts payable Type...
C++ The programming language is c++ our program using the following data Mary Smith Green walley...
C++
The programming language is c++
our program using the following data Mary Smith Green walley Thul Bool Gauteng ) Please key is the n ot your Ter in your mark for Mathematics Ey in your mark for use orientation Key in your mark for watory Wer in your work for Computer literacy Te in r for at e Jobs Africa School: King College 9/11 - Average Year Wark53.67 with label and code The T a QUESTION 2: (40) Suppose...
emp table in bellow:
5. Query data from emp table for each non-deptno 20 employees to display the ename and calculate the number of months between today and the date the employee was hired. Label the column heading to Ename and Months_Worked. Order your results by the number of months employed. Round the number of months to a whole number. Months _Worked - - - - - - - - Ename MILLER KING JAMES MARTIN TURNER CLARK BLAKE WARD ALLEN...
DROP TABLE EMPLOYEE;
DROP TABLE JOB;
DROP TABLE EMP;
DROP TABLE EMP_1;
DROP TABLE EMP_2;
CREATE TABLE JOB(JOB_CODE CHAR (3) PRIMARY KEY, JOB_DESCRIPTION
VARCHAR (20) NOT NULL,JOB_CHG_HOUR NUMBER (5,2) NOT
NULL,JOB_LAST_UPDATE DATE NOT NULL);
INSERT INTO JOB
VALUES('500','Programmer','35.75','20-Nov-2017');
INSERT INTO JOB VALUES('501','System
Analyst','96.75','20-Nov-2017');
INSERT INTO JOB VALUES('502','Database
Designer','125.00','24-Mar-2018');
CREATE TABLE EMPLOYEE(EMP_NUM CHAR (3) PRIMARY KEY,EMP_LNAME
VARCHAR (15) NOT NULL,EMP_FNAME VARCHAR (15) NOT NULL, EMP_INITIAL
CHAR (1),EMP_HIREDATE DATE NOT NULL,JOB_CODE CHAR (3), EMP_YEARS
NUMBER (2),FOREIGN KEY (JOB_CODE) REFERENCES JOB (JOB_CODE));
INSERT...
Need help with Questions 6-8 specifically number
8.
Here is what I've got for question 4 which needs to be modified
to answer question 8.
This is what I got so far for questions 6-8
Please help me modify 8. Also do note that the first
statement is 6 then the second is 7 and the last statement that is
highlighted is question 8 in the following screencap:
1 List all project names and manager names in charge projects. 2...
data base
Given the data model shown below, please define the following: 1) Table names 2) Primary keys for each table. If the key is composite, please indicate. 3) Foreign Keys for each table and what table/field the FK relates to 4) Define which table is the "Parent" and is the "Child" in the relationship. EMPLOYEE(Employee Number, ElastName, FirstName, EAddress, Ecity, EZipCode, EDepartCode) DEPARTMENT(DepartmentCode, DeptName, Dept Div) DIVISION(DivisionCode, DivName, DivvP) EPHONE(PhoneID, EmpNum, Phone Number, Phone Type) TTT Arial 3 (12pt)...
Financial statement Data Table a. In column (1) indicate b. In column (2), indicate whether the account is a current asset account identification Mark each of the accounts listed in the following tablE asfollows in which stabement-income statement (1S) or balance sheet (BS)-the account belongs (CA), current Sability (CL), expense (E), fxed asset (FA) Select from the drop down menus) Account Name Accounts payable Accounts receivable Accuals Accumulated depreciation Administrative expense Statement Type of Account Account Name Accounts payable Type...
C++
The programming language is c++
our program using the following data Mary Smith Green walley Thul Bool Gauteng ) Please key is the n ot your Ter in your mark for Mathematics Ey in your mark for use orientation Key in your mark for watory Wer in your work for Computer literacy Te in r for at e Jobs Africa School: King College 9/11 - Average Year Wark53.67 with label and code The T a QUESTION 2: (40) Suppose...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago