New records for Oracle sequence Loops

Share a little bit of experience:

Seq_bos_t_priv_function is a sequence, and colnum1 is the primary key.
Insert into Table1 (colnum1, colnum2) values ('select seq_bos_t_priv_function.nextval from dual', '1 ');
Insert into Table1 (colnum1, colnum2) values ('select seq_bos_t_priv_function.nextval from dual', '1 ');
You can add records cyclically in the database without the need of a program!

Sequence Import and Export

1. Run the following SQL statement: sequence_owner = 'database login username ';

Select 'create sequence username. '| sequence_name | 'minvalue' |
Min_value | 'maxvalue' | max_value | 'start with' |
Last_number | 'crement by '| increment_by | 'cache' |
Cache_size | ';'
From dba_sequences
Where sequence_owner = 'drug ';

2. After execution, all sequences of the corresponding users are identified.

3. Don't talk about it. Just execute SQL directly.