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

Explain what is a database?

1079

---

What is multiple columns?

1057

---

define sql update statement ? : Sql dba

1109

---

List and explain the different types of join clauses supported in ansi-standard sql?

1350

---

what are null values? : Sql dba

946

---

How do you copy a table in sql?

1058

---

How many times can we commit in a loop?

1009

---

What are the uses of sysdate and user keywords?

1095

---

What is the difference between null value, zero, and blank space?

1195

---

Is left join same as join?

980

---

List different type of expressions with the example.

931

---

how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1338

---

Which are the different types of indexes in sql?

1053

---

Why truncate is faster than delete?

1101

---

How to start the command-line sql*plus?

1046

---