CREATE TABLE EMP
(ID NUMBER,
EMP_NAME VARCHAR2(50),
ADDRESS VARCHAR2(500));
CREATE TABLE PROJECT
(ID NUMBER,
EMP_ID NUMBER,
PROJECT_NAME VARCHAR2(50),
LOCATION VARCHAR2(500))
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
I guess the provided question information is insufficient.
But if you are looking to fetch data from the tables without using union and union all then try below.