Question
PS6 1 . Log in to your Oracle ApEx account. 2. Create a SQL query in the SQL command window showing the empno, ename, job,
PS6
1. Log in to your Oracle ApEx account.
2. Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate, and the number of years that the employee has worked for the company from the emp table. Use the months_between() function along with the SYSDATE to show how many years the employees have been working for the company. Limit your results to employees who have been working for the company more than 35 years.
Copy and paste your SQL query along with a screenshot of your result set into your assignment.
3. Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table. Use the hiredate column to get all of the employees hired in 1980 and all of the employees hired in the first four months of 1981.
Copy and paste your SQL query along with a screenshot of your result set into your assignment.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started