What is the difference between cluster and non-cluster index?

0 Answers  

---

What is the usage of nvl function?

0 Answers  

---

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

What are wait events. Describe the wait event tables.

1 Answers   CTS,

---

Can pl sql procedure have a return statement?

0 Answers  

---

4. Select sum(A.salary) +sum(B.salary) as TOT_SAL from ( select LEVEL emp_id,level*100 salary,case when mod (level,2)=0then 2 else null end dept_id from dual connect by level<6 )A right outer join (select level emp_id ,level*200 salary ,case when mod (level,3)=0 then 2 else null end dept_id from dual connect by level<6)B On A.dept_id=B.dept_id And A.emp_id=B.emp-id;

1 Answers   Fintellix,

---

What is the difference between a query and a report?

0 Answers  

---

What is the use of sql trace?

0 Answers  

---

How can you get sql*loader to commit only at the end of the load file? : aql loader

0 Answers  

---

What is foreign key in sql with example?

0 Answers  

---

Why use truncate instead of delete?

0 Answers  

---