Why do we use sql constraints? Which constraints we can use while creating database in sql?

0 Answers  

---

Why do we use procedures?

0 Answers  

---

What is number function in sql?

0 Answers  

---

What are the packages in pl sql?

0 Answers  

---

Where can I learn sql for free?

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,

---

Write a unique difference between a function and a stored procedure.

0 Answers  

---

What is the use of a view in sql?

0 Answers  

---

What are predefined functions in sql?

0 Answers  

---

how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

What is the criteria while applying index to any column on any table.

1 Answers   Infogain,

---

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

---