1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

6 Answers  

---

How to set a transaction to be read only in oracle?

0 Answers  

---

How to create id with auto_increment on oracle?

0 Answers  

---

what are steps for interface? where is exchange rate defined in which table?

0 Answers  

---

Differentiate between TRUNCATE and DELETE?

2 Answers  

---

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

---

What is a View ?

3 Answers  

---

How to find out what privileges a user currently has in oracle?

1 Answers  

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

How to put more than 1000 values into an oracle in clause?

0 Answers  

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

0 Answers  

---

What is a Tablespace?

5 Answers  

---