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  

---

What pl/sql package consists of?

0 Answers  

---

one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows only how should u write query?

9 Answers   TCS,

---

Suppose I have to create a view on a table, that is not yet been created by DBA. I khow the table structure. Is it possible to create the view before DBA creates this table? If yes then how? Is it possible to create synonym in this way?

4 Answers   IBM, Metric Stream,

---

What is pseudo column ?

6 Answers   ABB,

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

How can you tell the difference between an index and a view?

0 Answers  

---

What is scope and visibility in PL/SQL?

0 Answers  

---

How do I order columns in sql?

0 Answers  

---

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

---

What are tables and fields in the database?

0 Answers  

---