导数据命令:
exp 用户名/密码@网络连接名 file='备份文件存储路径' grants=y owner=需备份的用户名
imp 用户名/密码@网络连接名 file='备份文件存放的路径' grants=y ignore=y fromuser=源数据用户名 touser=目标用户名
多表插入
insert all
into a(lastname) values(last_name)
into b(sex) values(sex)
select last_name,sex from employees;
通过select 子查询数据插入表薪水乘以10%
insert into scott.bonus(ename,job,sal)select ename,jop,sal*.10
条件插入多张表
根据汇总金额大小分别插入不同的表
insert all
when sum_orders <1000 then
into small_customers
when sum_orders >=10000 and sum_orders<100000 then
into medium_customers
else
into large_customers
select customer_id,sum(order_total) sum_orders
from oe.orders
group by customer_id