Oracle SQL Practical question | SQL to fetch Emp hierarchical data in Flat format

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

This channel is for leaning 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 10 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

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

[markippo]

"In the second approach, you're accessing the table only once". No, you're not. You're accessing it exact number of times like in the first query. The main difference is that the first query is static, the second - recursive - it will repeat the join predicate as long as it will not return an empty table. I'd say the second approach is less optimal in terms of performance (you're building the hierarchical path and using regular expressions which are kinda heavy), it's more advanced but definitely not lightweight.

[subhajitkar]

Really good example of heiarchical query

[kyshore]

Hi.. A Big Thank you for your efforts.. Videos are really very help full. May I request for
1. Best approach to delete millions of data
2. Best approach to update millions of data
considering table is partitioned or non partitioned

[hanishsyan]

Hi Sir,

I have been scorching my head on this scenario. Thank you so much

[ranajparida]

Hi Sir,
Appreciate for your effort. But I was searching for the complete video for Oracle performance tuning but I got few incomplete videos in YouTube.
I would really requesting you to create a playlist dedicated on Oracle performance tuning. How much important will be the topic you will notice once you will upload those videos.
I can help you on the topics that need to be covered. Below I have given the topics.
1.Oracle Database Architecture
2.Oracle Execution Plans/Explain Plans
3.Explain Plan Content
4.Indexes
5.Where Clause Processing
6.Sorts/Views/Sub-Query Processing

You can add more topics on Performanc tuning videos whatever you feel important.

Regards,
Ranaj

[RoarMaddy]

Thank you sir for your valuable knowledge.

[krishnayeole]

Hello Sir,
Your videos are really good and helpful in understanding concepts in depth.
Could you please upload videos related to XML operations
and DBMS scheduler.

[thirumalasettianusha]

concept wise vedios we want please post sir sql and plsql concept wise vedios

[ranajparida]

Thanks for creating the video. Really appreciate. Keep going..

[PrayasITandRobotics]

Hi Sir,
For leafnode, it seems like we are selecting 4th word from comma separated values. How to fetch leaf node without knowing number of words in the data value. Or the last word from the leaflist record ?

[ravibathula]

i need table a data that does not exit in table b/ table c with out using left join and not exist how to perform this action

[ujjwalgiri]

Dear Siva sir please upload a video related to real use of GTT & PTT, have been asked this question in lots of companies that how u used Global Temp table & private temp table in ur project ..

[devanaidu]

Hello sir..very very useful video again..thank you somuch and please make videos on performance tuning sir..

[jainaraianrai]

Hi Sir, I m a big fan of you. I have learnt much from video. So I am very grateful to you.
I facing a problem and hope you will be help. I want to generate attendance sheet. But logic is if employees attend minimum four day in last week, and both side

[kalpeshpatil]

Sir please make a video on regular expression please sir🙏🙏

[nileshdivate]

Hi Sir....can you please make video to calculate median...without using any windowing function

[srikanthbanakar]

Hi sir can you explain us regular expression ... And I some questions which are asked in my recent interview so where I can share those questions to get query for that from you can you please help me in those questions.

[viaanplayz]

Hi Siva,

I have emailed you my query. Please can you have a look .