Answer / Pramod Kumar Pandey

The Oracle Client is needed to allow an application running on one machine (the application tier) to connect to the Oracle Database Server that resides on another machine. It provides the necessary libraries and tools for establishing a connection, submitting SQL commands, and processing the results.

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 2 NULL 3 4 NULL 5 6 7 NULL NULL O/P C = 2 4 6

2 Answers   TCS,

---

Is it possible to enter only time value into a column of a table in sql?

2 Answers  

---

What is the quickest way to fetch the data from a table?

1 Answers  

---

How to write text literals in oracle?

1 Answers  

---

What is SQL Tuning Advisor in Oracle?

1 Answers   MCN Solutions,

---

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

1 Answers   Oracle,

---

What are the major difference between truncate and delete?

1 Answers  

---

How to find 1st, 2nd, 3rd highest using select select statement not using rownum

3 Answers  

---

What is a Garbage Collection? and what is full recursive Garbage collection?

1 Answers   RBS,

---

Explain the use of show option in imp command.

1 Answers  

---

Explain self joins in oracle?

1 Answers  

---

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

1 Answers  

---