How to View Oracle Sequences

1 year ago
Ava Mitchell
1 minute

You can use the following SQL statement in Oracle database to view the sequences in the database.

SELECT sequence_name
FROM user_sequences;

This query will return the names of all sequences under the current user. If you want to view sequences for all users, you can use the following SQL statement:

SELECT sequence_name
FROM all_sequences;

If you want to view information about all sequences in the database, you can use the following SQL statement:

SELECT sequence_name, min_value, max_value, increment_by, last_number
FROM user_sequences;

The above query will return the names, minimum values, maximum values, increment step, and current values of all sequences under the current user.

bannerAds