The default value is NOCYCLE.ĬACHE: Stores as many serials as the number specified by “cached_num” in the cache to improve the performance of the serials and fetches a serial value when one is requested. NOCYCLE: Specifies that the serial will not be generated anymore after reaching the maximum or minimum value. When a serial in ascending order reaches the maximum value, the minimum value is created as the next value when a serial in descending order reaches the minimum value, the maximum value is created as the next value. NOMAXVALUE: 10,000,000,000,000,000,000,000,000,000,000,000,000(10^37) is set automatically as a maximum value for the ascending serial, -1 for the descending serial.ĬYCLE: Specifies that the serial will be generated continuously after reaching the maximum or minimum value. MAXVALUE must be greater than or equal to the initial value and greater than the minimum value. MAXVALUE: Specifies the maximum number of the serial. MINVALUE must be smaller than or equal to the initial value and smaller than the maximum value. MINVALUE: Specifies the minimum value of the serial. If a negative number is specified, the serial is in descending order otherwise, it is in ascending order. The absolute value of the interval must be smaller than the difference between MAXVALUE and MINVALUE. INCREMENT BY interval: Specifies the increment of the serial. The default value of ascending serial is 1 and that of descending serial is -1. START WITH initial: Specifies the initial value of serial. Serial_identifier: specifies the name of the serial to be generated(maximum: 254 bytes).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |