讓我聽聽你的聲音
讓我聽聽你的聲音聽你心裏的每個跳動那稀鬆平常的一些點點滴滴在此刻加深讓我看看你的眼睛在你的額頭輕輕吻著這雖然是最平常的一個舉動再一次也不厭倦誰令我心跳加速當我擁抱著你那一絲一絲心裏的悸動你應該能感覺得到是誰令我心跳加速當我擁抱著你那一絲一絲甜蜜的微笑牽動著嘴角[@more@]
曲终人散尽,江上数青峰
"曲终人散尽,江上数青峰”。曲终了,人散了,然而青峰依在,朗朗乾坤,或許物換星移,没有转移的是你我依然還在,不变的是你我曾經的點點滴滴, 生活仍将继续,讓大家彼此祝福吧[@more@]
Oracle Query processing 的程序
Oracle Query processing 的程序當一個查詢statement送出時,他的執行程序為:(from Jonathan Lewis web site) Perform syntax check Perform semantic check Perform hash function Perform library cache lookup If hash value found then .....If command is identical to existing one in cache then ..........If the objects referenced in the cached command are the same as the ones in the new command then ...............This is a soft parse, go to step 11 This is a hard parse, build parse tree --> (parse 程序)
using escape character whitin oracle
Oracle allows the assignment of special escape characters to tell Oracle that the character is interpreted literally. Certain characters such as the underscore “_” are not interpreted literally because they have special meaning within Oracle.In the example below, we want to find all Oracle parameter that relate to I/O, so we are tempted to use the filter LIKE “%_io_%’. Below we will select from the x$ksppi fixed table, filtering with the LIKE clause:SQL> select ksppinm from x$ksppi whe