oracel 学习

1.insert into EMAIL_INFO (name, Email_Id)
values ('zxlin@dfmc.com.cn', EMAIL_INFO_SEQ.NEXTVAL);

2.oracle导入sql文件：@*.sql

3.备份table
create table 备份表名 as select * from 表名

4.导出数据到excle
main.sql

set linesize 800
set term off verify off feedback off pagesize 999
set markup html on entmap ON spool on preformat off
spool f:\tables.xls
@f:\get_tables.sql
spool off
exit

get_tables.sql
select name from email_info;

执行：@f:\main.sql