SEQUENCE with examples | Oracle SQL tutorial in TAMIL

[@soniyashashikanth2974]

Nicely explained.. thanks.. will suggest

[@learncodetodaytamil]

Thank you!!!

[@Rajendrakumar-ie1xw]

Super teaching 😍😍😍 dhripthi aa iruku.. I'm going to follow this channel for all SQL and plsql syllabus

[@learncodetodaytamil]

Thank you.

[@ivanesm1984]

Very useful bro

[@Aswath-uf2dy]

Excellent bro thank you so much

[@learncodetodaytamil]

Thanks bro...

[@ganeshv2123]

Thank sir for clear explanation about sequence.. I have once query - Does it required to give max values in sequence? Is there any option where i can give unlimited values for the tables having millions of records?

[@learncodetodaytamil]

Maxvalue is optional. If u want to limit the values to a certain value, use maxvalue. otherwise leave it. For ur case ommit the maxvalue in sequence

[@ganeshv2123]

@@learncodetodaytamil Thanks for your prompt response

[@kaththikarthi878]

Super sir...

[@learncodetodaytamil]

Thank u !!

[@barakathnoohu6409]

Thank u sooooo much

[@learncodetodaytamil]

Most welcome 😊

[@harinipunniakotti2181]

Bcz of u only i have learned sql sir. Sir will u plz take excel from beginning level To excellent level plz sir.

[@learncodetodaytamil]

This channel is for learning Oracle technology.... but ,will try to cover....

[@Akashsteve-js4eo]

bro mysql video poodunga

[@learncodetodaytamil]

Bro all concepts are same... Try to learn concepts.

[@tejakj6933]

I need your all PPT bro

[@sudheek-xy6nu]

How to check available sequence in db?

[@learncodetodaytamil]

U can use user_sequences or all_sequences

[@santhoshs5850]

Do I need to mention "seq.nextval" (e.g for id column)each time while we insert the record? For example I'm going to insert 10 record, So do I need to mention seq.nextaval in each of the insert query? (or) One time is enough for the first record then it will generate automatically for the next records?

[@learncodetodaytamil]

For each time we have to mention... If not create a dml trigger for that table. Inside that u can mention the sequence... This way u don't need to mention each time while inserting the record...

[@mohammedimthiyas9001]

synonym topic pls

[@jagubarjagubar462]

Prgm a order a sollunga

[@pksivaguru]

you said its not possible to change start value, then how we can change minimum value?

[@learncodetodaytamil]

To change min value Alter sequence sequence_name Minvalue 2 .... ..... ; Note: once u have altered the min value it is used for next cycle only.

[@AjithKumar-fu6rg]

❤️‍🩹✨

[@princy_raj]

Anna Oracle interview face pana neenga soli kudutha videos eh podhuma

[@learncodetodaytamil]

Yes it's enough...👍

[@jagubarjagubar462]

Ithoda order crt a

[@manandan9853]

bro.. ORDER|NOORDER BRO? EXPLANATION BRO?

[@learncodetodaytamil]

Order means it will provide values in order(eg.1,2,3,4,5) Noorder means it will provide random value or random order (eg. 1,5,3,4,2)

[@manandan9853]

ok bro@@learncodetodaytamil