Renaming Tables and query it : Rename Table « Table « Oracle PL / SQL

Home
Oracle PL / SQL
1.Aggregate Functions
2.Analytical Functions
3.Char Functions
4.Constraints
5.Conversion Functions
6.Cursor
7.Data Type
8.Date Timezone
9.Hierarchical Query
10.Index
11.Insert Delete Update
12.Large Objects
13.Numeric Math Functions
14.Object Oriented Database
15.PL SQL
16.Regular Expressions
17.Report Column Page
18.Result Set
19.Select Query
20.Sequence
21.SQL Plus
22.Stored Procedure Function
23.Subquery
24.System Packages
25.System Tables Views
26.Table
27.Table Joins
28.Trigger
29.User Previliege
30.View
31.XML
Oracle PL / SQL » Table » Rename Table 
Renaming Tables and query it
 

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.com');

row created.

SQL> insert into people values (2'S''Dillon', 'sdillon@q.com');

row created.

SQL> insert into people values (3'C''Beck', 'clbeck@q.com');

row created.

SQL>
SQL> select from people;

EMPLOYEE_ID FIRST_NAME      LAST_NAME            EMAIL
----------- --------------- -------------------- -------------------------
          T               Kyte                 YourName@q.com
          S               Dillon               sdillon@q.com
          C               Beck                 clbeck@q.com

SQL>
SQL> alter table people rename to employees;

Table altered.

SQL>
SQL> select from employees;

EMPLOYEE_ID FIRST_NAME      LAST_NAME            EMAIL
----------- --------------- -------------------- -------------------------
          T               Kyte                 YourName@q.com
          S               Dillon               sdillon@q.com
          C               Beck                 clbeck@q.com

SQL>
drop table people;
SQL> drop table employees;

Table dropped.

SQL>
SQL>

 
Related examples in the same category
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.