What do you understand by case manipulation functions?

0 Answers  

---

what are the differences between char and nchar? : Sql dba

0 Answers  

---

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 % TYPE and % ROWTYPE ? What are the advantages of using these over datatypes?

4 Answers  

---

How can we make an if statement within a select statement?

0 Answers  

---

---

how to add a new column to an existing table in mysql? : Sql dba

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

IN A TABLE HAVE ONE COLUMN PRIMARY KEY..IT WILL NOT ALLOWS NULL VALUES AND DUPLICATE VALUES..INSTEAD OF PRIMARY KEY WHY CANT WE USE UNIQUE AND NOT NULL.THESE TWO ALSO DOESNT ACCEPT NULL VALUES IN NOT NULL AND UNIQUE DOESNT ACCEPT DUPLICATE VALUES? SO WHAT IS THE DIFEERENCE BETWEEN(UNIQUE,NOT NULL) AND PRIMARY KEY??????

8 Answers   rsystems,

---

wtite down triggr not any entry on Sunday

2 Answers   NIT,

---

How to know the last executed procedure?

0 Answers  

---

how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba

0 Answers  

---

What are the different types of functions in sql?

0 Answers  

---