Create a sql query in the sql command window showing

Assignment Help Computer Engineering

Reference no: EM132111173

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.

Reference no: EM132111173

Questions Cloud

Create a sql query that lists the id and policy id : Create a SQL query that lists the ID, Policy ID, county, construction and line for residential properties between Clearwater in the south.

Write a sql query that will give the employee number : Write a SQL query that will give the employee number, employee name and hired date from the EMP table.

Create a sql query that will use the count function : Create a SQL query that will use the count function to return the number of employees in each department in the emp table.

A program to simulate signals of a pedestrian traffic light : Specifically, the car lantern will light up for 10 seconds, then turn off and turn on the pedestrian traffic light for 7 seconds.

Create a sql query in the sql command window showing : Create a SQL query in the SQL command window showing the empno, ename, job, sal, hiredate from the emp table.

Identify all of the structural constraints : Identify all of the structural constraints. ER diagram required using CHEN'S notation with list of assumptions made.

Design a program that continuously accepts : Design a program that continuously accepts an author's name, number of books Written, and target reader age until a sentinel value is entered.

Write a for loop that checks whether two string arrays : Rewrite the following for loop using the "for each" construct to add the length of each String element from the data array to the totalLength.

Create a cell phone app that will allow the user to view : A timeline, with check off dates (dates for different parts of the project to be completed and approved by your boss), and a completion date.

User Account

All Pages