how to shutdown mysql server? : Sql dba

0 Answers  

---

What does seeding a database mean?

0 Answers  

---

Which tcp/ip port does sql server run on? How can it be changed? : Sql dba

0 Answers  

---

what is a view? : 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 is a CTE (Common Table Expression), and how is it different from a subquery?

3 Answers  

---

i have a table eno dno sal 1 10 200 2 10 150 3 10 100 4 20 75 5 20 100 i want to get sal which is less than the avg sal of thri dept. eno dno sal 2 10 150 3 10 100 4 20 75

12 Answers   IBM,

---

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

0 Answers  

---

Like shown below i have 3 columns(Name,No,Address). The values in name column i want to modity. Requirement : Keep only once space between two words (Fname,Lname) in the Name column. For this what is the query? Please answer me. Advance Thanks. Name No Address Reference manoj kumar kumar raja vinzay kumar rajendra prasad gowri nath -- -- --

5 Answers  

---

We have a CURSOR then we need BULK COLLECT?

1 Answers  

---

What is sql mysql pl sql oracle?

0 Answers  

---