What is difference between cartesian join and cross join?

0 Answers  

---

Can group functions be mixed with non-group selection fields?

0 Answers  

---

Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)

6 Answers  

---

What is the difference between "as" and "is" in an oracle stored procedure?

0 Answers  

---

What is the difference between Outer join and Full outer join?

5 Answers  

---

what are the things that you consider while creating indexes on partitioning tables?

1 Answers  

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

What is a nested table?

0 Answers  

---

HOW TO DISPLAY MAXIMUM SALARIES FROM EMP DEPARTMENT VISE ALONG WITH DEPARTMENT NAMES? E.g EMP,DEPT

5 Answers   College School Exams Tests, DELL,

---

What is an external table?

0 Answers  

---

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

1 Answers  

---