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 the difference between a local and a global temporary table? : Sql dba

1004

---

Why is there a need for sqlcode and sqlerrm variables?

996

---

What is serial sql?

916

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

956

---

How are sql commands classified?

1035

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1072

---

What is the difference between left and left outer join?

892

---

Explain unique key in sql.

943

---

how many tables will create when we create table, what are they? : Sql dba

1019

---

When to use inner join and left join?

903

---

What are procedures used for?

922

---

Does sql full backup truncate logs?

965

---

What type of database is sql?

977

---

how to create a new table by selecting rows from another table in mysql? : Sql dba

1007

---

What are all the different normalization?

977

---