Answer Posted / swastik mohanty

--TO FIND EVEN NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWNUM, 2), 0, ROWID, NULL) FROM Table);
--TO FIND ODD NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWID, 2), 1, ROWID, NULL) FROM Table);

Explain the use of parfile option in exp command.

1138

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4681

---

What is ceil and floor in oracle?

1118

---

Oracle

2422

---

What is translate in oracle?

1140

---

How view is different from a table?

1081

---

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

2183

---

What is a tns file?

1040

---

How to use an explicit cursor without open statements?

1099

---

What is meant by a deadlock situation?

1153

---

What are the built-in functions used for sending Parameters to forms ?

3432

---

There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??

2084

---

What are the various oracle database objects?

1201

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2141

---

What do you mean by a deadlock?

1107

---