Re: Looping through the users table

Moti Moskovich wrote:
> All,
> I'm new to Oracle and I would like to find a way to create a script that
> will loop through a list of users (the output of a select query from the
> users system table) and remove each one of them.
>
> Thanks in advance.

In what version of Oracle?

In 8i or before a cursor loop and update In 9i or after bulk collect and forall

In any version ... use a simple DML statement if you don't really require the loop.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)