wirte a query to remove null? following table are col1 col2 col3 dinesh null null null suresh null null null prakesh i want the output like col1 col2 col3 dinesh suresh prkaesh

6 Answers   TCS,

---

What are the types of join in sql?

0 Answers  

---

How can you create Cursor with parametres ?

3 Answers  

---

In what condition is it good to disable a trigger?

0 Answers  

---

Which sql statement is used to return only different values?

0 Answers  

---

Cite the differences between execution of triggers and stored procedures?

0 Answers  

---

What is the different between Stored Procedure and Procedure?

7 Answers   Informatica, MIS,

---

What are the two parts of a procedure ?

6 Answers   Hi Caliber IT,

---

what are integrity rules?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

Can you have multiple SPs with the same name on a database?

2 Answers   CGI, Quest,

---

if i perform any operation on views such as insert, delete etc will my base table get affected?????

4 Answers  

---