Error checking in Views..

From: Venugopal V V S <venug_at_cse.iitb.ernet.in>
Date: Fri, 19 May 2000 10:44:28 +0530 (IST)
Message-Id: <10501.106046@fatcity.com>

Hello *

1. I am trying to develop a data table view that will allow me to view the data indicated below.
2. The view works, and I can get the correct data, but it does not include any "Error Checking". I am looking for ways to validate keyboard input using the view . Any help rendered is greatly appreciated.

Thank you ....
Venu

CREATE VIEW vState
AS SELECT boid, bex, phone, orderdate, ORDERNUB, AVAILID,DECODE(0,

INSTR(SUBSTR(boid, 1, 1), '0123456789'), 'NOT A NUMBER', 
INSTR(SUBSTR(boid, 2, 1), '0123456789'), 'NOT A NUMBER', 
INSTR(SUBSTR(boid, 3, 1), '0123456789'), 'NOT A NUMBER', 
DECODE(boid, '001', 0, 1), 'ARKANSAS', 
DECODE(boid, '002', 0, 1), 'ARKANSAS', 
DECODE(boid, '003', 0, 1), 'ARKANSAS', 
DECODE(boid, '004', 0, 1), 'ARKANSAS', 
DECODE(boid, '007', 0, 1), 'ARKANSAS', 
DECODE(boid, '012', 0, 1), 'ARKANSAS', 
DECODE(boid, '030', 0, 1), 'MISSOURI', 
DECODE(boid, '035', 0, 1), 'MISSOURI', 
DECODE(boid, '036', 0, 1), 'MISSOURI', 
DECODE(boid, '050', 0, 1), 'OKLAHOMA', 
DECODE(boid, '055', 0, 1), 'OKLAHOMA', 
DECODE(boid, '060', 0, 1), 'TEXAS', 
DECODE(boid, '131', 0, 1), 'TEXAS', 
DECODE(boid, '231', 0, 1), 'TEXAS', 
DECODE(boid, '065', 0, 1), 'NORTH CAROLINA', 

DECODE(boid, '612', 0, 1), 'NORTH CAROLINA', DECODE(2, DECODE(SIGN(TO_NUMBER(boid) - 613), 1, 0) + DECODE (SIGN(675 - TO_NUMBER(boid)), 1, 0), 0, 1), 'GEORGIA', 'UNKNOWN') Received on Fri May 19 2000 - 00:14:28 CDT