Questions: ORACLE process

From: <cheers_up_at_hotmail.com>
Date: Thu, 20 May 1999 23:40:57 GMT
Message-ID: <7i26i9$om8$1@nnrp1.deja.com>

Hi,

I am learning ORACLE, I have following questions, would appreciate someone explain to me...Thanks

1. what are the possible reasons for your SQL query or PL/SQL programs running very slow?
2. A DB developer is running SQL query or PL/SQL program. Is it possible for DBA to rollback this DB developer's process?
3. How to stop/kill/drop a running PL/SQL program in ORALCE.
4. Assume, I have following records in a emp table:

   emp_id

---

     2
     4
     1
     5
     6

How do you write a SQL query to have the following result?

   emp_id

---

     2
     4
     1
     5
     6

---

Total 18

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Thu May 20 1999 - 18:40:57 CDT