Re: SQL statement to change group of data

This can be easily done in a number of ways. Unfortunately, you did not include enough specifics to help point you in the right direction. But based on what you have written, what you want to do is pretty straightforward and shouldn't present any problem.

Cheers,
Arnold

In article <8vuipf$abh$1_at_nnrp1.deja.com>,   neelee_at_my-deja.com wrote:
> Is there such a thing as a SQL statement that would allow me to
> chage/move users and their assorted documents in one pass?
>
> I have 10 users in a group, each with 100-150 associated documents. I
> would like to move each user and their documents to a different group.
> Our company is expanding, therefore, they want to create new "groups"
> to accomodate the change.
>
> I apologize in advance for such an awkward question. I am new to
> Oracle SQL and unfortunately I only knew enough to be dangereous.
>
> Thank you in advise for any insite and advise you might have.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 01 2000 - 12:14:45 CST