Oracle 12c new feature | Oracle LATERAL Inline View from 12.1 onwards 

The best explanation for lateral views on the internet. Keep up the good work!

I don't have words to express the way you are helping me and db community guys in so simple way. I am accepting you as my Guru . Take a bow! Been watching your videos from last 3 days , preparing myself for interview. Hope I will get a love your side on my comment. I know what it means, being a RU-vidr. Thanks a lot for your tremendous work

Hello Sir, you're Amazing! Thank you for your continuous contribution to the DB community. 👍

Table1. Table2 ID. ID 1. 1 2. 3 3. 4 5 Output 2 4 5 How to write a query to get above output

Thank you for such good explanation. Can you please help to answer which method to use on large set of data ? Performance wise which method will be better ?

Hi Siva can you a separate video on regulae expression which include all the regular expression (REGEXP_LIKE,REGEXP_INSTR,REGEXP_SUBSTR,REGEXP_REPLACE,REGEXP_COUNT). Thanks

What us \w in regexp_substr

Thanks Siva for the new concept explanation...

Hello sir... Thank you so much for sharing your knowledge. Could you please make a video on one query with multiple(3 or 4) inline views and each inline with 3 or 4 joins. Thank you..🙏

Superb , Great , extraordinary, incredible

Is there any website of yours

Your way of explanation is very good thanks for sharing the videos and please post the videos regarding performance tuning also atleast one video for a week... thanks

Very Nice explanation Sir thank you so much so ..please make a video on Reg_expresions concept sir..

Thank you.. Very helpful

Hello sir could you please explain pragma inline with examples

Super Siva . Beautiful explanations of DB concepts

Sir, you are doing really great job hats off to you ❤️❤️

Excellent siva

we use inline view in select part in some place, from part in some place, what the difference and how to know which place we use inline view

Thank you Siva.. Great explanation 👍👍

Thank you Siva! As usual the best!

Wonderful explanation! Thank you

Nice explanation.. Thank you

Greate job, thanks a lot!

Very helpful video sir

Thank you siva

Thank you

Thanks

great 👍

Siva, Can you explain the difference between Correlated subquery and Lateral Inline view. Because in correlated subquery, we sometimes use different table in where condition. eg Select dept_num from dept _table where not exists ( select query from emp_table where emp_dept = dept_table.depXX)