consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?

1 Answers  

---

select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help

6 Answers  

---

how to genarate random numbers in oracle for particular row?

3 Answers  

---

A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?

1 Answers   IBM,

---

How can we Update a table with out using UPDATE command?

1 Answers  

---

---

Query to get max and second max in oracle in one query ?

34 Answers   CTS, Keane India Ltd, TCS, Wipro,

---

When do we use group by clause in a sql query?

0 Answers  

---

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

1 Answers   Wipro,

---

What is dictionary cache ?

2 Answers  

---

What is tns entry?

0 Answers  

---

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

0 Answers   Infosys,

---

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,

---