Oracle SQL Practical question with answer | Sort the NUMBERS in the comma separated list

[@adeokatepatil897]

Hi Siva, its again your hearted fan. I am here because of the way you explained all types of indexes in one of your video. What a way you explained .. its magic only. before that i want index is the most difficult topic in plsql. but after your video its nothing and got placed and of course its by index only, because they asked me on only index contentiously for 20 mins. i recommend to all other plz go through siva's index topic, the way he explained . its miracle .. thanks thanks...

[@SivaAcademy]

@ACHYUT, it's my pleasure, all the best, and thanks for your comments bro 🙏

[@bharathibalakrishnan6521]

Agree with you. After watching Siva’s index video I felt like , that’s it. Index is so easy....

[@SivaAcademy]

My pleasure 🙏💐

[@nirmalasai9937]

sir meeru chala baga explain chesthunnaru every concept just fall for your teaching....😊

[@SivaAcademy]

Thank you

[@nikhilsinghrajput920]

Awesome sir.... In whole KZbin urs videos are awesome for learning sql🙏🙏🙏

[@SivaAcademy]

Its my pleasure, thanks a lot for your comments 🙏💐💐

[@MsAmma1]

Thank you. You are awesome teacher

[@SivaAcademy]

You are welcome!

[@sivakumar-wq9lx]

Your videos are very informative. I really like the explanation too..

[@SivaAcademy]

Thank you 🙏

[@RahulKumar-hp6bv]

Sir, your explanation is awesome. Sir, if you don''t mind can you upload videos on regular expressions and with clause which will be much helpful to students.

[@SivaAcademy]

Sure, please stay tuned

[@abhinavsrivastava5881]

Thanks a lot bro...please cover regular expression in a comprehensive way in a separate video as well.

[@SivaAcademy]

Sure bro

[@atulyasahay4277]

Please do it

[@SivaAcademy]

👍 sure

[@manochoco23]

Sir , please help me understand why we use + next to bracket in reg exp ? I queried with and without + but am unable to understand what's actually happening

[@bashask2121]

In oracle 18 or 19 version within group is optional, in that case how will you convert i mean without to_number function

[@sanjeetsingh17]

Superb explanation 👌 of how to organise random numbers in plsql.. it's so so beautifully explained and concepts got clear.. thanks a ton Siva

[@SivaAcademy]

@sanjeet, thanks for your comments bro 🙏🙏🙏🙏🙏🙏

[@sujaa1000]

This was very helpful, also if you could explain Regular Expression in detail it would be extremely helpful. thank you Siva. Regards, Sujaa

[@SivaAcademy]

sure, will try my level best to post soon, please stay tuned

[@SHUBHAMKUMAR-yp3ge]

I too have a same request sir. Please have a video on Regular Expression

[@parikshelke3342]

Thanks

[@SivaAcademy]

Welcome bro

[@gautam26trivedi]

Awesome sir

[@SivaAcademy]

🙏 Thank you :-)

[@gautam26trivedi]

Please provide us video on regular expression

[@SivaAcademy]

@Gautam, sure, will post regular expression topic

[@muthukumar-wm6qg]

Sir pls post about regular expression

[@SivaAcademy]

Sure, please stay tuned

[@ishaan12vlog]

Thanks to come in Utube and share it.

[@SivaAcademy]

Welcome 🙏

[@ilakyasri4526]

Hi Sir, thanks for the video..what is the use of with clause?

[@SivaAcademy]

@ilakya sri, .using with clause you can compute some temp values, and use can use it multiple places in your sql..it will act like a temporary table holding the result of your with clause query...will post a small video soon about the usages of with clause...please stay tuned.

[@karkiashwin1174]

sir what is the use of level actually?

[@SivaAcademy]

@karki, you can use either level or rownum, intention is to get sequence number

[@avinashjha1784]

How can we delete millions records from a table having billions record?

[@aselzhumalieva7041]

What if there is no space and coma?

[@ramnagireddy4261]

Can you please explain connect by nd level

[@SivaAcademy]

@ram, sure I will post a video on hierarchical queries

[@vishwas22khare]

Sir pleaSe also add real time application , scenario of these ,for remembering longer time .

[@SivaAcademy]

Sure, I will add for upcoming videos

[@vishwas22khare]

@@SivaAcademy Thanks 🙏

[@samikshabhatnagar3191]

Pls make vedio on each join and set operator and with null example

[@SivaAcademy]

@samiksha, already video posted on set operator and null, will post on join related topic soon, please stay tuned

[@joshianurag6211]

ORA-01788: CONNECT BY clause required in this query block 01788. 00000 - "CONNECT BY clause required in this query block" *Cause: *Action:. I am getting this error Can you please help me to resolve this error

[@swamivivekananda-cyclonicm8781]

Nice > cein

[@SivaAcademy]

Welcome bro