xsb Oracle Blog
ҽ
л
ҵBlog
¹鵵...
·...
Ķ...
ͳ...
վ...
Դ
===========================================================
ʹ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 ) ::Ķ:(68) :: (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 ) ::Ķ:(306) :: (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 ) ::Ķ:(317) :: (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 ) ::Ķ:(235) :: (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 ) ::Ķ:(494) :: (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 ) ::Ķ:(544) :: (1) :: (0)
===========================================================
TimesTen
===========================================================

http://www.ttisql.com/

Oracle׼һ汾(2009)TIMESTEN֧PL/SQL֧OCIPRO*Cʱƽ󲿷ûҪĿǰ7.0.5ӹϽȻԴΧռע°汾
xsb :2008.12.22 14:00 ::: ( Oracle ) ::Ķ:(694) :: (4) :: (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 ) ::Ķ:(573) :: (5) :: (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 ) ::Ķ:(514) :: (4) :: (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 ) ::Ķ:(461) :: (0) :: (0)
===========================================================
dbms_utility.compile_schema
===========================================================
±ORACLEݿЧexec dbms_utility.compile_schema('TEST',false,false);
xsb :2008.12.08 09:54 ::: ( Oracle ) ::Ķ:(379) :: (1) :: (0)
===========================================================
dbms_utility.comma_to_table[zt]
===========================================================

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

 鿴ȫ

xsb :2008.12.08 09:36 ::: ( Oracle ) ::Ķ:(330) :: (0) :: (0)
===========================================================
Oracle 11g:Result Cache֮һ[zt]
===========================================================

Oracle Database 11gУOracleһ˹עԣ棨Result Cache
һResult CacheֿԷΪServer Result Cache Client Result Cache
ǰͨSGAͨͻ
Ref:

Oracle 11g:Server Result Cache[zt]
Ref:

Oracle11g-PLSQLһ[zt]

 鿴ȫ
xsb :2008.12.04 16:23 ::: ( Oracle ) ::Ķ:(325) :: (0) :: (0)
===========================================================
sqlplusspoolɴڵļ
===========================================================
sqlplusspoolɴڵļ
col spf new_value spf noprint
select 'd:'||to_char(sysdate,'yyyymmdd')||'.txt' spf from dual;
spo &spf

select * from dual;
spo off;
 鿴ȫ
xsb :2008.09.05 09:19 ::: ( Oracle ) ::Ķ:(827) :: (0) :: (0)
===========================================================
10gбstatistics_level
===========================================================

10g֮ǰİ汾,dbms_statsALTER_DATABASE/SCHEMA_TAB_MONITORING̻create/alter table ... monitoring򿪱ļ,10g,MONITORINGNOMONITORINGؼѾʱ,create/alter tableָļػȡ,ùؼֽ,statistics_level,statistics_levelbasicʱ,ֹļ,typicalallʱ,Ǽ.

 鿴ȫ

xsb :2008.08.25 14:10 ::: ( Oracle ) ::Ķ:(623) :: (0) :: (0)
===========================================================
رռoracle10gͳϢԶռ
===========================================================

ֱַ£һ
SYSDBA¼
exec dbms_scheduler.disable('SYS.GATHER_STATS_JOB');
exec dbms_scheduler.enable('SYS.GATHER_STATS_JOB');

alter system set "_optimizer_autostats_job"=false scope=spfile;
alter system set "_optimizer_autostats_job"=true scope=spfile;

Pfileֱ޸ijʼļ
Ȼ
ݿ⡣


xsb :2008.07.25 14:28 ::: ( Oracle ) ::Ķ:(543) :: (0) :: (0)
===========================================================
Oracle10G EM dbcontrol
===========================================================

emca -config dbcontrol db -repos create
emca -deconfig dbcontrol db -repos drop
emctl status dbconsole

 鿴ȫ

xsb :2008.07.18 22:38 ::: ( Oracle ) ::Ķ:(372) :: (0) :: (0)
===========================================================
ora11g install on ora_eLinux5u2
===========================================================

oraLinux5U2°װORACLE11G.

 鿴ȫ

xsb :2008.07.18 19:15 ::: ( Oracle ) ::Ķ:(375) :: (3) :: (0)
===========================================================
ora10g install on RHAS4
===========================================================

ora10g install on RHAS4 step by step .

 鿴ȫ
xsb :2008.07.18 19:12 ::: ( Oracle ) ::Ķ:(317) :: (0) :: (0)
===========================================================
Sql Server 2005T-sql
===========================================================

Sql Server 2005T-sqlhttp://whx.tzgt.gov.cn/newOperate/html/3/31/313/2138.html

 鿴ȫ
xsb :2008.07.15 11:50 ::: ( SQLserver ) ::Ķ:(349) :: (0) :: (0)