What is the difference between view and stored procedure?

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,

---

How to install oracle sql developer?

0 Answers  

---

Is it possible for a table to have more than one foreign key?

0 Answers  

---

How to convert ms-excel file to oracle table?

2 Answers  

---

what is the difference between implicit and explicit trigger

2 Answers   Tech Mahindra,

---

how to do backup entire database? : Transact sql

0 Answers  

---

What does closing a cursor do?

0 Answers  

---

Write a sql query to find the names of employees that begin with ‘a’?

0 Answers  

---

If we have n no of columns in a table, can we add new column in that table with not null constraint?

2 Answers  

---

Can we rollback delete command?

0 Answers  

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---