в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:54:54Z

1 версия

Новая страница

==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>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL/Table/Rename Table - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия