Oracle SQL Practical question | SQL to find the set of rows in hierarchical relational data

Oracle SQL Practical question | SQL to find the set of rows in hierarchical relational data
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

--------------------------------------------------------------

[nagarajupadarti]

Excellent explanation very very happy..Loved it sir

[madhukumarmadhukumar]

Marvellous, thanks for coming up with these amazing realtime questions and answering them

[bharatbagul]

Siva your all videos you explain very nicely..could you make video on how to read explain plan..

[ramuvelu]

hi Siva,
can you answer for the question .
create table Table_A(Name varchar2(50), Location Varchar2(20), Indicator varchar2(20));

insert into Table_a values('Sasi', 'stl', 'Y');
insert into Table_a values('Sasi', 'hyd', 'N');
insert into Table_a values('vivek', 'chd', 'N');
insert into Table_a values('vivek', 'stl', 'Y');
insert into Table_a values('Sarath', 'hyd', 'Y');

select * from table_a;

Sasi stl Y
Sasi hyd N
vivek chd N
vivek stl Y
Sarath hyd Y

expected output:
sasi hyd stl
vivek chd stl
sarath null hyd

[yogeshvaidya]

Hi Siva sir, please explain hierarchical related data with cycle

[padmapriya]

Hi Siva sir,

I got one question in my interview can u please help me in solving it

There is a table which has four values in a column such as India, Pakistan, Newzealand, Australia. We need out put like the matches between these four countries like Ind vs Pak, Ind vs NZ etc.