Can we join two tables without common column?

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 do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

2 Answers   DELL,

---

What SQL keyword must immediately follow the UNION ALL statement? 1. SELECT 2. INTO 3. ORDER 4. WHERE 5. JOIN

4 Answers  

---

What is application trigger?

0 Answers  

---

---

What is a sql instance vs database?

0 Answers  

---

what is meant by DML?

5 Answers   HCL,

---

Why sql query is slow?

0 Answers  

---

Mention what is the plv (pl/vision) package offers?

0 Answers  

---

Is pl sql different from sql?

0 Answers  

---

What is on delete restrict?

0 Answers  

---

Is primary key always clustered index?

0 Answers  

---