Practical Lab Example of Union vs Union ALL in Oracle sql plsql tutorial interview questions
Practical Lab Example of Union vs Union ALL in Oracle sql plsql tutorial for interview questions and answers for experienced and fresher candidates.
Below are the sql
create table twitter(Name varchar(20),Location varchar(30));
create table Linkedin(Name varchar(20),Location varchar(30));
INSERT ALL
INTO twitter(Name,Location) values('Rahul','India')
INTO twitter(Name,Location) values('Rakesh','India')
INTO twitter(Name,Location) values('Liza','US')
SELECT * FROM DUAL;
select * from twitter;
INSERT ALL
INTO Linkedin(Name,Location) values('Rakesh','India')
INTO Linkedin(Name,Location) values('Sohan','India')
INTO Linkedin(Name,Location) values('Liza','US')
SELECT * FROM DUAL;
select * from Linkedin;
select * from twitter
union all
select * from Linkedin;
select * from twitter
union
select * from Linkedin;
select to_date(sysdate,'dd-mm-yyyy') from dual
union
select to_date(sysdate,'dd-mm-yyyy') from dual
select to_date(sysdate,'dd-mm-yyyy') from dual
union all
select to_date(sysdate,'dd-mm-yyyy') from dual
create table department(name varchar(10));
create table employee (name varchar(10));
insert into employee
select 'Rahul' from dual
union
select 'Rakesh' from dual
union
select 'Monkey' from dual
union
select 'Tiger' from dual
select * from employee
insert into department
select 'Rahul' from dual
union
select 'Rakesh' from dual
union
select 'Monkey' from dual
union
select 'Tiger' from dual
select * from department
select * from employee
union
select * from department
select * from employee
union all
select * from department
select * from employee e join department d
on e.name=d.name