SQL> create table employee(
2 employee_id number(9),
3 first_name varchar2(15),
4 last_name varchar2(20),
5 email varchar2(25),
6 constraint pk_employee primary key (employee_id)
7 );
Table created.
SQL>
SQL> insert into employee
2 values (1, 'Tom', 'Kyte', 't@aaa.com');
1 row created.
SQL>
SQL> insert into employee
2 values (2, 'Sean', 'Dillon', 's@aaa.com');
1 row created.
SQL>
SQL> insert into employee
2 values (3, 'Christopher', 'Beck', 'c@aaa.com');
1 row created.
SQL>
SQL> commit;
Commit complete.
SQL>
SQL> select *
2 from employee;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL
----------- -------------------- -------------------- -------------------------
1 Tom Kyte t@aaa.com
2 Sean Dillon s@aaa.com
3 Christopher Beck c@aaa.com
3 rows selected.
SQL> alter table employee
2 add (
3 phone_number varchar2(10)
4 )
5 /
Table altered.
SQL>
SQL> select *
2 from employee;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_NUMB
----------- -------------------- -------------------- ------------------------- ----------
1 Tom Kyte t@aaa.com
2 Sean Dillon s@aaa.com
3 Christopher Beck c@aaa.com
3 rows selected.
SQL> drop table employee;
Table dropped.
SQL>