Oracle SubQueries Part - 1 by Dinesh

[@timoon423]

Thanks for the lesson. I'd already known this topic but your clear explanation helped a lot to get understanding when to use joins and when subqueries. After that, I found it clear, what and why affects performance.

[@satvinderbhangu361]

Thanks 🙏. I had asked to your institute related to power center infomatica tool . They email me they do not provide infomatica training. I saw so many sql videos on you tube . You have outstanding knowledge of oracle . God bless you sir

[@praveen_balagam]

Your explination deserve more likes...

[@CanadaJourney319]

A SQL query is not an instruction to the database about how to retrieve the result set you want, instead, it's a description of the data you want. How to get it is up to the database. Oracle will rewrite your query into an execution plan. It will search for what it thinks is the most efficient plan based on your tables, indexes, constraints, the statistics it gathers, and even guesses it makes based on the data as it goes. In fact, it's very possible you can write this query with a join and with a subquery and it leads to the exact same execution plan and the same performance. My suggestion is to write the query so that it is easy to understand what is going on. Only if the performance is actually poor should you worry about what it's doing. Oracle is pretty smart and may well find a route to your data that is better than you thought it would be. There will be moments where a join is the ideal when dealing with large data. A table with just a few rows you can just use select and where as a subquery. It's best to know when to use each.

[@DurgaSoftwareSolutions]

Hello Manikandan. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@vinothkumarbalaraman1269]

Excellent explanation, you made the subject so simple

[@chandrikareddy2473]

Nice explanation sir thank you so much

[@Traveltoreality]

thanks for the tutorial sir. its very helpful and its so easy to understand :)

[@michaely5375]

Thank you for your perfect explanation. Thank you again.

[@1sbollap]

thank you. clear and easy to understand explanation

[@cool-ke7gx]

Thank u soo much sir, simply awesome......

[@likithagunda5842]

Thanku...crystal clear Tutorial..!!!

[@adityaputcha5474]

awesome explanation

[@reshaknarayan3944]

May God bless you!

[@DurgaSoftwareSolutions]

Hello Reshak, Thanks for your valuable feedback.It will boost us to do new things. Please subscribe to get updates about new videos. You can view all other Oracle Videos in the following link: Oracle11g by Dinesh goo.gl/bJDrzd Oracle 11g by Srikanth goo.gl/vezMqz Oracle 11g by Siva goo.gl/jpSqMr Oracle 11g/12c By Expert Faculty kzbin.info_all_playlists?sq=oracle Oracle 12c by Basha goo.gl/F26d6R

[@satadhi]

Sir at 18:05 in where clause you wrote dname = 'Accounting' , i think it should be dname like 'Accounting' ? can you explain what is the difference between two ?

[@balaravichandran5761]

Satadhi Halder like and = both are comparsion operators which is uaed to compare single value

[@PriyankaPatil-ys4gj]

Tqsm sir🙏

[@sharadpawar8637]

if we get multiple values from sub query and we have to compare those values with ''>" operator then how we can do it ? please help

[@DurgaSoftwareSolutions]

Hello Sharadpawar. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@felixnyenti2506]

Thank you very much Mr Dinesh for your brilliant tutorial videos. I live in the USA how can i order your videos on oracle? I need complete training on Oracle SQL. Your explanations are very clear.

[@roverteam4914]

Subquery can also be said for the FROM clause?

[@DurgaSoftwareSolutions]

Hello Rover Team. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@mrwangxingcai6711]

well explained. Thanks

[@cjyothi6772]

Thank u soo much sir

[@bhagyashriadik8242]

Hello sir, 'tufts_jully_2021_lnvc.csv' This is the data in the oracle . So how to convert into the jully using substr. can you help me how to solve this

[@DurgaSoftwareSolutions]

Hello Bhavgyashri. Plz contact our online team [e-mail] or call us on this number [phone], 7207212427/28

[@chethanshrinivas6505]

thank you sir

[@kirankumarbelagali3741]

sir plz make video on inline subquery

[@shubhamchaubey2654]

evrything explained is gd but only your cameraman is lazy😜

[@rajurajendra2472]

u did not explained difference b/w join and subquery well..learn and come here to explain

[@loveroflight7797]

explanation is excellent but video projection is not good

[@araja3755]

Great explanation