SQL>
SQL> create table people(
2 employee_id number(9),
3 first_name varchar2(15),
4 last_name varchar2(20),
5 email varchar2(25),
6 constraint pk_people primary key (employee_id)
7 );
Table created.
SQL>
SQL> insert into people values (1, 'T', 'Kyte', 'Yo[email protected]');
1 row created.
SQL> insert into people values (2, 'S', 'Dillon', 'sd[email protected]');
1 row created.
SQL> insert into people values (3, 'C', 'Beck', 'cl[email protected]');
1 row created.
SQL>
SQL> select * from people;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL
----------- --------------- -------------------- -------------------------
1 T Kyte [email protected]
2 S Dillon [email protected]
3 C Beck [email protected]
SQL>
SQL> alter table people rename to employees;
Table altered.
SQL>
SQL> select * from employees;
EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL
----------- --------------- -------------------- -------------------------
1 T Kyte [email protected]
2 S Dillon [email protected]
3 C Beck [email protected]
SQL>
drop table people;
SQL> drop table employees;
Table dropped.
SQL>
SQL>
|
|
