Answer Posted / k v koteswara rao

UPDATE employees SET salary=DECODE(department_id,10,salary+1000,20,salary+2000,30, salary+3000,salary);

Can we call procedure in select statement?

732

---

Does view store data in sql?

702

---

what is error ora-03113: end-of-file on communication channel?

819

---

What is the difference between view and stored procedure?

691

---

Can we join more than 2 tables in sql?

678

---

---

What does where 1/2 mean in sql?

762

---

what are the 'mysql' command line options? : Sql dba

743

---

What are the advantages of sql?

777

---

What is structural independence and why is it important?

758

---

What is multiple partition?

698

---

Does sql require a server?

711

---

How to call a javascript function from pl sql?

760

---

What is the difference between alter trigger and drop trigger statements?

799

---

what are the system privileges that are required by a schema owner (user) to create a trigger on a table?

811

---

What is embedded sql with example?

753

---