Answer Posted / manojbatra071

create table backuptablename as select * from originaltablename;

How do I trace sql profiler?

491

---

What is set serveroutput on?

642

---

What company owns postgresql?

561

---

What is the advantage of index in sql?

541

---

How does index help in query performance?

565

---

---

Can we use loop in sql?

537

---

What are expressions?

563

---

What is error ora-01000: maximum open cursors exceeded

604

---

What is a stored procedure in sql with example?

606

---

Can we update views in sql?

535

---

What are basic techniques of indexing?

846

---

How does sql developer connect to oracle database?

524

---

What are some emotional triggers?

570

---

Explain the advantages and disadvantages of stored procedure?

649

---

Does mysql support pl sql?

624

---