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

How do you create a db file?

529

---

What is the difference between row level and statement level trigger?

530

---

What is an inconsistent dependency?

587

---

How do you rank data in sql?

527

---

Is sql low level language?

585

---

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

3218

---

Is sql harder than python?

619

---

What types of commands can be executed in sql*plus?

558

---

What is prepared statement in sql?

561

---

What is cte?

586

---

What is query execution plan in sql?

575

---

What is database migration?

523

---

What is a unique constraint?

616

---

What is the purpose of the partition table?

556

---

What are the two types of periodical indexes?

515

---