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

0 Answers  

---

What is the difference between view and stored procedure?

0 Answers  

---

What is natural join in sql?

0 Answers  

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---

..........refers to the disk mirroring

2 Answers   iFlex,

---

Explain how can you save or place your msg in a table?

0 Answers  

---

How to install oracle sql developer?

0 Answers  

---

1 SELECT a.field1, b.field2, c.field3, d.field4 2 FROM atable a, atable b, ctable c, dtable d 3 ? 4 ORDER BY 1 What is the minimum number of joins that must be specified on line 3 in the sample code above to properly link the tables? Notice that the table "atable" is aliased twice: once as "a" and once as "b." 1. One join 2. Two joins 3. Three joins 4. Four joins 5. Five joins

6 Answers   Sonata,

---

What is constant in pl sql?

0 Answers  

---

What is file based approach?

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,

---

Difference between truncate, delete and drop commands?

0 Answers  

---