xsb Oracle Blog
ҽ
л
ҵBlog
¹鵵...
·...
Ķ...
ͳ...
վ...
Դ
===========================================================
goldengateOracle RAC
===========================================================

RACаװGoldenGate齫䰲װڹ洢УһڵGoldenGatẹڵʧܣһڵ޸IJΪ㱣ڰװĿ¼С
RACеҪִGoldenGate̵Ľڵͬϵͳʱ䣬ΪGoldenGateͨȽϱϵͳʱύʱؼߡ

 鿴ȫ

xsb :2012.04.01 15:18 ::: ( Oracle ) ::Ķ:(269) :: (0) :: (0)
===========================================================
oracle yangtingkun BLOG [zt]
===========================================================

http://www.itpub.net/699527.html#


xsb :2011.05.18 17:15 ::: ( Oracle ) ::Ķ:(328) :: (0) :: (0)
===========================================================
Oracle RAC TAF [zt]
===========================================================
OracleRACĸ߿ùܳ˸ؾ⻹TAFTransparent Application Failover
RACTAFָỰӵһʵϣʵ˹ϣOracleԶỰǨƵһʵϡ
 鿴ȫ
xsb :2011.05.04 17:48 ::: ( Oracle ) ::Ķ:(438) :: (0) :: (0)
===========================================================
oracle10gdynamic sampling
===========================================================

dynamic samplingҪoracleܣʹõΪȷִмƻoracleͨoptimizer_dynamic_samplingʵֶ̬9idynamic samplingҪڶŻá10goptimizer_dynamic_sampling2ϼʱdynamic sampling

 鿴ȫ

xsb :2011.01.18 09:36 ::: ( Oracle ) ::Ķ:(541) :: (0) :: (0)
===========================================================
Oracle11gԣSQL Result Cache [zt]
===========================================================

DB_BUFFERֻܻʹBLOCKֽ⣬ѯȻҪ߼

ﻯͼṩDzѯдĹܣڴ󲿷ֵֻǼSQLĸӶȣʹȫѯﻯͼɨҲDzɱġ

RESULT CACHEȻͬDzѯĽҪ߼ҪκεĸӼ㣬ֱӽѾĽء

 鿴ȫ
xsb :2011.01.17 13:48 ::: ( Oracle ) ::Ķ:(565) :: (0) :: (0)
===========================================================
Oracle10gת wmsys.wm_concat
===========================================================
SELECT deptno, wmsys.wm_concat(empno || ename) FROM scott.emp GROUP BY deptno;

xsb :2011.01.13 10:26 ::: ( Oracle ) ::Ķ:(561) :: (0) :: (0)
===========================================================
REMOTE_LOGIN_PASSWORDFILE[zt]
===========================================================

REMOTE_LOGIN_PASSWORDFILEȡֵͬʱΪԡ
REMOTE_LOGIN_PASSWORDFILEȡֵEXCLUSIVEĬϣNONESHARED

 鿴ȫ
xsb :2011.01.07 13:46 ::: ( Oracle ) ::Ķ:(644) :: (0) :: (0)
===========================================================
ʱ֮תʱʽ
===========================================================
WITH a AS
(SELECT to_timestamp('2010-7-7 11:11:11', 'yyyy-mm-dd hh24:mi:ss') - to_timestamp('2010-7-5 12:12:12', 'yyyy-mm-dd hh24:mi:ss') inter
FROM dual)
SELECT inter, extract(DAY FROM inter), extract(hour FROM inter), extract(minute FROM inter), extract(SECOND FROM inter) FROM a;
ο
http://xsb.itpub.net/post/419/52334
xsb :2010.07.06 13:18 ::: ( Oracle ) ::Ķ:(1076) :: (0) :: (0)
===========================================================
ʹutl_httpȡijhttpҳ
===========================================================

set head off
set feed off
set termout off
set serveroutput on
spool d:test.html

DECLARE
req utl_http.req;
resp utl_http.resp;
VALUE VARCHAR2(4000);

 鿴ȫ
xsb :2010.01.05 16:45 ::: ( Oracle ) ::Ķ:(861) :: (0) :: (0)
===========================================================
to_charȡ㷨
===========================================================

ļ£
㷨һiw㷨ΪһһܣÿĵһһΪһ
IW = Week of year (1-52 or 1-53) based on the ISO standard
SQLȡֵǣ
SELECT to_char(SYSDATE, 'iw') FROM dual;
עĵطһ굱е52ܱ֮1231֮䣬дڻ4ĻΪĵ53ܣʣЩΪһĵ1ܣڲ52ܱĻһʱ
20090101ģһһ20090105ǵһһѾǵڶ!
ܸӣ

㷨ww㷨Ϊÿ11Ϊĵһܵĵһ죨ܵ11ڼ
WW = Week of year (1-53) where week 1 starts on the first day of the year and continues to the seventh day of the year.
SQLȡֵǣ
SELECT to_char(SYSDATE, 'ww') FROM dual;
㷨ϰҲͬ㷨ܼ򵥣ԱͨΪϰߵȻ㷨(һܺһܿܲ7)

 鿴ȫ

xsb :2009.09.27 14:41 ::: ( Oracle ) ::Ķ:(1415) :: (0) :: (0)
===========================================================
ҵprocedurereferenceĶ
===========================================================

ѯuser_dependenciesԡ磺

select * from user_dependencies where name ='P_AUTO_DROP_OTHERDATA' and referenced_type='TABLE' order by referenced_name;


xsb :2009.04.03 11:19 ::: ( Oracle ) ::Ķ:(862) :: (1) :: (0)
===========================================================
profiler
===========================================================

CONNECT sys/password@service AS SYSDBA
@$ORACLE_HOME/rdbms/admin/profload.sql

CONNECT profiler/profiler@service
@$ORACLE_HOME/rdbms/admin/proftab.sql


xsb :2009.02.20 16:43 ::: ( Oracle ) ::Ķ:(666) :: (0) :: (0)
===========================================================
Oracle11g RMAN Duplicate from Active Database
===========================================================

RmanduplicateԺܷĽԭ⸴Ƴһ¿⣬data guardӦзdzáOracle11g֮ǰִduplicateҪȶԭrmanбݣȻ󽫱ݸƵƿ⣬ͬʱԭ(Ϊtarget)͸ƿ(Ϊauxiliary)ִduplicateиơOracle11gƳactive database duplicateԣʡ˽rmanݵIJ裬ֱܹӴԭ⸴Ƴ¿⣬һЩ͵ݿ˵ԿԽʡܶʱ䡣Ľ򵥵ʾһ²(ͬһִduplicate)

 鿴ȫ

xsb :2009.01.06 13:58 ::: ( Oracle ) ::Ķ:(1319) :: (0) :: (0)
===========================================================
oracle11g pivot ת SQL Server 2005
===========================================================
Oracle ݿ 11g Ƴ֮ǰҪÿֵͨʹdecode caseת
ÿֵͬдΪһСǣ÷ǺֱܲҲǺܷ㡣
oracle11gʹһֺܺõPIVOTUNPIVOT,ͨһµIJԽʽʾκβѯ
oracleΪʵָǿݲֿӦãSQLPL/SQLкܴļǿ

SQL Server2005˺ܶӭϿ߿ζԣȻĶȴ˼˿ߵĹûǵĿ˼·ֵóޡ

 鿴ȫ
xsb :2009.01.06 13:42 ::: ( Oracle ) ::Ķ:(1762) :: (1) :: (0)
===========================================================
TimesTen
===========================================================

http://www.ttisql.com/

Oracle׼һ汾(2009)TIMESTEN֧PL/SQL֧OCIPRO*Cʱƽ󲿷ûҪĿǰ7.0.5ӹϽȻԴΧռע°汾
xsb :2008.12.22 14:00 ::: ( Oracle ) ::Ķ:(1257) :: (0) :: (0)
===========================================================
oracle develop 2008 APEX & SQL developer
===========================================================

20081210--11գ׹Ŀߴ2008½й׹ܲMichael HichwañOracleݿӦó򿪷ٿᣬƹݿӦó򿪷ߡ

򿪷ƷֱΪOracle SQL DeveloperOracle Application ExpressƷĿǰΪṩûʹõģĿǼʹOracleݿ⿪ӦóḶ́ݿӦóĿЧʡƷһƳͱܳԱOracleݿʹǵݳȫѾʹ

 鿴ȫ
xsb :2008.12.13 15:33 ::: ( Oracle ) ::Ķ:(1192) :: (0) :: (0)
===========================================================
APEX installation
===========================================================
  • Oracle RDBMS 10.2.0.3.0 (Enterprise Edition) and/of higher version
  • APEX 3.1.2
  • Windows 2003 / XP
 鿴ȫ
xsb :2008.12.12 22:14 ::: ( Oracle ) ::Ķ:(911) :: (0) :: (0)
===========================================================
forall bulk collect
===========================================================

󶨣Bulk bindsͨPL/SQLSQL֮л(context switches ).
󶨣Bulk binds
(i) Input collections, use the FORALL statementһDMLINSERTUPDATEDELETE)
(ii) Output collections, use BULK COLLECT clauseһ߲ѯSELECT
10gʼforallʹַʽ
i in low..up
i in indices of collection ȡüԪ±ֵ
i in values of collection ȡüԪصֵ
forall仹ʹòּԪ

sql%bulk_rowcount(i)ʾforalliԪõ

 鿴ȫ

xsb :2008.12.09 14:29 ::: ( Oracle ) ::Ķ:(950) :: (0) :: (0)
===========================================================
dbms_utility.compile_schema
===========================================================
±ORACLEݿЧexec dbms_utility.compile_schema('TEST',false,false);
xsb :2008.12.08 09:54 ::: ( Oracle ) ::Ķ:(1013) :: (0) :: (0)
===========================================================
dbms_utility.comma_to_table[zt]
===========================================================

ŷַָ(עܺ)תpl/sqlʽ

 鿴ȫ

xsb :2008.12.08 09:36 ::: ( Oracle ) ::Ķ:(929) :: (0) :: (0)