define sql insert statement ? : Sql dba

0 Answers  

---

discuss about myisam key cache. : Sql dba

0 Answers  

---

What is scalar function?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

have table with two columns with datatypes as number and varchar and the values in A column like 1,2,3 AND B column values like a,b,c. now need to display data in a single column as 1,a,2,b,3,c.

8 Answers   IBM, Zensar,

---

---

Which is better cte or subquery?

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

How do I order columns in sql?

0 Answers  

---

In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;

2 Answers   Mastek,

---

What is the difference between left outer join and left join?

0 Answers  

---

What are the topics in pl sql?

0 Answers  

---

What do you mean by query optimization?

0 Answers  

---