The common requirements of all questions are the same. Read each question carefu
ID: 3752883 • Letter: T
Question
The common requirements of all questions are the same. Read each question carefully and submit a query to fulfill for each question. Also, students need to submit the result of the corresponding query under the query. printed on the screen without any modification. If necessary, the column names appearing in the result should be converted appropriately using "AS" statement. Also, assignment has to be written with Microsoft Word for feedback. For technical issue, other formats, such as image, sql, are not appropriate to receive feedback and comments. Don't delete or change questions. You just need to insert both your TEXT query and captured screenshot result under your query The query result should be copied and pasted as it is 1. Using SELECT statement with CHR function, || Operator, and referring ASCII table, print your full name. Also, there should be a space between first and last name (20 points) Eg) SELECT CHR(67) from dual 2. Show department names and manager IDs. If manager is not assigned, then replace null with "No Manager is assigned" (5points) 3. Using the NVL2 function, show the same results of the following select statement. (5 in SELECT first name, salary, commission _pct, salary + (salary* NVL(commission pct,0) compensation FROM employees WHERE first name LIKE 'T% 4. Using INSTR function, find employees whose area code in phone number 590.(10 points), Show first name and last name, and phone number of employees. The delimiter of phone number should be replaced with '-' (10 points); Eg) SELECT 5.Explanation / Answer
1.
Select CHR("Edward") ||' '|| CHR("Cordova") from dual;
2.
Select dname,NVL(managerID,'No Manager is assigned') from Departments;
3.
Select firstname,salary,commission_pct, NVL2(salary,salary + (salary*commission_pct),salary)
) compensation from employees where firstname LIKE 'T%';
4
Select firstname, INSTR(phone,'590', 1, 3) from employees;
first 3 characters are 590
5.
Select firstname,lastname,REPLACE(phone,' ' ,'-') from employees;
spaces will be replaced with -
Do ask if any doubt. Please upvote.