catherine的心路历程

版权声明：转载时请以超链接形式标明文章原始出处和作者信息及本声明
http://wanping.blogbus.com/logs/38469630.html

1、统计记录个数

select count(*) from tablename

2、查看表记录

select * from tablename

3、向表中插入记录

insert into tablename(ID,NAME,ADDRESS,PRICE,SCORE,DATA)

values(1,'luckystaff','beijing',30,90,to_date('25-0402009 14:00:00','dd-mm-yyyy hh24:mi:ss'));

4、向表中插入大量数据

begin
for i in 1.. 30000000 loop
insert into tablename

select  i,'菁菁测试'||i,'北京',30,90,sysdate
from dual;
end loop;
commit;
end;

5、删除表中所有数据

Truncate table tablename