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  

---

How collections are improve the performance?

1 Answers   Polaris,

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

How does one load ebcdic data? : aql loader

0 Answers  

---

Is sqlexception checked or unchecked?

0 Answers  

---

Can we write ddl statements in functions?

0 Answers  

---

Mention what does the hierarchical profiler does?

0 Answers  

---

How do you create a unique index?

0 Answers  

---

Is record in pl sql?

0 Answers  

---

how to include character strings in sql statements? : Sql dba

0 Answers  

---

Why stored procedures are faster than query?

0 Answers  

---

Which are the different case manipulation functions in sql?

0 Answers  

---