註:若有些activex 元件也會跟著移除,需手動再安裝回來
- 12月 06 週五 201317:42
IE8 在開啟某網頁後、經閃爍後立即關閉的解決方式
註:若有些activex 元件也會跟著移除,需手動再安裝回來
- 4月 29 週一 201321:17
2013_04_28馬沙溝沙雕展
聽好車後,沙雕展就在眼前
這算沙雕展的LOGO 右下角還有QR CODE- 4月 09 週二 201310:22
如何於skype阻擋msn廣告訊息

SKYPE惱人的廣告spam,如下圖,因為我是雙帳號skype+msn 所以如下圖由圖示看來,是由Msn發來的 而且每次來的名稱都不一樣,氣很久了,今天找到方法了。 阻擋步驟: 1.如下圖輸入一些訊息
- 3月 10 週日 201315:20
Windows 7 Home Premium 如何開啟遠端桌面服務
- 1月 08 週二 201300:40
acer 6930G NB 破音的解決紀錄

這台NB OS windows7,有時候會破音,有時候又不會,已到acer下載這台型號最新的音效卡驅動程式了 但是還是偶而有此狀況,這個偶而還真抓不出他的頻率。 今天又發生了,老子跟你拚了,紀錄一下 只要是有圖形介面的撥放音樂就會破音,連media player的 波形音浪顯示也會,更不用說用media player或其他撥放軟體看電影之類了。
- 11月 06 週二 201213:37
ORACLE 如何 WHERE CLOB欄位 是否符合某個值?

DBMS_LOB.INSTR()函數,就是這次的主角。請看下面範例:CREATE TABLE X3
( CLOB_TEXT CLOB);
Insert into X3
(CLOB_TEXT)
Values
('測試一下);
Insert into X3
(CLOB_TEXT)
Values
('');
COMMIT;
select * from x3
where DBMS_LOB.INSTR(clob_text,'測',1,1)>0;
- 11月 01 週四 201216:03
Oracle 10g Export Data from command
Original Export Parameter
Comparable Data Pump Export Parameter
BUFFER
A parameter comparable to BUFFER is not needed.
COMPRESS
A parameter comparable to COMPRESS is not needed.
CONSISTENT
A parameter comparable to CONSISTENT is not needed. Use FLASHBACK_SCN and FLASHBACK_TIME for this functionality.
CONSTRAINTS
EXCLUDE=CONSTRAINT
DIRECT
A parameter comparable to DIRECT is not needed. Data Pump Export automatically chooses the best method (direct path mode or external tables mode).
FEEDBACK
STATUS
FILE
DUMPFILE
FILESIZE
FILESIZE
FLASHBACK_SCN
FLASHBACK_SCN
FLASHBACK_TIME
FLASHBACK_TIME
FULL
FULL
GRANTS
EXCLUDE=GRANT
HELP
HELP
INDEXES
EXCLUDE=INDEX
LOG
LOGFILE
OBJECT_CONSISTENT
A parameter comparable to OBJECT_CONSISTENT is not needed.
OWNER
SCHEMAS
PARFILE
PARFILE
QUERY
QUERY
RECORDLENGTH
A parameter comparable to RECORDLENGTH is not needed because sizing is done automatically.
RESUMABLE
A parameter comparable to RESUMABLE is not needed. This functionality is automatically provided for privileged users.
RESUMABLE_NAME
A parameter comparable to RESUMABLE_NAME is not needed. This functionality is automatically provided for privileged users.
RESUMABLE_TIMEOUT
A parameter comparable to RESUMABLE_TIMEOUT is not needed. This functionality is automatically provided for privileged users.
ROWS=N
CONTENT=METADATA_ONLY
ROWS=Y
CONTENT=ALL
STATISTICS
A parameter comparable to STATISTICS is not needed. Statistics are always saved for tables.
TABLES
TABLES
TABLESPACES
TABLESPACES (Same parameter; slightly different behavior)
TRANSPORT_TABLESPACE
TRANSPORT_TABLESPACES (Same parameter; slightly different behavior)
TRIGGERS
EXCLUDE=TRIGGER
TTS_FULL_CHECK
TRANSPORT_FULL_CHECK
USERID
A parameter comparable to USERID is not needed. This information is supplied as the username/password when you invoke Export.
VOLSIZE
A parameter comparable to VOLSIZE is not needed.
- 11月 01 週四 201216:00
Oracle 10g IMPORT Data from command
發現Oracle offical 網站:Chapter 3, "Data Pump Import",介紹的很好,有新舊版指令對照,及一些參數的介紹跟範例,以下是自已截錄出來的重點,若有更詳細的還需要至上述網站查,不過都是原文的。 參數:TABLE_EXISTS_ACTION
這個參數當匯入時遇到table 已經存在了,該怎麼處理的參數,有四項:
TABLE_EXISTS_ACTION={SKIP | APPEND | TRUNCATE | REPLACE}
是舊版IGRONE的取代加強版,預設為SKIP SKIP
若是Table存在,則不匯入,跳至下個需處理的物件去處理.
若有CONTENT=DATA_ONLY參數,則此參數是無效的
- 11月 01 週四 201215:57
Oracle 10g Export Data from command
Original Export Parameter
Comparable Data Pump Export Parameter
BUFFER
A parameter comparable to BUFFER is not needed.
COMPRESS
A parameter comparable to COMPRESS is not needed.
CONSISTENT
A parameter comparable to CONSISTENT is not needed. Use FLASHBACK_SCN and FLASHBACK_TIME for this functionality.
CONSTRAINTS
EXCLUDE=CONSTRAINT
DIRECT
A parameter comparable to DIRECT is not needed. Data Pump Export automatically chooses the best method (direct path mode or external tables mode).
FEEDBACK
STATUS
FILE
DUMPFILE
FILESIZE
FILESIZE
FLASHBACK_SCN
FLASHBACK_SCN
FLASHBACK_TIME
FLASHBACK_TIME
FULL
FULL
GRANTS
EXCLUDE=GRANT
HELP
HELP
INDEXES
EXCLUDE=INDEX
LOG
LOGFILE
OBJECT_CONSISTENT
A parameter comparable to OBJECT_CONSISTENT is not needed.
OWNER
SCHEMAS
PARFILE
PARFILE
QUERY
QUERY
RECORDLENGTH
A parameter comparable to RECORDLENGTH is not needed because sizing is done automatically.
RESUMABLE
A parameter comparable to RESUMABLE is not needed. This functionality is automatically provided for privileged users.
RESUMABLE_NAME
A parameter comparable to RESUMABLE_NAME is not needed. This functionality is automatically provided for privileged users.
RESUMABLE_TIMEOUT
A parameter comparable to RESUMABLE_TIMEOUT is not needed. This functionality is automatically provided for privileged users.
ROWS=N
CONTENT=METADATA_ONLY
ROWS=Y
CONTENT=ALL
STATISTICS
A parameter comparable to STATISTICS is not needed. Statistics are always saved for tables.
TABLES
TABLES
TABLESPACES
TABLESPACES (Same parameter; slightly different behavior)
TRANSPORT_TABLESPACE
TRANSPORT_TABLESPACES (Same parameter; slightly different behavior)
TRIGGERS
EXCLUDE=TRIGGER
TTS_FULL_CHECK
TRANSPORT_FULL_CHECK
USERID
A parameter comparable to USERID is not needed. This information is supplied as the username/password when you invoke Export.
VOLSIZE
A parameter comparable to VOLSIZE is not needed.
- 6月 05 週二 201211:26
如何開機後自動執行virtual box 與vmware wk?

利用bat檔放到啟動的方式。 bat內容如下
:VM1 @echo 30秒後開啟vm-DB 請稍候.... @PING 1.1.1.1 -n 1 -w 30000 c:
