Answer Posted / d ashwin

AS OUR EXAMPLE HR SCHEMA FOR GROUP WISE MAX DATE...

SELECT * FROM HR.EMPLOYEES
WHERE HIRE_DATE IN
(SELECT MAX(HIRE_DATE) FROM HR.EMPLOYEES
GROUP BY DEPARTMENT_ID);

FOR SINGLE ROW MAX DATE...
SELECT * FROM
(
SELECT * FROM HR.EMPLOYEES
ORDER BY HIRE_DATE DESC)
WHERE ROWNUM = 1;

How do you find current date and time in oracle?

1006

---

Where is the export dump file located?

1107

---

Explain index?

1223

---

What are the varoius components of physical database structure of oracle database?

970

---

What are the types of trigger in oracle?

944

---

How to create an oracle database manually?

1046

---

What is transport network substrate (tns) in oracle?

1010

---

Can select statements be used on views in oracle?

1006

---

Can the query output be sorted by multiple columns in oracle?

959

---

What are the restrictions in a oracle read only transaction?

990

---

What is a private synonym?

1546

---

How do I use unicode codesets with the weblogic jdriver for oracle driver?

1040

---

how to clone 9i Database on to 10g Database.

2312

---

Explain an integrity constrains?

1102

---

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2081

---