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 are mysql timestamps seen to a user? : Sql dba

0 Answers  

---

How can you view the errors encountered in a trigger?

0 Answers  

---

Why do we need cursor in pl sql?

0 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

what is the difference between trigger and storedprocedures

16 Answers   Tech Mahindra,

---

How do you bind variables in pl sql?

0 Answers  

---

Explain the purpose of %type and %rowtype data types with the example?

0 Answers  

---

What is the difference between union and union all command?

0 Answers  

---

What is oracle pl sql developer?

0 Answers  

---

how to do backup entire database? : Transact sql

0 Answers  

---

What does data normalization mean?

0 Answers  

---