Oracle基础教程

-- Execute this SQL file to build and load -- the simple table for Chapter 1 SET FEEDBACK OFF PROMPT Chapter 1 PROMPT SET TERMOUT OFF DROP TABLE Clients CASCADE CONSTRAINTS PURGE; CREATE TABLE Clients ( ClientID INTEGER NOT NULL, FirstName NVARCHAR2(30), LastName NVARCHAR2(30), Category NVARCHAR2(20), Balance NUMBER(38,4), CONSTRAINT pk_Clients PRIMARY KEY (ClientID) ); INSERT INTO Clients VALUES (101, 'Stanley', 'Best', 'Builder', 157.32); INSERT INTO Clients VALUES (102, 'Jack', 'Kostantaras', 'Banker', 1153.11); INSERT INTO Clients VALUES (103, 'Terrence', 'Gerson', 'Builder', 3521.33); INSERT INTO Clients VALUES (104, 'Robert', 'Choate', 'Dentist', 938.55); INSERT INTO Clients VALUES (105, 'Patrick', 'Townes', 'Physician', 3938.33); INSERT INTO Clients VALUES (106, 'Ann', 'Dattillo', 'Teacher', 114.11); INSERT INTO Clients VALUES (107, 'Andrew', 'Bianco', 'Dentist', 7647.99); INSERT INTO Clients VALUES (108, 'Susan', 'Galin', 'Physician', 444.22); INSERT INTO Clients VALUES (109, 'William', 'Pauley', 'Teacher', 847.21); INSERT INTO Clients VALUES (110, 'John', 'Kent', 'Banker', 474.33); INSERT INTO Clients VALUES (111, 'Tracy', 'Johnson', 'Dentist', 557.87); INSERT INTO Clients VALUES (112, 'Mark', 'Warnock', 'Teacher', 111.33); INSERT INTO Clients VALUES (113, 'Mary', 'Kobasa', 'Builder', 847.44); INSERT INTO Clients VALUES (114, 'Dale', 'Levenre', 'Physician', 3331.21); INSERT INTO Clients VALUES (115, 'Peter', 'Tombros', 'Builder', 393.22); INSERT INTO Clients VALUES (116, 'David', 'Yost', 'Physician', 786.33); COMMIT; SET TERMOUT ON PROMPT Clients table created and populated. SELECT Count(*) FROM Clients; SET FEEDBACK ON