Display the data of all employees who do not have managers. (means whose managers are null) Display the names of all employees where the third letter of the name is ‘a’. Write a query to display all employee records who have been hired in the month of February
Question No 1:
Here we have Creating table code according to syntax in Oracle APEX.
CREATE TABLE DEPT (
DEPTNO NUMBER(10) NOT NULL,
DNAME VARCHAR2(50) NOT NULL,
LOC VARCHAR2(50) ,
CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO)
);
CREATE TABLE EMP(
EMPNO NUMBER(10) NOT NULL,
ENAME VARCHAR2(50) NOT NULL,
JOB VARCHAR2(50) ,
MGR VARCHAR2(50) ,
HIREDATE DATE,
SAL NUMBER(5) ,
COMM VARCHAR2(50) ,
DEPTNO NUMBER(10) NOT NULL,
CONSTRAINT EMP_PK PRIMARY KEY (EMPNO),
CONSTRAINT EMP_FK FOREIGN KEY ( DEPTNO ) REFERENCES DEPT (DEPTNO )
);
CREATE TABLE SALGRADE (
GRADE NUMBER(10) NOT NULL,
LOSAL NUMBER(10) ,
HISAL NUMBER(10) ,
CONSTRAINT SALGRADE_PK PRIMARY KEY (GRADE)
);
Task to do
Display the data of all employees who do not have managers. (means whose managers are null)
Display the names of all employees where the third letter of the name is ‘a’.
Write a query to display all employee records who have been hired in the month of February.
Step by step
Solved in 4 steps with 3 images
