烂锅烂铁

查看表创建时间 select ao.* from ALL_OBJECTS ao where OBJECT_NAME = 'MODULE' and OBJECT_TyPE = 'TABLE'; select * from user_tables; select username,count(user...

--插入bfile­ create or replace procedure insert_book(filename varchar2) as ­ book_file bfile := NULL;­ bookExists boolean := false;­ begin­ book_file := bfilename('BOOK_TEXT', filename)...

http://hi.baidu.com/superyhao/blog/item/7adc76f43c3511daf3d385d8.html­ 1、启动数据库：­ oracle@suse92:~> sqlplus /nolog­ SQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006­ Copyri...

(一) ­ 1、查找表中多余的重复记录，重复记录是根据单个字段（peopleId）来判断 ­ select * from people ­ where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) ­ ­ 2、删除表中多余的重复记录，...