What is rownum?

0 Answers  

---

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

---

Which is better stored procedure or query?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---

What is relationship? How many types of relationship are there?

0 Answers  

---

consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

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,

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

Does indexing improve query performance?

1 Answers  

---

How to move files from one directory to another in pl sql?

0 Answers  

---

How do you create a db file?

0 Answers  

---

What is normalisation in sql?

0 Answers  

---