Full Concept of Hierarchical Queries Or Connect by Queries in Details

#Connectbyclause
Topic:- This video explains the concept of " Hierarchical Queries OR Connect by Queries
in Oracle.
1. On which data these connect by queries are works.
2. how it works
3. why it required
4. Pesudo Columns in Hierarchical Queries OR Connect by Queries
with appropriate examples.
it very helpful to all the students and beginners as well. so keep going with oracle shooter.
• Actual Concept of Pseu... :- Actual Concept of Pseudo Column in Oracle
PlayList:- Oracle Apps Technical
Concept :- #Btree#Composite#Unique#Reversekey #Functionbased#bitmap
Related Videos:-
1. What does Indexes in our queries and why our queries are running slow
:- • What does Indexes in o...
2. All indexes at one place, B-Tree, Composite, Unique, Reverse Key, Function-Based, Bitmap Index
:- • All indexes at one pla...
3. B-Tree Index sounds like hard but seriously friends it's very very simple
:- • B-Tree Index , sounds ...
4. Composite and Unique index and difference with B-Tree with Example
:- • Composite and Unique i...
5. How the Function-based index works in oracle
:- • How the Function based...
6. Bitmap index, how it works
:- • bitmap index and how i...
7. Reverse Key Index
:- • Reverse key index with...
Full Blogs Link:-
oracleshooter....
My Vlog Channel link:-
/ mylifemyface
Some Full of Entertainment Videos links as below:-
• Video
• Mylife Myface Vlog #22...
• Video
Contact Info:-
Instagram:- / mylifemyface
Facebook :- / mylifemyface11
Twitter :- / mylifemyface11
Blogger :- oracleshooter....
Email Id :- [e-mail]
Telegram Link:- t.me/joinchat/...
whatsapp Group :- chat.whatsapp....

[@vikram4755]

Covered all aspects, appreciate your efforts. probably one of the best explanation for Connect by on KZbin :)

[@OracleShooter]

Thanks Vikram

[@durgaprasadsriramoji5111]

The best tutorial on Hierarchical queries till date I would say.

[@jrdesaria]

Great explanation of concept!

[@sharmaakarsh]

Wow what a tutorial..deserve thousands of likes

[@OracleShooter]

Thanks Aakarsh

[@jeevanpanigrah]

Locks in SQL lecture please sir.

[@bholanathm7211]

This video deserves a big like and thanks!! Thank you for making this concept so simple, anyone can understand it!! Please make a video on PIVOT and UNPIVOT if possible..

[@namanmalik2683]

Great Explanation!!

[@OracleShooter]

Thank you

[@nikhilgarg009]

Too easy to understand

[@OracleShooter]

Thank Nikhil

[@ovaispathan5065]

Awesommmmmme brother... i was searching for this topic but the online content was very confusing but u have nailed it .... love from USA .....

[@OracleShooter]

Thanks brother

[@kumarbharti1283]

Awesome..!! Well Explained...!!!

[@OracleShooter]

Thanks a lot 😊

[@abinashmandal7925]

Best one You touched everything in Hierarchical queries....

[@sourabhnolkha1382]

Thanks for this video. Amazing explanation!

[@tarunsharma1233]

Very good Manoj

[@asrytube]

Thank you for easy explanation. Sab samajh gaye lekin last topic "CONNECT_BY_ISCYCLE" smajha nhi. 3 baar video dekh chuka. Aur repeat mode me dekhenge :D Have a great day!

[@OracleShooter]

Thank you

[@NomanKhan1886]

Nice video and amazing explanation ,, how I can use these queries in SQL server

[@crmali548]

Superb

[@OracleShooter]

Thanks

[@amangoel6971]

what is the difference between connect by level and connect by prior? and how connect by level works with dual table like select level ,12 from dual connect by level=5;

[@allpractical]

MashAllah Bohat zabardast Video Sir g

[@OracleShooter]

शुक्रिया

[@parthacodes5893]

Its amazing,no one can summarize this much

[@basitshabbir2504]

A lot of thanks

[@OracleShooter]

Thank you bro

[@KashifAslam_Official]

SUPERB WORKING BUNDLE OF THANKS MAN

[@gouthamgoud7273]

super what a explanation..amazing

[@reachanand438]

Beautifully explained hierarchical queries and the related pseudo columns. Made it easy to understand. Thank you

[@OracleShooter]

Thank you

[@abhijitmane9949]

Thanks 🙏🙂

[@MyFraggi]

Very Nice Detailed Explanation

[@Shimpivaibhav0922]

HI Sir, You are simply Awesome.. I was actually ignoring this particular concept to learn bcoz of its complexity but aapne is complex concept ko bohot hi simple karke practically explain kiya. I really appreciate your hard work and efforts. Keep doing this good work. Lots of thank you Sir...

[@amitarya-iy1ok]

thankyou so much sir

[@subramanianoracle4227]

actually i dont know hindi. but i can understand the concept clearly from your tutorial. best tutorial for hierarchical queries.

[@OracleShooter]

Thank you so much

[@MadForCs16]

Very clear explanation !! Thank you very much !!!!

[@kapilsana3134]

Thanks for your tutorial. I have one query, If there are multiple value at root and each value have their child and leaf at this time what we Wright at the place of column value in Start with column_name =?

[@kingdon754]

🙏🙏🙏

[@Mritunjaykumar-vg2zx]

Unmatched video

[@OracleShooter]

Thank you

[@pankajkharade6936]

superb explanation 👍👍👍

[@ananditakansal6614]

When using sys_connect_by_path, it throws error 'the result of concatenation string is too long' how to handle it in hierarchical queries.? Can we use listagg?

[@atuldhumal8907]

Superbbb..

[@rohitmalviya3]

Very well explained, Many Thanks!

[@OracleShooter]

Thank you Rohit

[@ingitchopra6921]

Very Nice

[@pravinkumar-ug8bg]

Well explained.

[@soomro9824]

can we join multiple tables ? CONNECT BY PRIOR and START WITH like emp table with mgr table ? please reply

[@msohan007]

How can I SELECT cousins? using sql?

[@VinodYadav-fe6xe]

Once again Nice Videos SirG.. Aap UTL_SMTP,UTL_MAIL,UTL_TCP Ke videos share karo na .. muje usme kuch samaj nahi aata ki ye method kaam kese karta he .. sendi email via PL-Sql aur attachment kese send kar sakte he and how to send email to multiple email ID's .

[@OracleShooter]

Okey vinod

[@asifiqbal5877]

Please Teach about left and right outer joins in oracle sql

[@enockoloo3814]

its great but can you recreate/post English version?

[@durgaprasadsriramoji5111]

Can u please explain a query for, How to find out the count of employees being controlled (managed) directly or indirectly by each employee acting as a manager?

[@durgaprasadsriramoji5111]

I got this query now.

[@vaniganapathi830]

I don't know Hindi. It will be useful if it is having eng sub

[@sayantanghosh8237]

Can you give a example of no cycle?

[@Rishabhsingh-db9ms]

Hi sir...mujhe ak doubt h ... mujhse interview me pucha gaya tha ki agar aapko ak interface banana h to aap kis method ka use karege API ke through banaege ya interface tables ka use karege or kyu....and kiske kya advantage h or disadvantage h.

[@OracleShooter]

Haan to rishabh aap ko bolana tha ki interface table ke hi thru banayenge kyu ki API to direct base table mai data daal deti hai

[@hopess-nm4ij]

Was that intervuew for fresher or experience I am learning same I am a fresher

[@IMdAbdulquadirKhan]

bhai please pivot and unpivot samjha do!!!!!!!

[@OracleShooter]

Unpivot : kzbin.info/www/bejne/jHPFlKaclMZ5oNk

[@vru5696]

can we use Connect by in SCD 2 scenario to update previous record end_date?

[@vru5696]

It's not working.

[@avinashjha7969]

Sir aapka sql ka sara video mil sakta h

[@kiranpatil444]

Connect by NOCYCLE PRIOR is not explained

[@andelephantscanfly]

what language is this

[@sangrambal9315]

Sir source code milega kya? 🙄

[@DeinlieblingsEmre]

You catfished me Sir, english title but video in hindi. I like india, maybe I should start learning Hindi or Urdu.

[@OracleShooter]

Thank you so much

[@sujataroy944]

Nice explanation ... Thanks for clearing the concept