Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Questions: ORACLE process

Re: Questions: ORACLE process

From: Antoine Brunel <antoinebrunel_at_yahoo.fr>
Date: Fri, 21 May 1999 11:04:57 +0200
Message-ID: <7i37ft$eig$1@minus.oleane.net>


>2. A DB developer is running SQL query or PL/SQL program.
> Is it possible for DBA to rollback this DB developer's
> process?

see 3...

>3. How to stop/kill/drop a running PL/SQL program in ORALCE.

alter system kill session id

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

select emp_id from table;
select sum(emp_id) from table: Received on Fri May 21 1999 - 04:04:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US