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 are the different types of dbmss?

0 Answers  

---

What is the plv (pl/vision) package offers?

0 Answers  

---

Which query operators in sql is used for pattern matching?

0 Answers  

---

What does where 1 1 mean in sql?

0 Answers  

---

I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.

1 Answers   IBM, Saama Tech,

---

why sql is used as interpreter frequently rather than a compile?

1 Answers  

---

Difference between views and materialized views?

5 Answers   BirlaSoft,

---

can sql servers linked to other servers like oracle? : Sql dba

0 Answers  

---

how to retrive only second row from table?

31 Answers   IBM,

---

Why do we use procedures in sql?

0 Answers  

---

When can we use the where clause and the having clause?

0 Answers  

---