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

Which is faster union or join?

981

---

What does the acronym acid stand for in database management?

1045

---

Which is faster view or stored procedure?

951

---

How can you load microsoft excel data into oracle? : aql loader

1185

---

Define select, insert, create, delete, update, drop keywords

1057

---

What is difference between sql and oracle?

1142

---

Is it possible for a table to have more than one foreign key?

1040

---

What is the use of primary key?

1018

---

Can we write ddl statements in functions?

1127

---

What is offset in sql query?

1132

---

Define the select into statement.

1069

---

What does an inner join do?

1196

---

What is primary key and foreign key?

970

---

How do I run pl sql in sql developer?

1127

---

How would you reference column values before and after you have inserted and deleted triggers?

1072

---