If the application is running very slow? At what points you need to go about the database in order to improve the performance?

0 Answers  

---

Why do we use set serveroutput on?

0 Answers  

---

what are dynamic queries in t-sql? : Transact sql

0 Answers  

---

What is mutating trigger?

0 Answers  

---

How does rowid help in running a query faster?

0 Answers  

---

---

what is the different between unique+not null & primary key,

4 Answers  

---

write a query filter the null value data following source? name age john 30 smith null null 24 sharp 35 i want output name age john 30 sharp 35

1 Answers   TCS,

---

What is embedded sql what are its advantages?

0 Answers  

---

What is scope of pl sql developer in future?

0 Answers  

---

in sql table follw columns r their vehicle_no|servicetype|date|location| 1234 |1FS |1-JAN|PUNE| 4561 |2FS |5-JAN|PUNE| 1234 |PS |7-JAN|PUNE| 1234 |PS |15-JAN|MUMB| i want o/p below vehicleno|1fs|1fsdate|1fslocation|1ps|1PSDATE|1PSLOC|2PS|2PS DATE|2PSLOCA e.g 1234|1FS|1JAN|PUNE|1PS|7JAN|PUNE|2PS|15JAN|MUMBAI PLS help me out to execute using sql query

1 Answers  

---

how to retrieve last tree records from table? select *from emp where rownum > (select count(*)-3 from emp); i am using this query to get last three records from table but its not giving any output, so please tell me what is the error in this query.

16 Answers  

---

Store procedure will return a value?

4 Answers   eMids,

---