Re: Define a job to run once an year

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 27 Dec 2004 09:45:27 -0800
Message-ID: <41d04927$1_4@127.0.0.1>

ak_tiredofspam_at_yahoo.com wrote:

>>>A better example is the engine serial number used by a manufacturer

>
> I
> know of. The first two digits represent the number of cylinders and
> the two following digits represent the series. The final six digits
> are a sequential sequence from 1 to 99999. If enough units are
> produced to consume the sequence then it is reset to 1 and another
> series code is issued to allow extension of the line.
> ... <<
>
> I guess another example could be US Zip code - one can determine the
> state by looking at its first 2 digits, correct?

SQL> SELECT DISTINCT SUBSTR(zip_code,1,2)

   2 FROM zips
   3 WHERE state_abbrev = 'WA';

SU

--
98
99

SQL> ed
Wrote file afiedt.buf

   1  SELECT DISTINCT SUBSTR(zip_code,1,2)
   2  FROM zips
   3* WHERE state_abbrev = 'NY'
SQL> /

SU
--
06 (while most of 06 is CT, Fishers Island is NY
10
11
12
13
14

6 rows selected.

SQL>
-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Mon Dec 27 2004 - 11:45:27 CST