Answer Posted / shai

select *
from user_sequences;

The last_number column will display the number available
next.
if no_cache is used in sequence definition then you can
trust on last_number column from user_sequence.
But if cache is used then below will take place:

If Cache is 20 then last_number will display any number
within range of sequence currval+20

How is a PL/SQL code compiled?

1170

---

How do I view a view in sql?

889

---

what is bcp? When is it used?

1046

---

What is nosql example?

968

---

How do you use collections in procedure to return the resultset?

2180

---

What are operators available in sql?

978

---

How to create your own reports in sql developer?

972

---

what is a foreign key ? : Sql dba

1026

---

What is case function?

987

---

which tcp/ip port does sql server run on? : Sql dba

964

---

How long will it take to learn pl sql?

889

---

What found sql?

894

---

What are sql*plus environment variables?

1030

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1129

---

What is the difference between the conventional and direct path loads? : aql loader

1315

---