数据库表标识

Ⅰ 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 鏁板瓧鍨

锲炵瓟瀹屾瘯