how to create a new view in mysql? : Sql dba

0 Answers  

---

What can I use instead of union in sql?

0 Answers  

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

How do you use join?

0 Answers  

---

Do stored procedures prevent sql injection?

0 Answers  

---

---

Interchange the value of a column Gender in a table where values are Male and Female. So, where the value is Male, it should changed to Female and Female to Male.

4 Answers   Cap Gemini, IBM,

---

Why do we need sharding?

0 Answers  

---

Does varchar need length?

0 Answers  

---

What is the main difference between sql and pl/sql?

0 Answers  

---

i have xml source. xml source having lacks of records. i want extract/retrive xml source data using sql query. please tell me how to write query.

4 Answers   TCS,

---

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

4 Answers  

---

can i use global variables in stored procedure or function

1 Answers   L&T,

---