Answer Posted / nitinmukhraiya

Rownum and RowID displays the results faster than others -

select * from <Table_Name> where rownum=1
union
select * from (select * from <Table_Name> order by rownum desc) where rownum=1

Is a view faster than a stored procedure?

947

---

What is a function in oracle pl sql?

1014

---

what is the difference between a local and a global temporary table? : Sql dba

1045

---

When is the explicit cursor used ?

1007

---

What is the unique index?

1043

---

What are the datatypes available in pl/sql ?

1084

---

what is text? : Sql dba

1057

---

What is before trigger?

987

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

992

---

Enlist the advantages of sql.

986

---

How many types of cursors are available in pl/sql?

1081

---

In what condition is it good to disable a trigger?

995

---

Is primary key an index?

984

---

What is sap sql anywhere?

1049

---

What is varchar example?

1012

---