Oracle Apex

Where declare Sequence in Oracle Apex

image 3
Written by shohal

First Create Sequence :

CREATE SEQUENCE schema_name.sequence_name
[INCREMENT BY interval]
[START WITH first_number]
[MAXVALUE max_value | NOMAXVALUE]
[MINVALUE min_value | NOMINVALUE]
[CYCLE | NOCYCLE]
[CACHE cache_size | NOCACHE]
[ORDER | NOORDER];

Create Sequence into Oracle Apex SQL Commands :

image

Find the sequence on Sequence folder:

image 1

Select the specific table column

image 2

Declare the specific table column

image 3

About the author

shohal

Leave a Comment