Answer / ramya

select * from test_1 where name is not null and age is not
null;

What is set serveroutput on in pl sql?

0 Answers  

---

What is normalization in a database?

0 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

What are stored procedures in mysql?

0 Answers  

---

wht is the difference between sqlaserver2000 and 2005

1 Answers   ABC, IBM,

---

---

If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

Why are sql stored procedures used?

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

in a package one procedure is wrong package shows valid or not

4 Answers  

---

Is it possible to pass parameters to triggers?

0 Answers  

---

What is the difference between delete, truncate and drop command?

0 Answers  

---

What is auto increment in sql?

0 Answers  

---