need to check details in a table

From: Jimbo <threepio23_at_yahoo.com>
Date: Fri, 3 Jan 2003 18:56:04 +0000 (UTC)
Message-ID: <av4mc4$5ko$1@helle.btinternet.com>

I want to prompt the user to enter a supplier number (e.g. 3332), and then check whether that supplier has supplied within the last twelve months, if it hasn't, it will remove it's details. If it has, it will leave it as it was.

I am using SQL Plus in Oracle 9i.

The columns I have in my supplier table are as follows: SUPNO
SUPNAME
SUPADD
SUPPCODE
PAYTERMS I also have a table called PURORDERUNPRI where I can find out what suppliers have supplied to the company within the last year because it has the supplier number and the date of the order of each part. Here are the columns for this table:
PARTNO
PURORDERDATE (e.g. 21-jun-02)
UNPRI
SUPNO Any help on this would be great.
Thanks. Received on Fri Jan 03 2003 - 12:56:04 CST