why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.

2 Answers  

---

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

---

Define the select into statement.

0 Answers  

---

What is difference between sql and excel?

0 Answers  

---

what is the output of this query selet * from employee where 1=2 ??

11 Answers  

---

---

What is file based approach?

0 Answers  

---

What are primary key and foreign key and how they work?

0 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

Can we perform dml on view?

0 Answers  

---

What is error ora-12154: tns:could not resolve the connect identifier specified?

0 Answers  

---

How do I find duplicates in sql?

0 Answers  

---

select 10 from dual; y its showing all the rows with 10?

1 Answers  

---