|
SQL>
SQL> CREATE TABLE employees (
2 au_id CHAR(3) NOT NULL,
3 au_fname VARCHAR(15) NOT NULL,
4 au_lname VARCHAR(15) NOT NULL,
5 phone VARCHAR(12) NULL ,
6 address VARCHAR(20) NULL ,
7 city VARCHAR(15) NULL ,
8 state CHAR(2) NULL ,
9 zip CHAR(5) NULL
10 );
Table created.
SQL>
SQL> INSERT INTO employees VALUES('A01','S','B','111-111-1111','75 St','Boston','NY','11111');
1 row created.
SQL> INSERT INTO employees VALUES('A02','W','H','222-222-2222','2922 Rd','Boston','CO','22222');
1 row created.
SQL> INSERT INTO employees VALUES('A03','H','H','333-333-3333','3800 Ave, #14F','San Francisco','CA','33333');
1 row created.
SQL> INSERT INTO employees VALUES('A04','K','H','444-444-4444','3800 Ave, #14F','San Francisco','CA','44444');
1 row created.
SQL> INSERT INTO employees VALUES('A05','C','K','555-555-5555','114 St','New York','NY','55555');
1 row created.
SQL> INSERT INTO employees VALUES('A06',' ','K','666-666-666','390 Mall','Palo Alto','CA','66666');
1 row created.
SQL> INSERT INTO employees VALUES('A07','P','O','777-777-7777','1442 St','Sarasota','FL','77777');
1 row created.
SQL>
SQL>
SQL>
SQL> SELECT au_fname AS "First name",
2 au_lname AS "Last name",
3 city AS "City",
4 state,
5 zip AS "Postal code"
6 FROM employees;
First name Last name City ST Posta
--------------- --------------- --------------- -- -----
S B Boston NY 11111
W H Boston CO 22222
H H San Francisco CA 33333
K H San Francisco CA 44444
C K New York NY 55555
K Palo Alto CA 66666
P O Sarasota FL 77777
7 rows selected.
SQL>
SQL>
SQL> drop table employees;
Table dropped.
|