how to eliminate null values in a column i.e table vlaues 1 2 3 NULL 3 4 1 5 NULL i want output like this 1 2 3 3 4 1 5 i dnt want to use nvl is null and i dnt want replace the NULL value with any value i.e nvl(col,o);

11 Answers   Satyam,

---

what is cursor. write example of it. What are the attributes of cursor.

0 Answers  

---

select sal from emp group by sal

3 Answers   TCS,

---

How do you define a foreign key?

0 Answers  

---

what is the bond code in materialized view?

0 Answers  

---

---

How to fetch alternate records from a table?

0 Answers  

---

can i call procedure in package

3 Answers   TCS,

---

Mention what is the use of function "module procedure" in pl/sql?

0 Answers  

---

Why stored procedure is better than query?

0 Answers  

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

What is the difference between RDBMS and DBMS?

20 Answers   Practical Viva Questions, Sapient, Stag Computers,

---

table name :Tab fields name 1.trx_no (pk) 2.trx_date 3.account code (7 char) 4.account type (1 char) 5.amt Tab contains account code day wise debit and credit transaction , account type fiels can have 2 value D for debit and c for Credit . write a query to display the account code wise total debit and credit bal for the month of april 2004. write a query to display account code wise new amt credit for the april 2004

2 Answers   Maruti Suzuki,

---