Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE table_name (seq_no, name, place) AS
SELECT 1, CAST('Rian' AS VARCHAR2(20)),  CAST('Us' AS VARCHAR2(20)) FROM DUAL UNION ALL
SELECT 1, 'Moli',   'Us' FROM DUAL UNION ALL
SELECT 1, 'Molina', 'Us' FROM DUAL;
3 rows affected

CREATE SEQUENCE your_sequence;
UPDATE table_name
SET seq_no = your_sequence.NEXTVAL;
3 rows affected

SELECT * FROM table_name;


SEQ_NO
NAME
PLACE


1
Rian
Us

2
Moli
Us

3
Molina
Us


INSERT INTO table_name (seq_no, name, place)
VALUES (your_sequence.NEXTVAL, 'New Name', 'New Place');
1 rows affected

SELECT * FROM table_name;


SEQ_NO
NAME
PLACE


1
Rian
Us

2
Moli
Us

3
Molina
Us

4
New Name
New Place