What is the difference between an inner and outer join?

0 Answers  

---

What is mutating trigger?

0 Answers  

---

how are rank and dense rank being alloted for column with same values over a particular column

1 Answers  

---

What is the difference between sql and isql*plus?

0 Answers  

---

How to maintain the history of code changes of pl/sql?

3 Answers  

---

---

what are properties of a transaction? : Sql dba

0 Answers  

---

please explain database architecture..

1 Answers   Infosys,

---

What is coalesce in sql?

0 Answers  

---

IF EMP HAS 2 ROWS,DEPT HAS 4 ROWS.WHATS THE RESULT OF SELECT * FROM EMP,DEPT;

1 Answers  

---

ename empno deptno amar 1 10 akbar 2 20 anthonny 3 30 jonathan 4 40 write a procedure to dispaly the column values ina row separated by a deleimiter eg - input - select ename from emp '|' output - amar|akbar|anthony|jonathan input - select empno from emp '@' o/p - 1@2@3@4 input - select deptno from emp '/' o/p - 10/20/30/40 Pls answer this questn.

2 Answers  

---

Explain unique key in sql.

0 Answers  

---

What is pl sql code?

0 Answers  

---