Hey guys, I was just wondering if anyone would be kind enough to help me with my Oracle I Internet Academy work.
I've been working on it for a few days and am stumped with a few questions.
If anyone could help me your help will be greatly appreciated :] !
So without further a-do, the questions:
[04.] Write a query to return the first character of the first name concatenated to the last_name, the salary and the department id for employees working in department20. Give the first expression an alias of Name. Use the EMPLOYEES table. Change the query to use a substitution variable instead of the hard coded value 20 for department id. Run the query for department 30 and 50 without changing the original where-clause in your statement.
[05.] Using a substitution variable for the department name, write a query listing department id, department name and location id for departments located in the_department_of_your_choice. Use the DEPARTMENTS table. Note: All substitution variables in OAE are treated as character strings, so no (‘’) are needed.
[06.] Write a query that returns all the employee data depending on the month of their hire date. Use the EMPLOYEES table. The statement should return the month part of the hiredate which is then compared to an abbreviated month (JAN, FEB, MAR) passed into the query via a substitution variable.
I've been working on it for a few days and am stumped with a few questions.
If anyone could help me your help will be greatly appreciated :] !
So without further a-do, the questions:
[04.] Write a query to return the first character of the first name concatenated to the last_name, the salary and the department id for employees working in department20. Give the first expression an alias of Name. Use the EMPLOYEES table. Change the query to use a substitution variable instead of the hard coded value 20 for department id. Run the query for department 30 and 50 without changing the original where-clause in your statement.
[05.] Using a substitution variable for the department name, write a query listing department id, department name and location id for departments located in the_department_of_your_choice. Use the DEPARTMENTS table. Note: All substitution variables in OAE are treated as character strings, so no (‘’) are needed.
[06.] Write a query that returns all the employee data depending on the month of their hire date. Use the EMPLOYEES table. The statement should return the month part of the hiredate which is then compared to an abbreviated month (JAN, FEB, MAR) passed into the query via a substitution variable.