Answer / anithaletchumi

select t1.name,case when abs(t1.val-t2.val) > 5 then 5 *
abs(t1.val - t2.val) else 5 end diff from tab1 t1 join tab2 t2
on t1.name=t2.name where t1.val != t2.val

How to check if a column is nullable before setting to nullable?

0 Answers  

---

how to find 5th row ?

10 Answers  

---

How to write a procedure for displying the data in a TREE or (PARENT and CHILD ) relationship , for ex: A is the main project id, for this project B,C,D are sub tasks(sub project id's) for B the sub tasks are e,f,g and for c is h ,i ,j and for d is k,l,m now i need to display the o/p in a TREE fashion pls help me , thanks in advance surendra

2 Answers   Zensar,

---

Which is faster truncate or drop?

0 Answers  

---

What are the different types of database management systems?

0 Answers  

---

declare l1 number := null; l2 number :=null; begin if l1=l2 then message('equal'); else if l1<>l2 then message('not equal'); else message('else'); end if; end if; end; What will be the output ?

7 Answers   Oracle,

---

What sql does db2 use?

0 Answers  

---

Is oracel sql developer written in java?

0 Answers  

---

What is the difference between alter trigger and drop trigger statements?

0 Answers  

---

In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,

---

What is a database trigger?

0 Answers  

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---