Answer Posted / sweta

select sequencename.currval,sequencename.nextval from dual;

Can you sum a count in sql?

564

---

How to write html code in pl sql?

584

---

what is the difference between group by and order by in sql? : Sql dba

600

---

What is offset and limit in sql?

555

---

Explain two easy sql optimizations.

605

---

---

How do I add a primary key to a table?

546

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3115

---

What does joining a thread mean?

550

---

Do prepared statements prevent sql injection?

532

---

How do I make sql search faster?

560

---

What is package in pl sql with an examples?

551

---

how to fetch alternate records from a table? : Sql dba

606

---

What is the most restrictive isolation level? : Transact sql

563

---

Is null operator in sql?

610

---

what is the stuff function and how does it differ from the replace function? : Sql dba

625

---