how to verify sequence result in oracle SQL

Kind Kea answered on November 14, 2021 Popularity 4/10 Helpfulness 3/10

answer how to verify sequence result in oracle SQL

related how to verify sequence result in oracle SQL

Comment

SELECT last_number
  FROM user_sequences
 WHERE sequence_name = '<sequence_name>';

Popularity 4/10 Helpfulness 3/10 Language sql

Tags: oracle sequence sql verify

Link to this answer
Share Copy Link

Contributed on Nov 14 2021

Kind Kea

0 Answers Avg Quality 2/10

Closely Related Answers

Comment

SELECT *
  FROM user_sequences
 WHERE sequence_name = '<sequence_name>';

Popularity 3/10 Helpfulness 3/10 Language sql

Tags: sql oracle verify sequence

Link to this answer
Share Copy Link

Contributed on Nov 14 2021

Kind Kea

0 Answers Avg Quality 2/10

Comment

SELECT last_number
  FROM all_sequences
 WHERE sequence_owner = '<sequence owner>'
   AND sequence_name = '<sequence_name>';

Popularity 3/10 Helpfulness 1/10 Language sql

Tags: oracle verify sequence sql

Link to this answer
Share Copy Link

Contributed on Nov 14 2021

Kind Kea

0 Answers Avg Quality 2/10