Wat is SGA ?

3 Answers   ABB,

---

I need a function for a train ticket reservation please answer it thanks in advance

0 Answers  

---

What are pl sql data types?

0 Answers  

---

Define join and name different types of joins?

0 Answers  

---

can we use out parameter in a function?Give an example.

4 Answers   Logica CMG, TCS,

---

when is the use of update_statistics command? : Sql dba

0 Answers  

---

How does a self join work?

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

What is query optimization in sql?

0 Answers  

---

What is a temporal table?

0 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  

---

What is a rank in sql?

0 Answers  

---