Answer Posted / hemalatha

Following is the query to find the nth maximum salary:

select * from emp
where sal=(select distinct(sal) from emp a
where &n=(select count(sal)from emp
where sal>=a.sal;))

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2365

---

How to synchronize 2 schema's objects?

2234

---

Explain temporal data types in oracle

1133

---

How to create a table index in oracle?

1186

---

What is redo log?

1116

---

How to get a list of all user accounts in the database?

1131

---

What are the components of logical database structure in oracle database?

1139

---

if you ctreate table identity

2430

---

Is a rollback possible to any savepoint?

1155

---

How to increment dates by 1 in oracle?

1138

---

What is a server parameter file in oracle?

1098

---

What is a Garbage Collection? and what is full recursive Garbage collection?

2957

---

How do I know if oracle client is installed on windows?

1096

---

How to define an anonymous procedure with variables?

1242

---

Explain the use of Merge statement in oracle 11g

1077

---