Oracle SQL Practical question | Oracle SQL to Find missing number in given range of values

Oracle SQL Practical question | Oracle SQL to Find missing number in given range of values
--------------------------------------------------------------
This channel is for learning 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 12+ 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

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

[mayukhdhar]

Thankyou as always for your videos, it’s has helped us to crack many interviews honestly

[Ins_]

All your videos are GEMS...💎.. No better channel than yours, truly speaking and thanks for posting all your content. We loved it...Keep going....

[theboss]

Love to see you are back...keep doing bro.

[sujaa]

Thank you very much Siva, I keep learning a lot from your teachings, and this is the channel I recommend for learners.
Siva, could you consider making some videos for expert level only, with some real scenarios, as we may not come across all complex scenarios even in years of development.
Thanks again and I really appreciate you sharing such a wealth of knowledge and the effort you put in to graphically explain the concepts.

[ravibathula]

You have done lot of contribution in teaching plsql sir please arrange one live session we want to know more about you teach us also etl and other databases like sqlserver sir

[kokilavelu]

Hi Siva, today I have been asked the following interview question and please give me answer for this
"Usage of while loop to calculate the average of users entered numbers and entry of more numbers are stopped by entering zero"

[bhushanpalse]

Sir for python learning base to top which youtube channel should follow, which teach like you

[aruvamadhu]

Thank you so much sir,
Sir is it possible with connect by class, if say yes please post that method also ... thanks

[javeed]

HI SIVA thx for the explaination, can you please add datasets as well

[sakshinaik]

Happy to see your videos welcome back sir plz upload videos regularly

[more]

really helpful...nice explanation....thanks for sharing your knowledge.

[sujaa]

Hi Siva, Thank you very much, I am learning a lot from your teachings.
1. I see in some of the queries when you give datatype NUMBER, you do not specify the size, does it default to some size?
2. In a database I was working, even after I created varchar2 datatype, it was storing in bytes, can you please explain that?
3. Could you please make a video for SGA and PGA, and the full cycle of a package getting loaded to memory from its initial call, the variables and how other users can access the same pkg and its session variables.
4. I searched for Explain Plan and Execution Plan in your playlists, I could not find, can you please cover those topics as well.
Thanks again for sharing such a wealth of knowledge.
Regards.

[krishnanselvam]

hi sir, please post video three level type of hints in oracle with post video you sp muchu please tech slowly and step by step sir.all videos very nice again thank post videos real time projects videos.

[satyanarayanabadam]

Hi Siva, Your videos are good and got the good knowledge while preparing interviews. I had an interview recently. I sent an email the questions. Can you please make video for those questions. Others also will get an idea.
Thanks

[Ram-tfir]

This was a great learning!! KEEP UP THE GOOD WORK 🎉👍🏻

[badboy]

Hi Siva,
Is this possible to get the same result without using lateral join? Because still, we are using only the oracle 11g version

[Wilq]

We could as well use Insersect commant here or use for loop (but that would be pl/sql not pure sql)

[eie]

Thank you for your valuable videos.I am a regular follower of your channel. Here I stuck with one problem.please help me out.
Query: How to find month wise new customer. Customer table has 3 columns.Customerid, custname, customer_visited_date.
If A visited MAY month then A is new customer.but if A revisited in june then A is not new customer
What is the query approach

[pankajperane]

Is there any table or view in Oracle where can capture the information of DDL and DML changes? If not then how can we get those information.

[dasubabuch]

Siva sir, will utl_file package works on Oracle express edition? Because am trying to do some practice on utl_file package. I tried with both Oracle 11g and 21c . Can you please reply me?