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

what is a view? : Sql dba

1092

---

Explain what is sql*plus?

1143

---

What are the two characteristics of a primary key?

975

---

How can the performance of a trigger be improved?

1047

---

How does join work in sql?

1012

---

What is the difference between left and left outer join?

944

---

Can we use ddl statements in stored procedure?

1154

---

Can we use rowid as primary key?

989

---

how many ways to get the current time? : Sql dba

1007

---

Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?

1059

---

How many parts of a pl sql block are optional?

1134

---

Can you skip header records while loading? : aql loader

1053

---

What is pl sql record in oracle?

1035

---

Which command is used to call a stored procedure?

1000

---

What is data abstraction in sql?

1031

---