ITPub博客

http://www.itpub.net/thread-225862-1-1.htmlhttp://blog.csdn.net/jingxuewang110/article/details/6804351oracle基础知识

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等系统...

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_220788_DUMMY_1　(dummy表示是一个标准的引用)SYS_PLSQL_220788_98_1search keyword: remote type,Pipelined functions,sys_plsql_１，当引用pipelined functions时，且引用的pipelined包含引用了包体变...

无私奉献 企业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...

有default分区partcur，新增一个Ｖ分区alter table er_eir split partition PARTCUR values ('V') into (partition PARTPREVERSION tablespace DBOKEEP,partition PARTCUR) update indexes; 更多请参考offic...

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...

DECLARE    IN_XMLINFO CLOB := '<rowset><row><id>1</id></row></rowset>';    v_Clob     CLOB;BEGIN    DELETE FROM pl_clob;  &nb...

http://www.itpub.net/forum.php?mod=viewthread&tid=953659pl/vision看看。

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...

SELECT SYSDATE + (ROWNUM - 1) * 10 / 1440 s,                          ...

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...

原文地址：http://www.linuxidc.com/Linux/2011-10/44564.htm http://blog.csdn.net/cangmj0822/article/details/8365138总的来说，Oracle 11g R2  RAC提供了以下功能：高可用：shared-every...

 如果是很大，则可以考虑：http://yangtingkun.itpub.net/post/468/495918create table PL_CLOB(  id      INTEGER not null,  type    VARCHAR2(1) not...

porttunnel端口映射 软件 实现不同网段的互访？

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基本数据类型存储格式浅析（一）——字符类型：http://blog.itpub.net/post/468/9287Oracle基本数据类型存储格式浅析（二）——数字类型：http://blog.itpub.ne...

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 (...

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...