I have a table called student with ID and NAME as the column name whereas i have
made ID as sequence which will generate auto number 1..2..and so on when any new record will be inserted.
But the senario is that when i want delete the record or truncate the table
i want that the when i will re insert the table with values then the ID column should start
from begining i.e. 1..2..3...and so on instead of starting from last sequence number.
Could you please anyone can help out and provided the tried and tested solution.