how can we repair a mysql table? : Sql dba

0 Answers  

---

write a query to display diference between two dates in sql server

2 Answers  

---

Is there any restriction on the use of union in embedded sql?

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,

---

What is trigger in sql?

0 Answers  

---

What is query syntax?

0 Answers  

---

Explain normalization and what are the advantages of it?

0 Answers  

---

What are the rules to be applied to nulls whilst doing comparisons?

0 Answers  

---

Is join an inner join?

0 Answers  

---

How we get all_group_function's(Sum,avg,count,max and min_value of a column(Sal) Using pl/sql anonymous block, with out using group function's. You shouldn't use more than one select statement in entire the program. Like cursor c is select * from <table_name>; except this you can't use another select statement. You can use no of variables as per requirement.

1 Answers  

---

What is the source code of a program?

0 Answers  

---

Do we need to rebuild index after truncate?

0 Answers  

---