[ASK]-在Oracle中将自动增量重置为ID [英] [ASK] - Reset Auto Incremental as ID in oracle

问题描述

您好，专家，:)
你想帮助我吗?我想在oracle中重设id(自动增量)，但我不知道该怎么做..我试图找到解决方案，但我没有找到.. :(
请高手帮帮我... :(谢谢.

Hi experts, :)
Would u like to help me ? I wanna reset id (auto incremental) in oracle, but i don''t know how to do that.. i''ve tried to find the solution, but i''ve not found that.. :(
Help me please experts... :( Thank you.

推荐答案

我记得在Oracle中没有auto_increment.它是通过序列完成的，所以您需要查找序列并进行更新.如果不可能，则删除并重新创建.

As soon as I remember there is no auto_increment in Oracle. It is done through sequences. So you need to find sequence and update it. If it is not possible then drop and recreate.

这篇关于[ASK]-在Oracle中将自动增量重置为ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！