oracle - Stuck on PL/SQL: ORA-00933: SQL command not properly ended -

i can't see error. marked places sql developer citing errors. can see going wrong? zcta5_2000 valid table data.

create or replace trigger zip_trigger   before insert on zcta5_2000   each row declare   low_zip number(5);   high_zip number(5);  <---  error pl/sql: sql statement ignored  ****** begin  <-----error pl/sql: ora-00933: sql command not ended ********    select low_zip, high_zip ziptable   low_zip, high_zip   :new.state = state_code;  <--- error pls-00103: encountered symbol "end"...      if :new.zip < low_zip or :new.zip>high_zip     end if; end; 

it looks line numbers being reported incorrectly. front ends that.

note pls-00103: encountered symbol "end" message 3 lines soon. assuming same ora-00933 message means it's pointing @ select statement, , sure enough that's error is:

select low_zip, high_zip ziptable low_zip, high_zip    <== should before ... 

the into has after select , before from. try changing this:

select low_zip, high_zip low_zip, high_zip ziptable ...