Write a query to show all employee name, present salary and 30% incremented salary of those employees who do not work in New York. Write a query to show all employees names and salaries along with their managers and their salaries. If any employee does not have a manager like ‘President’, skip that entry.
Please please do this
Using oracle APEX we are creating a table now -
CREATE TABLE DEPT(
DEPTNO NUMBER(10) NOT NULL,
DNAME VARCHAR(50) NOT NULL,
LOC VARCHAR2(30),
CONSTRAINT DEPT_PK PRIMARY KEY
(DEPTNO)
);
We use NOT NULL constraint to make the cell occupied with something related to column line
for example; we can see a lot of applications where we see (field is mandatory)
NOW EMP TABLE-
CREATE TABLE EMP(
EMPNO NUMBER(10)NOT NULL,
ENAME VARCHAR2(50)NOT NULL,
JOB VARCHAR2(50),
MGR VARCHAR2(50),
HIREDATE DATE,
SAL NUMBER(6),
COMM VARCHAR2(50)
DEPTNO NUMBER(5)NOT NULL,
CONSTRAINT EMP_FK FOREIGN KEY(
DEPTNO) REFERENCES DEPT (DEPTNO), (maintains a connection to EMP table DEPTNO)
CONSTRAINT EMP_PK PRIMARY KEY
(EMPNO)
);
- FOREIGN KEY IS used to establish the connection between any two tables
- PRIMARY KEY is used to uniquely identify records from the table
CREATE TABLE SAL GRADE (
GRADE NUMBER(10) NOT NULL,
LOSAL NUMBER(10),
HISAL NUMBER(10),
CONSTRAINT SALGRADE_PK PRIMARY KEY
(GRADE)
);
After setting up all relations, you need to apply following queries to get data from given
relations: (Write queries and also paste screenshots in answer file)
Write a query to show all employee name, present salary and 30% incremented salary of those employees who do not work in New York.
Write a query to show all employees names and salaries along with their managers and their salaries. If any employee does not have a manager like ‘President’, skip that entry.
Step by step
Solved in 4 steps with 4 images