Answer Posted / vignesh lakshmirajan

simple..!!! Findout the primary key of the table..

then..

select count(primary_key_column) from table;

thats all; becos count vil work with non-null values.

primary key cant b null..
so.. v can use count on primary key...

20. Using a set operator, display the client number of all clients who have never placed an order.

2236

---

How to store pictures on to the database?

1030

---

What is a database schema in oracle?

1147

---

How can I create database in oracle?

1066

---

Explain the difference between a procedure and a function?

1237

---

How many types of auditing in Oracle?

1086

---

What are the different types of partitions in oracle?

1031

---

What is a cursor in oracle?

1228

---

Is the After report trigger fired if the report execution fails ?

2951

---

What happens if the update subquery returns multiple rows?

1164

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2262

---

How to define a specific record type?

1134

---

Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

3021

---

What is the implicit cursor in oracle?

1168

---

IS it possible to built the oracle database without setting the kernal parameters?

2393

---