Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sequence is generating random numbers

Vinod RathodApr 6 2018 — edited Apr 7 2018

Hi ,

We have Two instances UAT and PRODUCTION.

We have created sequence in both instances , but  in Production it is  generating random numbers and we have used same script for both instances.

The Script for Sequence is :

CREATE SEQUENCE APPS.XXBOB_HR_WHISTLEBLOWER_SEQ

  START WITH 101

  INCREMENT BY 1

  MAXVALUE 99999999999999999999999

  MINVALUE 100

  NOCYCLE

  CACHE 20

  NOORDER;

Regards,

Subhan BK.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 5 2018
Added on Apr 6 2018
#sql-pl-sql
22 comments
5,413 views