Explain the update statement in sql

0 Answers  

---

Can a commit statement be executed as part of a trigger?

0 Answers  

---

Explain foreign key in sql?

0 Answers  

---

How many unique keys can a table have?

0 Answers  

---

how mysql optimizes distinct? : Sql dba

0 Answers  

---

What is delete command in sql?

0 Answers  

---

Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,

---

Can we use having without group by in sql?

0 Answers  

---

What is the source code of a program?

0 Answers  

---

Why do we use procedures?

0 Answers  

---

How to export the table data (this table having 18 million records) to .csv file. Please tell me is there any faster way to export the data.

8 Answers  

---

what are the authentication modes in sql server? : Sql dba

0 Answers  

---