Answer Posted / nagesh

SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;

Why sql query is slow?

573

---

What is the difference between sql and mysql?

545

---

how to convert character strings to dates? : Sql dba

514

---

how can we know the count/number of elements of an array? : Sql dba

565

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2566

---

---

how to drop an existing table in mysql? : Sql dba

550

---

What is the use of & in pl sql?

530

---

What are different categories of sql commands?

628

---

Do foreign keys improve performance?

537

---

What are sql functions? Describe the different types of sql functions?

548

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

503

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1128

---

What is a trigger in sql?

632

---

What is the difference between union and union all command?

540

---

Can ddl statements be used in pl/sql?

589

---