You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?

0 Answers  

---

Explain the general syntax for a SELECT statements covering all the options.

3 Answers  

---

What is the system function to get the current user's user id?

4 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

0 Answers  

---

If a column is an image value type, how you can compare column values? How can you use this column in join clause?

0 Answers  

---

Hi , any one can help me on the same,this is regarding the Informatica Function doc,i want to know how developer is will develop the mapping. pl forwar the any function doc .just for my references. svlc75@yahoo.co.in

0 Answers   Covansys,

---

Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?

0 Answers   IBM,

---

How can you log an error to the server event log from a stored procedure?

0 Answers  

---

Explain the role of indexing in databases?

0 Answers  

---

what is difference between primary key and unique key ?

2 Answers  

---

hi in which phase of mload can i use .FILLER

1 Answers   IBM,

---