Oracle PL/SQL/Table/Rename Table

Renaming Tables and query it

   <source lang="sql">

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", "YourName@q.ru"); 1 row created. SQL> insert into people values (2, "S", "Dillon", "sdillon@q.ru"); 1 row created. SQL> insert into people values (3, "C", "Beck", "clbeck@q.ru"); 1 row created. SQL> SQL> select * from people; EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL

---

--------------- -------------------- -------------------------

         1 T               Kyte                 YourName@q.ru
         2 S               Dillon               sdillon@q.ru
         3 C               Beck                 clbeck@q.ru

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                 YourName@q.ru
         2 S               Dillon               sdillon@q.ru
         3 C               Beck                 clbeck@q.ru

SQL> drop table people; SQL> drop table employees; Table dropped. SQL> SQL>

</source>