oracle base topic
http://www.itpub.net/thread-225862-1-1.htmlhttp://blog.csdn.net/jingxuewang110/article/details/6804351oracle基础知识
or 多条件
create or replace type t_obj_where as object(typ varchar2(50),val varchar2(50));create or replace type t_tbl_where is table of t_obj_where;create or replace package pkg_where isg_where t_tbl_where := ...
建库的时候
建库的时候如果你的 oracle_sid是小写(如orcl),那么会在$ORACLE_BASE/oradata目录下生成二个文件夹1,orcl/ :用于存储control,redo,system01,sysaux01,undo,user01,temp01等系统...
通过dblink impdp
impdp ctos/www@orcl job_name=ctosimp tables=sc_bits CONTENT=DATA_ONLY network_link="DBLINK_ctos_dev" table_exists_action=truncateimpdp ctos/www@orcl job_name=ctosimp schemas=ctos CONTENT=...
SYS_PLSQL_* TYPE的生成原因
SYS_PLSQL_220788_DUMMY_1 (dummy表示是一个标准的引用)SYS_PLSQL_220788_98_1search keyword: remote type,Pipelined functions,sys_plsql_1,当引用pipelined functions时,且引用的pipelined包含引用了包体变...
oracle core-log file sync-dba enterprise
无私奉献 企业DBA---学生手册 (中文版)体系结构,性能优化http://www.itpub.net/thread-1307822-1-1.html oracle corehttp://www.itpub.net/thread-1807437-2-1.html LOG FILE SYNChttp://www.itp...
ORA-14323: 在 DEFAULT 分区已存在时无法添加分区
有default分区partcur,新增一个V分区alter table er_eir split partition PARTCUR values ('V') into (partition PARTPREVERSION tablespace DBOKEEP,partition PARTCUR) update indexes; 更多请参考offic...
chr(10) chr(13)
Goalhow to identify carriage return and line feed in a table SolutionDepending on the platform, a newline will generally either be a CHR(10) (Unix) or a CHR(13) followed by...
clob更新方法
DECLARE IN_XMLINFO CLOB := '<rowset><row><id>1</id></row></rowset>'; v_Clob CLOB;BEGIN DELETE FROM pl_clob; &nb...
Quest公司提供的PLSQL代码库软件PL/Vision的安装和使用
http://www.itpub.net/forum.php?mod=viewthread&tid=953659pl/vision看看。
使用Partitioned Outer Join实现稠化报表
http://www.itpub.net/thread-1332059-1-46.html Oracle Support for Optional Features of SQL/Foundation:2008 F403, Partitioned join tables Oracle supports this feature, except w...
oracle 前10分钟 后10分钟
SELECT SYSDATE + (ROWNUM - 1) * 10 / 1440 s, ...
xml,some example
http://huangronaldo.iteye.com/blog/1457567some test~ declare v varchar2(2000); v_name varchar2(2000); v_val varchar2(2000); p_cur sys_refcursor; V_XML...
Oracle 11g RAC 的一些基础知识
原文地址:http://www.linuxidc.com/Linux/2011-10/44564.htm http://blog.csdn.net/cangmj0822/article/details/8365138总的来说,Oracle 11g R2 RAC提供了以下功能:高可用:shared-every...
clob处理
如果是很大,则可以考虑:http://yangtingkun.itpub.net/post/468/495918create table PL_CLOB( id INTEGER not null, type VARCHAR2(1) not...
porttunnel
porttunnel端口映射 软件 实现不同网段的互访?
virtualbox
http://www.cnblogs.com/coltiam/archive/2010/03/26/1696939.htmlhttp://blog.csdn.net/venoy4806/article/details/5412467 VBoxManage /?cd C:\Program Files\Sun\VirtualBox--设置端口映射:vbox_rhel5...
Oracle基本数据类型存储格式浅析[zt]
转编写这个函数所根据的规则来自下列文章:Oracle基本数据类型存储格式浅析(一)——字符类型:http://blog.itpub.net/post/468/9287Oracle基本数据类型存储格式浅析(二)——数字类型:http://blog.itpub.ne...
about raw device[zt]
Q: 1. What is a raw device? A:Raw device, also known as a raw partition is a disk partition that is not mounted and written by Linux filesystem (ext2/ext3, reiserfs) or by Oracle Cluster File System (...
密码字段,使用md5加密,字段存储用raw,避免字符集的问题
SELECT DBMS_OBFUSCATION_TOOLKIT.MD5(input => utl_raw.cast_to_raw('tg')) a, DBMS_OBFUSCATION_TOOLKIT.MD5(input => utl_raw.cast_to_raw('123456')) b, &nbs...