資料庫表標識

Ⅰ oracle鏁版嵁搴撴垜鐢≒L/SQL寤鴻〃鏈変簺瀛楁電殑鏍囪瘑鎴戠湅涓嶆噦.楹葷儲瑙ｉ噴涓涓!

binary_double 鍙岀簿搴64浣
binary_float 鍙岀簿搴32浣
blob,clob錛宯clob 涓夌嶅ぇ鍨嬪硅薄(LOB)錛岀敤鏉ヤ繚瀛樿緝澶х殑鍥懼艦鏂囦歡鎴栧甫鏍煎紡鐨勬枃鏈鏂囦歡錛屽侻iceosoft Word鏂囨。錛屼互鍙婇煶棰戙佽嗛戠瓑闈炴枃鏈鏂囦歡錛屾渶澶ч暱搴︽槸4GB銆侺OB鏈夊嚑縐嶇被鍨嬶紝鍙栧喅浜庝綘浣跨敤鐨勫瓧鑺傜殑綾誨瀷錛孫racle 8i瀹炲疄鍦ㄥ湪鍦板皢榪欎簺鏁版嵁瀛樺偍鍦ㄦ暟鎹搴撳唴閮ㄤ繚瀛樸
鍙浠ユ墽琛岃誨彇銆佸瓨鍌ㄣ佸啓鍏ョ瓑鐗規畩鎿嶄綔銆
interval day to second,interval year to month 綾誨瀷瀛樺偍涓や釜TIMESTAMP涔嬮棿鐨勬椂闂村樊寮,縐掞紝鏈
long 鍙鍙橀暱瀛楃﹀垪錛屾渶澶ч暱搴﹂檺鍒舵槸2GB錛岀敤浜庝笉闇瑕佷綔瀛楃︿覆鎼滅儲鐨勯暱涓叉暟鎹錛屽傛灉瑕佽繘琛屽瓧絎︽悳緔㈠氨瑕佺敤varchar2綾誨瀷銆
timestamp 鏃墮棿鎴籌紝姣攄ate鏇寸簿紜
timestamp with time zone 錛宼imestamp with local time zone 鏃墮棿鎴籌紙鏃跺尯涓嶄竴鏍鳳級
number 鏁板瓧鍨

鍥炵瓟瀹屾瘯