Answer Posted / suma

select distinct(emp_name) from employees;

Why is theta join required?

1188

---

What are the 3 types of behavioral triggers?

1311

---

How to revise and re-run the last sql command?

1214

---

How we can update the view?

1096

---

What is the purpose of the sql select top clause?

1201

---

What is pl sql and why it is used for?

1155

---

Can pl sql procedure have a return statement?

1070

---

What is multiple partition?

1018

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1056

---

What is the use of stored procedures?

1103

---

What is materialized view in sql?

957

---

What is output spooling in sql*plus?

1088

---

Is not equal in sql?

1061

---

In pl/sql, what is bulk binding, and when/how would it help performance?

1030

---

Explain locks? : Transact sql

1050

---