Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need to check and remove details
Jimbo wrote:
> In my database I want to produce some SQL code that checks my supplier
> records on an annual basis to find out if it HASN'T supplied anything to the
> company. If it hasn't, I want it to remove the details of the supplier from
> the company. I am wondering if anyone could tell me what type of code I
> would need to do this, or even better, some example of the code that could
> do this type of thing.
>
> Thanks
A simple SQL statement will easily work.
To write it for you ... or even to guess at what to write ... would require knowing the structure of the table(s) involved.
And the version of Oracle, etc. wouldn't hurt either.
Daniel Morgan Received on Thu Jan 02 2003 - 14:18:32 CST