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 do you tune the slow running queries in oracle db , explain the methodology

2831

---

What packages(if any) has oracle provided for use by developers?

5817

---

Advantages and disadvantages of stored procedure?

1126

---

How you improve the performance of sql*loader? : aql loader

1020

---

What is input buffer in sql*plus?

1234

---

How does stored procedure reduce network traffic?

1016

---

what are dynamic queries in t-sql? : Transact sql

1032

---

What is the difference between function and procedure in pl/sql?

1098

---

Can pl sql procedure have a return statement?

1035

---

Can we use the cursor's to create the collection in PL/SQL?

1035

---

Can delete statement be rollbacked?

992

---

what are all the different normalizations? : Sql dba

1054

---

Is vs as in pl sql?

995

---

What are the string functions in sql?

987

---

What schema means?

893

---