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  

---

Is it possible to read/write files to-and-from PL/SQL?

0 Answers  

---

Maximum how many triggers can we use in trigger and How to find out how many records it fetched.

1 Answers   TCS,

---

what are numeric data types? : Sql dba

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

How to fetch common records from two tables?

1 Answers  

---

what is a composite key ? : Sql dba

0 Answers  

---

how to get a list of columns in an existing table? : Sql dba

0 Answers  

---

What is example of database?

0 Answers  

---

can i use dbms_output.put_line in a function u are telling as return statement

7 Answers  

---

What version is sql?

0 Answers  

---