without using count(*) and rownum how can we count total record in a table

5 Answers   AC, HP,

---

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

0 Answers  

---

The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL

1 Answers   TCS,

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

0 Answers  

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

0 Answers   Infosys,

---

why pl sql doesn't support retrieving multiple records

1 Answers   Mphasis,

---

What is index-organized table in Oracle?

0 Answers   MCN Solutions,

---

I have a table like this Table Name:Products Productid Price 1 10 1 10 2 20 3 30 3 30 But i want to output like this. productid price 2 20. please replay me.

3 Answers   TCS,

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

0 Answers  

---

Which is better Oracle or MS SQL? Why?

2 Answers   Bally Technologies,

---

What is currency type in database ?

3 Answers   TCS,

---

What should be the return type for a cursor variable.Can we use a scalar data type as return type?

1 Answers  

---