![](https://img-blog.csdnimg.cn/20201014180756925.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
DB
iteye_13152
这个作者很懒,什么都没留下…
展开
-
ORACLE 的一些操作
查看表创建时间select ao.* from ALL_OBJECTS ao where OBJECT_NAME = 'MODULE' and OBJECT_TyPE = 'TABLE';select * from user_tables;select username,count(user...原创 2010-11-09 23:10:57 · 68 阅读 · 0 评论 -
oracle blob clob flob操作
--插入bfilecreate or replace procedure insert_book(filename varchar2) as book_file bfile := NULL;bookExists boolean := false;beginbook_file := bfilename('BOOK_TEXT', filename)...原创 2010-11-09 23:12:44 · 119 阅读 · 0 评论 -
linux下oracle数据库服务和监听的启动停止
http://hi.baidu.com/superyhao/blog/item/7adc76f43c3511daf3d385d8.html1、启动数据库:oracle@suse92:~> sqlplus /nologSQL*Plus: Release 9.2.0.4.0 - Production on Fri Jan 20 02:29:37 2006Copyri...原创 2010-11-09 23:14:19 · 97 阅读 · 0 评论 -
ORACLE查询及删除重复记录的方法
(一) 1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断 select * from people where peopleId in (select peopleId from people group by peopleId having count(peopleId) > 1) 2、删除表中多余的重复记录,...原创 2010-11-09 23:19:27 · 86 阅读 · 0 评论