Peng Blog
ҽ
л
ҵBlog
¹鵵...
·...
ͳ...
վ...
Դ
===========================================================
oracle11gת
===========================================================
Oracle ݿ 11g Ƴ֮ǰҪÿֵͨʹdecode caseת
ÿֵͬдΪһСǣ÷ǺֱܲҲǺܷ㡣
 鿴ȫ
luckysea :2008.03.21 09:52 ::: ( ORACLE ) ::Ķ:(96) :: (0) :: (0)
===========================================================
oracle11g
===========================================================
ʱоһoracle11gԣʵʿзdz  鿴ȫ
luckysea :2008.03.20 14:40 ::: ( ORACLE ) ::Ķ:(77) :: (0) :: (0)
===========================================================
oracle xml
===========================================================
oracleݿXML  鿴ȫ
luckysea :2007.11.27 10:50 ::: ( ORACLE ) ::Ķ:(232) :: (0) :: (0)
===========================================================
Сһoracle 10g xml֧
===========================================================
죬ԱҪݿXMLԽӦеʵ⣬һָ
Ҳ˵ŵĶɣԱο
 鿴ȫ
luckysea :2007.11.26 14:15 ::: ( ORACLE ) ::Ķ:(252) :: (0) :: (0)
===========================================================
һڿݿûȨ޵
===========================================================

췢һڿݿORACLE10gȨ޷

ûuoaCONNECTRESOURCEɫ

DOSCDB(sys)>conn uoa/uoa@doscdb
ӡ

DOSCDB(uoa)>create view v_test as select * from user_tables;
create view v_test as select * from user_tables
*
1 гִ:
ORA-01031: Ȩ޲

 鿴ȫ
luckysea :2007.11.23 14:12 ::: ( ORACLE ) ::Ķ:(328) :: (2) :: (0)
===========================================================
_kgl_large_heap_warning_threshold
===========================================================
alert.logļܶϢ

Memory Notification: Library Cache Object loaded into SGA
Heap size 2295K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

оoracleBUG
 鿴ȫ
luckysea :2007.11.22 16:38 ::: ( ORACLE ) ::Ķ:(348) :: (0) :: (0)
===========================================================
ݲֿIJҪ
===========================================================
ݲֿIJ裬ݳȡתֲ  鿴ȫ
luckysea :2007.10.16 09:22 ::: ( ݲֿ ) ::Ķ:(229) :: (0) :: (0)
===========================================================
ݲֿݿһЩ
===========================================================

һOLTPϵͳԱôΪģ

ݲֿǴݿ⣬ݲֿ洢ݡ

ʵʶݲֿʵݲֿݿ⣬ֻݲֿеһɲ֡

 鿴ȫ
luckysea :2007.10.16 09:17 ::: ( ݲֿ ) ::Ķ:(125) :: (0) :: (0)
===========================================================
ݲֿЩɣ
===========================================================
ݲֿȻһƷôЩأ 鿴ȫ
luckysea :2007.10.16 09:16 ::: ( ݲֿ ) ::Ķ:(166) :: (0) :: (0)
===========================================================
ʲôݲֿ⣿
===========================================================

һW.H.Lnmon Building the Data Warehouse Third Edition,ͻȻһ⣬Ǿʲôݲֿ⡣һЩϣԼʶ

¶塣

 鿴ȫ
luckysea :2007.10.16 09:08 ::: ( ݲֿ ) ::Ķ:(2212) :: (0) :: (0)
===========================================================
traceļҵtraceļ
===========================================================

һҸļķ

 鿴ȫ
luckysea :2007.09.19 15:06 ::: ( ORACLE ) ::Ķ:(144) :: (0) :: (0)
===========================================================
ݿŻ(2007-9-19)
===========================================================

˾sales˵ǰһϵͳзdzѾһˡͻһҵƽʱ䳬25ӣݿӦʱ䳬24ӡһܷdzݿϵͳ

ŻЧdzԣ

ŻǰͻһҵƽҪ25ӣݿƽӦʱ24

ŻͻһҵƽҪ1ӣݿƽӦʱ2

 鿴ȫ
luckysea :2007.09.19 13:53 ::: ( ORACLE ) ::Ķ:(225) :: (0) :: (0)
===========================================================
SQLSERVERе
===========================================================
ضԺõı׼ַָݽͱȽϵĹ 鿴ȫ
luckysea :2007.09.07 11:40 ::: ( SQLSERVER ) ::Ķ:(190) :: (0) :: (0)
===========================================================
like'%aa'
===========================================================
һַ 鿴ȫ
luckysea :2007.09.07 10:40 ::: ( ORACLE ) ::Ķ:(228) :: (0) :: (0)
===========================================================
ûעdefault
===========================================================

ûõdefault not null

 鿴ȫ

luckysea :2007.09.07 09:59 ::: ( ORACLE ) ::Ķ:(94) :: (0) :: (0)
===========================================================
oracle10g flashback version query
===========================================================

 鿴ȫ
luckysea :2007.08.22 15:31 ::: ( ORACLE ) ::Ķ:(127) :: (0) :: (0)
===========================================================
oracle10g flashback query
===========================================================

 鿴ȫ
luckysea :2007.08.22 15:16 ::: ( ORACLE ) ::Ķ:(122) :: (0) :: (0)
===========================================================
oracle10g flashback drop
===========================================================

flashback drop

 鿴ȫ
luckysea :2007.08.22 15:00 ::: ( ORACLE ) ::Ķ:(138) :: (0) :: (0)
===========================================================
oracle10g flashback database
===========================================================
oracle10gݿԲ 鿴ȫ
luckysea :2007.08.22 14:41 ::: ( ORACLE ) ::Ķ:(165) :: (0) :: (0)
===========================================================
޸ݿַ
===========================================================
޸ݿַ 鿴ȫ
luckysea :2007.08.22 10:58 ::: ( ORACLE ) ::Ķ:(2744) :: (2) :: (0)