- 1). Open your Oracle Enterprise Manager software in the Windows program menu and log in to your database server. Open the PL-SQL editor in the management console.
- 2). Create the alter PL-SQL code. The following code shows you how to alter a sequence's increment number:
alter sequence mysequence INCREMENT BY 5;
This code edits the sequence "mysequence" and changes the increment number to 5. - 3). Click the "Run" button to execute the alter statement. The changes take effect immediately, and the Enterprise software replies with a success message.
SHARE
