What is cursor and why it is required?

0 Answers  

---

What is Raise_application_error ?

1 Answers  

---

Which clause of an UPDATE statement allows you to affect only certain rows of a table? 1. The WHERE clause 2. The SET clause 3. The ROWS AFFECTED clause 4. The ORDER BY clause

6 Answers   HCL,

---

What are the operators used in select statements?

0 Answers  

---

How do you exit in sql?

0 Answers  

---

What is not null in sql?

0 Answers  

---

what is oracle database ? : Sql dba

0 Answers  

---

when MSQL8.0 is in market

0 Answers  

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

0 Answers  

---

Explain sql data types?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---