how can we optimize or increase the speed of a mysql select query? : Sql dba

0 Answers  

---

Is json a nosql?

0 Answers  

---

What type of join is sql join?

0 Answers  

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

How can we avoid duplicating records in a query?

0 Answers  

---

Define union, minus, union all, intersect ?

0 Answers  

---

Can we use pl sql in sql server?

0 Answers  

---

Define commit?

0 Answers  

---

How many types of relationship are there?

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  

---

write a procedure to print a statement or number not using "dbms_output.put_line" package.write a procedure instead of it using procdure name as "print" ex:- declare a number:=2; begin print(a); end; /* when U type above procedure 2 have to should be printed*/

2 Answers   iFlex,

---

What is Raise_application_error ?

1 Answers  

---