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

Hi.

On a table in my current project and the max value is reached and while inserting the data it is giving error and iam new to that project and I dont know which procedure is inserting the data in that table coloum.

Now my question is how to identify the sequence name for the table name.

Is there any thing like all_sequence,user and dba_sequences etc

Hi manish, please make a vedio on SQL loader. How to use SQL loader in plsql.

you are a legend, manish

I love how you say wasupp inernet:)

Is it possible to reset sequence????

Is it possible to use one sequence for more tables???

When you delete a row contain sequence , the object sequence is not rearranged with sequential order.

It is a hole in the object.

Can we generate character sequence?

How to reset sequence as to star always with 1 in a session

Thanks for making to the point videos and without being slow. Great job

Your explanation is so clear. Great!!!

So I have read that a schema in oracle is a collection of database objects and it is owned by a DB user, does this mean that sequences are associated to only one schema and one user?

thanks a lot Sir, You made it too easy

Manish! can we use decrement keyword instead of increment keyword?

Thanks a lot for the tutorial, Manish. You explained everything very clear! 5/5!

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

Hi
Manish great tutorial and in clear format!

Very helpful content in small time Thanx buddy 🙏😊

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

hi manish,
can we generate characters into a sequence like
OA 12345
PW 12345
is this possible with sequence concept ?