SELECT *
FROM user_sequences
WHERE sequence_name = '<sequence_name>';
SELECT last_number
FROM user_sequences
WHERE sequence_name = '<sequence_name>';
SELECT last_number
FROM all_sequences
WHERE sequence_owner = '<sequence owner>'
AND sequence_name = '<sequence_name>';
Code Example |
---|
Sql :: greater than or equal to symbol in postgres |
Sql :: oracle synonym procedure |
Sql :: mysql uuid |
Sql :: mysql delete duplicate rows except one |
Sql :: insert or update cassandra |
Sql :: postgresql like |
Sql :: oracle convert hours to minutes |
Sql :: in sql |
Sql :: Truncate a table then insert data |
Sql :: mariadb used space |
Sql :: merge command in sql |
Sql :: mysql create table |
Sql :: learn sql |
Sql :: insert ip address in mysql |
Sql :: select top values sql |
Sql :: insert data to postgresql from excel |
Sql :: mysql copy data from one table to another |
Sql :: initcap in mysql |
Sql :: postgresql connect |
Sql :: sql xor |
Sql :: cannot connect to mysql server 10060 |
Sql :: character count sql |
Sql :: SQL JOIN and Aliases |
Sql :: auto increment psql not primary key |
Sql :: stuff in sql |
Sql :: plpgsql |
Sql :: mysql view |
Sql :: insert update sql server |
Sql :: query to generate query to drop primary keys or foreign key in ms sql server |
Sql :: Insert into Select * - NAYCode.com |