Can you create the tables first and then insert the data after please

CREATE TABLE authors aid CHAR(4) CONSTRAINT authors_aid_pk PRIMARY KEY, first_name VARCHAR2(10) CONSTRAINT authors fname_nn NOT NULL, last_name VARCHAR2(15) CONSTRAINT authors_lname_nn NOT NULL ); C301, Joan, Casteel CREATE TABLE genres ( id CHAR(2) CONSTRAINT genres_id_pk PRIMARY KEY, name VARCHAR2(15) CONSTRAINT genres_name_nn NOT NULL ) po, poetry, fi fiction, fa fantasy, sf science fiction, bi biography, my mystery, dr drama, nf nonfiction Poetry, Fiction, Fantasy, Science Fiction, Biography, Mystery, Drama, Nonfiction CREATE TABLE patrons patron_num VARCHAR2(3) CONSTRAINT patrons_patronnum_pk PRIMARY KEY, first_name VARCHAR2(10) CONSTRAINT patrons_fnamenn NOT NULL, last_name VARCHAR2(15) CONSTRAINT patrons_Iname_nn NOT NULL, street VARCHAR2(20) CONSTRAINT patrons_street_nn NOT NULL, city VARCHAR2(15) CONSTRAINT patrons_city_nn NOT NULL, CHAR(2) CONSTRAINT patrons_state_nn NOT NULL, postal_code CHAR(5) CONSTRAINT patrons postalcode_nn NOT NULL, phone CHAR(10) CONSTRAINT patrons_phone_nn NOT NULL state CREATE TABLE publishers pid CHAR(3) CONSTRAINT publishers_pid_pk PRIMARY KEY, name VARCHAR2(20) CONSTRAINT publishers_name_nn NOT NULL, city VARCHAR2(10) P01, Cengage, Boston