what is rollback? : Sql dba

0 Answers  

---

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

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  

---

how to concatenate two character strings? : Sql dba

0 Answers  

---

How many tables can you join in sql?

0 Answers  

---

what is a record in a database ? : Sql dba

0 Answers  

---

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

---

How to find the count of letter "L" in HELLO

7 Answers   HP,

---

diff b/w sub query and co-relater query?

3 Answers   iFlex,

---

How do you know if a relationship is 2nf?

0 Answers  

---

How are multiple column = value pairs delimited in the SET clause of an UPDATE statement? 1. With commas (SET price = 0, status = 'I') 2. With parentheses (SET (price = 0) (status = 'I')) 3. With double-pipes (SET price = 0 || status = 'I') 4. With square-brackets (SET [price = 0] [status = 'I'] 5. With single or multiple spaces (SET price = 0 status = 'I')

2 Answers  

---

how to enter numeric values as hex numbers? : Sql dba

0 Answers  

---