Answer / vyshak

select * from
(select sql_id,sql_fulltext,elapsedtime
from v$sql
order by elapsedtime desc)
where rownum<5;

How to connect a sql*plus session to an oracle server?

0 Answers  

---

what are the drivers in mysql? : Sql dba

0 Answers  

---

What is sql*loader and what is it used for? : aql loader

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

8 Answers  

---

What is field delimiter?

0 Answers  

---

What is primary key in db?

0 Answers  

---

What is a behavioral trigger?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance Suneel Reddy

6 Answers   Target,

---

What is use of term?

0 Answers  

---

how to use 'mysql' to run sql statements? : Sql dba

0 Answers  

---

a. Can you delete data from a View. b. If Yes, can you delete it if there are multiple tables c. If No, can you delete if there is single source table which is joining.

4 Answers   CGI, IBM,

---

What is sql table?

0 Answers  

---