Answer Posted / ajit nayak

update emp
set sal = case Deptno when 10 then 1000
when 20 then 2000
when 30 then 3000
else 0
end;

What is sp_helptext?

1007

---

explain access control lists. : Sql dba

949

---

What is the difference between cross join and natural join?

965

---

What is group function in sql?

968

---

Is inner join faster than left join?

1125

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2230

---

What is multiple columns?

1004

---

How much does a sql dba make? : SQL DBA

891

---

What is scope of pl sql developer in future?

952

---

Is sql dba a good career? : SQL DBA

944

---

How delete all data from table in sql?

951

---

How do you add a column to a table?

999

---

What is the largest value that can be stored in a byte data field?

960

---

What is database white box testing and black box testing?

1050

---

What are analytical functions in sql?

972

---