Working with Sequences in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar

Working with Sequences in SQL | Oracle SQL Tutorial Videos | Mr.Vijay Kumar
** For Online Training Registration: goo.gl/r6kJbB ► Call: [phone]
💡 Visit Our Website for Classroom Training:
nareshit.in/or...
💡 For Online Training:
nareshit.com/o...
#Oracle #Training #CourseVideos
--------------------------
💡 About NareshIT:
"Naresh IT is having 14+ years of experience in software training industry and the best Software Training Institute for online training, classroom training, weekend training, corporate training of Hadoop, Salesforce, AWS, DevOps, Spark, Data Science, Python, Tableau, RPA , Java, C#.NET, ASP.NET, Oracle, Testing Tools, Silver light, Linq, SQL Server, Selenium, Android, iPhone, C Language, C++, PHP and Digital Marketing in USA, Hyderabad, Chennai and Vijayawada, Bangalore India which provides online training across all the locations
--------------------------
💡 Our Online Training Features:
🎈 Training with Real-Time Experts
🎈 Industry Specific Scenario’s
🎈 Flexible Timings
🎈 Soft Copy of Material
🎈 Share Videos of each and every session.
--------------------------
💡 Please write back to us at
📧 [e-mail]/ 📧 [e-mail] or Call us at the USA: ☎[phone] or India: ☎ [phone]
--------------------------
💡 Check The Below Links
► For Course Reg: goo.gl/r6kJbB
► Subscribe to Our Channel: goo.gl/q9ozyG
► Circle us on G+: plus.google.co...
► Like us on Facebook: / nareshit
► Follow us on Twitter: / nareshitek
► Follow us on Linkedin: goo.gl/CRBZ5F
► Follow us on Instagram: goo.gl/3UXYK3

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@deepdeshmukh9339]

very very well describe sir....YOUR TEACHING MAKE A GOOD VAULES IN STUDENTS HEART.

[@riteshbholenath9913]

Nice explanation🎉

[@dhruvmittal2669]

Excellent job.. Thank u so much for your videos..

[@aakashdubey9653]

Very nice explanation Sir, thank you so mch

[@purnapalli]

Good explanation.but here i have one doubt. As you told we should use sequence on primary key column. But when we use cycle option on primary key value column, then the values shouldn't be insert into the primary key column since duplicate values generated(Repeated values generated)

[@Jatin55577]

Purna Palli I have also same question. Did you find the answer?

[@rahulthorat7575]

Meaning of his statement is if you create a sequence on column then it works like unique primary key column. U can't insert duplicate record in primary key column. See the table structure of student table... He has not mentioned any primary key for SNO column. So u can definitely insert duplicate record from sequence as well. But if u make SNO as primary key then you can't insert duplicate record by sequence or anything. Hope your query fulfilled. ☺

[@aakashdahiya7952]

he did not declare the column to be a primary key, therefor duplicate values got inserted.

[@koteswararaogorantla6479]

Very good explanation

[@dhanasingitham8138]

Thank you sir ,it's helpful.

[@bindhusadham6722]

Good explanation sir

[@saibabac7431]

Sequence is used to generate primary key values right ? And primary key should not allow duplicate values right but why values are repeating ,is that make sence ? Yes I got it but because of cycle values are repeating,but as per the sentence of primary key ,should not allow duplicate values ,could you please answer any one to this question ....Thank you

[@bsudharsanreddy9135]

Hi Sir.. Thanks for ur explanation.. Can we have cache without cycle

[@gimnathperera5556]

Very Helpful!

[@nipun384]

very nice loved it :)

[@dumpling6440]

if we are not using maxvalue, then how much will be the cache size?

[@govindugovindu617]

Nomax value (10^27)

[@farheensultana5818]

Brilliant video sir

[@zeeshankhan-tp8ls]

sir plz share vedio on oracle query execution plan

[@surabhikolekar8632]

Helps a lot to me

[@andremachadomonte]

Very good lecture!!!

[@mustafavaghjipurwala2365]

How can I user nxt value based on 2 paramiter for example it should be between 5 and 50

[@smani08]

can you pls explain me performance tuning

[@vignesharies5526]

if we use cycle then how came we use the sequence for primary column ??? primary column must be unique

[@md.mizanurrahaman6282]

Please help me. I can n`t create sequence this method "YYMMDD00000" Example : 18121300001 year/ month/day then ID number

[@AshishKumar-ys5gr]

SEQUENCE ONLY INTEGER VALUES GENERTED

[@arpitparopate7313]

why you use the max and min of the screen it's not readable

[@prempaltyagi8838]

Dataware house concert create video.

[@bharathiganneboyina3724]

very good explanation sir