HomeОбразованиеRelated VideosMore From: Manish Sharma

SQL tutorial 61: SEQUENCE in Oracle Database By Manish Sharma RebellionRider

493 ratings | 46816 views
This tutorial is all about Sequence In Oracle Database. In this SQL Tutorial you will learn How to create a sequence How to populate a Primary key column (auto increment in Oracle) using Sequence How to drop a sequence ------------------------------------------------------------------------ ►►►LINKS◄◄◄ Blog : http://bit.ly/sql-sequence-in-oracle-database-rebellionrider-manish-sharma Previous Tutorial ► How To Insert Data into Table using SQL Developer http://youtu.be/YYQCSV6MzTk ► INSERT INTO Command http://youtu.be/uQXgqFtxI_k ► How to copy /Insert data into a table from another table http://youtu.be/m3Ep8tAMqok ------------------------------------------------------------------------- ►►►Help Me In Getting A Job◄◄◄ ►Help Me In Getting A Good Job By Connecting With Me on My LinkedIn and Endorsing My Skills. All My Contact Info is Down Below. You Can Also Refer Me To Your Company Thanks ------------------------------------------------------------------------- Copy Cloud referral link || Use this link to join copy cloud and get 20GB of free storage https://copy.com?r=kb4rc1 -------------------------------------------------------------------------- ►Make sure you SUBSCRIBE and be the 1st one to see my videos! -------------------------------------------------------------------------- Amazon Wishlist: http://bit.ly/wishlist-amazon ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ►►►Find me on Social Media◄◄◄ Follow What I am up to as it happens on https://twitter.com/rebellionrider https://www.facebook.com/imthebhardwaj http://instagram.com/rebellionrider https://plus.google.com/+Rebellionrider http://in.linkedin.com/in/mannbhardwaj/ http://rebellionrider.tumblr.com/ http://www.pinterest.com/rebellionrider/ You can also Email me at for E-mail address please check About section Please please LIKE and SHARE my videos it makes me happy. Thanks for liking, commenting, sharing and watching more of our videos This is Manish from RebellionRider.com ♥ I LOVE ALL MY VIEWERS AND SUBSCRIBERS
Html code for embedding videos on your blog
Text Comments (33)
Sami Khan (1 month ago)
Manish! can we use decrement keyword instead of increment keyword?
Daniel Segura (2 months ago)
Thanks a lot for the tutorial, Manish. You explained everything very clear! 5/5!
Md.Mizanur Rahaman (6 months ago)
Please help me. I can n`t create sequence this method "YYMMDD00000" Example : 18121300001 year/ month/day then ID number
wonder (10 months ago)
Hi Manish great tutorial and in clear format!
Gaurav Dhawale (10 months ago)
Very helpful content in small time Thanx buddy 🙏😊
Adarsh Srivastava (11 months ago)
please sir make a video on synonym object and cover all the basic of private and public synonym eagerly waiting for your response sir Thanks in advance sir
Guguloth Suresh (11 months ago)
hi manish, can we generate characters into a sequence like OA 12345 PW 12345 is this possible with sequence concept ?
pudinaidu chinna (1 year ago)
bro please make a video on synonms concept it will help many like me....?
ICando Allthings (1 year ago)
this is great
Vivek Yoganathan (1 year ago)
bro in select sq_demo.currval from dual; what is dual means?
Manish Sharma (1 year ago)
DUAL is a dummy table which has only one column "DUMMY" and this table comes pre-defined with the software.
Sai Kiran (1 year ago)
Hi Manish, can you clear me something? example: After creating table EMP > inserted 4 rows into EMP table with sequence which has created id's from 1 to 4 now we had truncated the table, so again when we insert the rows into table the sequence is starting from 5 not from 1, can you please let me know how to reset sequence id? and if we delete row 3 which is having emp_ id = 3 how to insert the same id value?
sai krishna (1 year ago)
hai manish sharma , tutorials was very nice ,good presentation on sql developer and easily understand everyone. thank you so much
RR BroaDCasT (2 years ago)
It was very helpful
Pankaj Pal (2 years ago)
how to create sequence with characters+number ex: emp101 in sql
vikash sharma (2 years ago)
HI Manish, I have two schema SSR and VOD and i have SSR table which name is SI_EVENT_SCHED in this table their is a column name SI_EVENT_DATE_TIME. I want this column value in different schema which is VOD and different table which name is SI_VOD_CATCHUP and the column name is same(SI_EVENT_DATE_TIME) so how can i do this can you please help me out from these
Abhishek Saha (2 years ago)
Hi Manish Can you please provide a vedio tutorials on SQL Analytical function?
Seb (2 years ago)
Man you're the best! thanks for these videos, they really help me comprehend things better!
Arshad pervez (2 years ago)
plz sir can you give more info on cache
Arshad pervez (2 years ago)
very nice sir
231doughboy (2 years ago)
Manish I am learning Oracle SQL and your tutorials are one of the best that I find on YouTube. Some other videos aren't very clear but I like how you explain things. Thank you :)
MrVenkatesh25 (2 years ago)
crisp and clear explaination
Fernando Castro (2 years ago)
WHY DON'T U GOOGLE IT?
Alekhya Challa (2 years ago)
hi Manish, can you please provide more information on cache and noorder attributes with few examples in which cases those attributes will be useful.
MrVenkatesh25 (2 years ago)
You are welcome Mr. Manish.
Manish Sharma (2 years ago)
Thank you so much. Your appreciation means a lot to me. Please do make sure to Like, Share and Subscribe. Thanks
Manish Kumar (3 years ago)
Hi Manish, your tutorial is very nice and give brief knowledge. Could you please upload one video for reseting the value of sequence using stored procedure in oralce 11g? I am googling alot but not getting the correct procedure. Thanks, Manish Kumar
Rizwan Ghouri (3 years ago)
Thank you mr.sharma. It was very helpful. You have clear the concept about SEQUENCE in my mind...
jamsheer kutty (3 years ago)
short and simple...nice one
E.Z. Rainbow (3 years ago)
what is "dual"? and we don't know how it increment.
Joshua Dobson (11 months ago)
Dual is basically a dummy table. It's virtual, holds no values, and is just there to fill in for the FROM clause. Without it, the Select statement wouldn't run
Jasser Moreno (3 years ago)
Goodnight, I want to know if you can use the SENTENCES to put SEQUENCE alphanumeric data. As for putting a field like this: MM- 001, MM- 002 , MM - 003 and so on. Thank you very much , greetings from Dominican Republic !!
Jamal ELM (4 years ago)
@ Manish Thanks for your tutorial and the translation which follow with. But could you also create others tutorials in PL/SQL on triggers, Procedures, Packages, etc.. Thanks in advance. 

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.