Answer Posted / saty

select sequencename.currval from dual

select sequencename.nextval from dual



if we will give only table name thr will be error


Thanks & regards
satya
+919916174212

What is data abstraction in sql?

515

---

what is an extent ? : Sql dba

584

---

What is materialized view in sql?

469

---

what are all the common sql function? : Sql dba

587

---

What is a table?

569

---

---

What are the ways on commenting in a pl/sql code?

515

---

How to rename a table?

558

---

What is a sql*loader control file?

622

---

how to fetch common records from two tables? : Sql dba

633

---

Explain commit, rollback and savepoint.

610

---

Is sql scripting language?

528

---

What is trigger in pl sql with examples?

525

---

How can we optimize a sql query?

580

---

Explain the purpose of %type and %rowtype data types with the example?

558

---

What is a trigger in sql?

642

---