Practical SQL Handbook, The: Using SQL Variants, Fourth Edition

Oracle CREATEs

 --read in at SQL Plus as --connect name/password (substitute yours); --start filename.txt; -- DROP TABLE and CREATE TABLE commands drop table authors; create table authors (au_id char(11) not null, au_lname varchar2(40) not null, au_fname varchar2(20) not null, phone char(12) null, address varchar2(40) null, city varchar2(20) null, state char(2) null, zip char(5) null); grant select on authors to public ; drop table publishers; create table publishers (pub_id char(4) not null, pub_name varchar2(40) null, address varchar2(40) null, city varchar(20) null, state char(2) null); grant select on publishers to public ; drop table roysched; create table roysched (title_id char(6) not null, lorange number null, hirange number null, royalty ...