create sequence phone_t_idx increment by 1 start with 1 nomaxvalue nocycle cache 10; create table phone_t( idx number, name varchar2(20), cellPhone varchar2(15), b_day date, constraint phone_t primary key(idx) ); create or replace procedure del_phone(p_num varchar2) is begin delete from phone_t where cellPhone = p_num; end; /