DROP SEQUENCE staff_sno;
CREATE SEQUENCE staff_sno INCREMENT BY 1;

DROP TABLE xxxx;
CREATE TABLE xxxx ( n NUMBER, c CHAR(50) );
INSERT INTO xxxx VALUES ( staff_sno.nextval , 'aaaa' );
SELECT  staff_sno.nextval FROM dual; 