![]() ![]() ![]() INCREMENT BY: step value by which a sequence is incremented. MAXVALUE: A maximum value for a sequence. MINVALUE: A minimum value for a sequence to start with. START WITH: The reference value, with which the sequence starts. (SMALLINT, BIGINT, INTEGER, NUMBER, DOUBLE) The following parameters are used for sequences:ĭata type: This is the data type of the returned incremented value. PREVIOUS VALUE: It returns recently generated value. ![]() NEXTVAL: It returns an incremented value for a sequence number. There are two type of sequences available: A sequence is incremented or decremented irrespective of transactions.Ī sequence is created by CREATE SEQUENCE statement. A sequence can be shared among multiple applications. A sequence can support SMALLINT, BIGINT, INTEGER, and DECIMAL data types. You use sequence for availing integer numbers say, for employee_id or transaction_id. IntroductionĪ sequence is a software function that generates integer numbers in either ascending or descending order, within a definite range, to generate primary key and coordinate other keys among the table. This chapter introduces you to the concept of sequence, creation of sequence, viewing the sequence, and dropping them. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |