Answer Posted / naveen

SELECT * FROM EMP WHERE ROWID IN(SELECT MIN(ROWID) FROM EMP)
UNION ALL
SELECT * FROM EMP WHERE ROWID IN(SELECT MAX(ROWID) FROM EMP);

Briefly explain what is literal? Give an example where it can be used?

972

---

What is the difference between sharding and partitioning?

928

---

Explain the use of rows option in exp command.

1021

---

What is an oracle function?

1071

---

How to concatenate two text values in oracle?

1051

---

Where do you use decode and case statements?

940

---

How to recover a dropped table in oracle?

983

---

How to best split csv strings in oracle 9i?

983

---

Can a formula column referred to columns in higher group ?

2455

---

How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

2070

---

What is raw datatype in oracle?

1049

---

How can we delete duplicate rows in a table?

925

---

Where do we use decode and case statements?

942

---

What is the Tune Query

2232

---

How to convert times to characters in oracle?

976

---