Subqueries in ORACLE - ORACLE 19C SQL & PL/SQL Full Course in Telugu-Lesson-24

Subqueries in ORACLE - ORACLE 19C SQL & PL/SQL Full Course in Telugu-Lesson-24

#edusoft4u #edusoftlearningsystems#vijaykumarparvathareddy Download Subject related examples & Exercises at: https://edusoftdownloads.blogspot.com This video is part of Edusoft Learning Systems Computer software training in Telugu video series & ORACLE 19C-SQL & PL/SQL Full Course. This video explained by VIJAY KUMAR PARVATHAREDDY. This video explains about Subqueries in ORACLE. types of subqueries in oracle. ----------------------------------------------- Single Row Subquery Multiple Row Subquery Multiple Column Subquery Inline View Subquery Sub queries in oracle Example Data ---------------------------------- CREATE TABLE DEPT ( DEPTNO NUMBER(2) primary key, DNAME VARCHAR2(10), LOC VARCHAR2(15) ); INSERT INTO DEPT VALUES(10,'PRODUCTION','HYD'); INSERT INTO DEPT VALUES(20,'PURCHASE','CHENNAI'); INSERT INTO DEPT VALUES(30,'SALES','BANGALORE'); CREATE TABLE EMPLOYEE ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4), HIREDATE DATE, SAL NUMBER(7, 2), COMM NUMBER(7, 2), DEPTNO NUMBER(2),Constraint fk foreign key(deptno) references dept(deptno) ); INSERT INTO EMPLOYEE VALUES (7369, 'SMITH', 'CLERK', 7902, TO_DATE('17-DEC-1980', 'DD-MON-YYYY'), 800, NULL, 20); INSERT INTO EMPLOYEE VALUES (7499, 'ALLEN', 'SALESMAN', 7698, TO_DATE('20-FEB-1981', 'DD-MON-YYYY'), 1600, 300, 30); INSERT INTO EMPLOYEE VALUES (7521, 'WARD', 'SALESMAN', 7698, TO_DATE('22-FEB-1981', 'DD-MON-YYYY'), 1250, 500, 30); INSERT INTO EMPLOYEE VALUES (7566, 'JONES', 'MANAGER', 7839, TO_DATE('2-APR-1981', 'DD-MON-YYYY'), 2975, NULL, 20); INSERT INTO EMPLOYEE VALUES (7654, 'MARTIN', 'SALESMAN', 7698, TO_DATE('28-SEP-1981', 'DD-MON-YYYY'), 1250, 1400, 30); INSERT INTO EMPLOYEE VALUES (7698, 'BLAKE', 'MANAGER', 7839, TO_DATE('1-MAY-1981', 'DD-MON-YYYY'), 2850, NULL, 30); INSERT INTO EMPLOYEE VALUES (7782, 'CLARK', 'MANAGER', 7839, TO_DATE('9-JUN-1981', 'DD-MON-YYYY'), 2450, NULL, 10); INSERT INTO EMPLOYEE VALUES (7788, 'SCOTT', 'ANALYST', 7566, TO_DATE('09-DEC-1982', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMPLOYEE VALUES (7839, 'KING', 'PRESIDENT', NULL, TO_DATE('17-NOV-1981', 'DD-MON-YYYY'), 5000, NULL, 10); INSERT INTO EMPLOYEE VALUES (7844, 'TURNER', 'SALESMAN', 7698, TO_DATE('8-SEP-1981', 'DD-MON-YYYY'), 1500, 0, 30); INSERT INTO EMPLOYEE VALUES (7876, 'ADAMS', 'CLERK', 7788, TO_DATE('12-JAN-1983', 'DD-MON-YYYY'), 1100, NULL, 20); INSERT INTO EMPLOYEE VALUES (7900, 'JAMES', 'CLERK', 7698, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 950, NULL, 30); INSERT INTO EMPLOYEE VALUES (7902, 'FORD', 'ANALYST', 7566, TO_DATE('3-DEC-1981', 'DD-MON-YYYY'), 3000, NULL, 20); INSERT INTO EMPLOYEE VALUES (7934, 'MILLER', 'CLERK', 7782, TO_DATE('23-JAN-1982', 'DD-MON-YYYY'), 1300, NULL, 10); Touch with us at: http://youtube.com/edusoft4u http://www.facebook.com/edusoft4u https://twitter.com/edusoft4u https://www.instagram.com/edusoft4u/ Visit https://www.edusoft4u.com/ Call us at : 9676905431