Answer / posamram

select next_day(last_day(sysdate),'MON')-7 FROM DUAL;

Answer / shailesh

select NEXT_DAY(last_day(sysdate)-7,'THURSDAY') from dual;

How to retrieve 5th highest sal from emp table?

8 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  

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

0 Answers   Atos Origin,

---

Is there an oracle sql query that aggregates multiple rows into one row?

0 Answers  

---

How to establish administrator authentication to the server?

0 Answers  

---

---

what is the difference between sql& oracle?

11 Answers   Oracle,

---

how many outer joins are used in a single sql query? is there any limitations for using of outer joins?

2 Answers   BOB Technologies, Cap Gemini, IBM,

---

Give the various rollback segment states.

0 Answers  

---

What happens to the current transaction if the session is ended?

0 Answers  

---

How to convert characters to numbers in oracle?

0 Answers  

---

Can objects of the same Schema reside in different tablespaces.?

3 Answers  

---

How many types of database triggers exist?

0 Answers  

---