尊龙凯时人生就是博

oracleÖÐintegerÓ÷¨

oracle ÖÐµÄ integer Êý¾ÝÀàÐÍÓÃÓÚ´æ´¢½éÓÚ -2,147,483,648 µ½ 2,147,483,647 Ö®¼äµÄÕûÊý¡£Ö÷ÒªÓÃÓÚ´æ´¢ÕûÊý±êʶ·û¡¢¼ÆÊýÆ÷ºÍ״̬±ê¼Ç¡£Ðè×¢ÖØ£¬¸ÃÊý¾ÝÀàÐͲ»¿É´æ´¢Ð¡Êý»ò¸ºÊý£¬ÇÒ´æ´¢¿Õ¼äÀο¿¡£

Oracle ÖÐ INTEGER Êý¾ÝÀàÐ͵ÄÓ÷¨

INTEGER ÊÇ Oracle ÖÐÓÃÓÚ´æ´¢ÕûÊýµÄÊý¾ÝÀàÐÍ¡£Ëü¿ÉÒÔ´æ´¢½éÓÚ -2,147,483,648 µ½ 2,147,483,647 Ö®¼äµÄÕûÊý¡£

Óï·¨

INTEGER [precision]

µÇ¼ºó¸´ÖÆ

ÆäÖУº

precision ÊÇ¿ÉÑ¡µÄ£¬Ö¸¶¨ INTEGER ´æ´¢µÄλÊý¡£¹æģΪ 1 µ½ 38¡£²»Ö¸×¼Ê±Ä¬ÒÔΪ 32 λ¡£

Ó÷¨

INTEGER Êý¾ÝÀàÐÍÖ÷ÒªÓÃÓÚ´æ´¢ÕûÊý£¬ÀýÈ磺

±êʶ·û£¨Èç¿Í»§ ID£©

¼ÆÊýÆ÷£¨È綩µ¥ÊýÄ¿£©

״̬±ê¼Ç£¨ÈçÒѼ¤»î/ÒѽûÓã©

ÐèҪעÖصÄÊÂÏî

INTEGER ²»¿É´æ´¢Ð¡Êý»ò¸ºÊý¡£

INTEGER µÄ´æ´¢¿Õ¼äÊÇÀο¿µÄ£¬Òò´ËËü²»Êʺϴ洢¿ÉÄÜÔöÌíµ½ºÜÊÇ´óµÄÊý×Ö¡£

ÈôÊÇ´æ´¢ÔÚ INTEGER ÖеÄÊý×ÖÁè¼ÝÆä¹æÄ££¬Ôò»á±¬·¢Òç³ö»òÏÂÒç¹ýʧ¡£

ʾÀý

-- ½¨ÉèÒ»¸öÃûΪ "customer_id" µÄ INTEGER ÁÐ
CREATE TABLE customers (
  customer_id INTEGER NOT NULL
);

-- ²åÈëÒ»¸öÊý×Öµ½ "customer_id" ÁÐ
INSERT INTO customers (customer_id) VALUES (12345);

-- ¼ìË÷ "customer_id" ÁÐÖеÄÊý×Ö
SELECT customer_id FROM customers;

µÇ¼ºó¸´ÖÆ

Êä³ö£º

12345

µÇ¼ºó¸´ÖÆ

ÒÔÉϾÍÊÇoracleÖÐintegerÓ÷¨µÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡

ÃâÔð˵Ã÷£ºÒÔÉÏչʾÄÚÈÝȪԴÓÚÏàÖúýÌå¡¢ÆóÒµ»ú¹¹¡¢ÍøÓÑÌṩ»òÍøÂçÍøÂçÕûÀí£¬°æȨÕùÒéÓë±¾Õ¾Î޹أ¬ÎÄÕÂÉæ¼°¿´·¨Óë¿´·¨²»´ú±í尊龙凯时人生就是博ÂËÓÍ»úÍø¹Ù·½Ì¬¶È£¬Çë¶ÁÕß½ö×ö²Î¿¼¡£±¾ÎĽӴýתÔØ£¬×ªÔØÇë˵Ã÷À´ÓÉ¡£ÈôÄúÒÔΪ±¾ÎÄÇÖÕ¼ÁËÄúµÄ°æȨÐÅÏ¢£¬»òÄú·¢Ã÷¸ÃÄÚÈÝÓÐÈκÎÉæ¼°ÓÐÎ¥¹«µÂ¡¢Ã°·¸Ö´·¨µÈÎ¥·¨ÐÅÏ¢£¬ÇëÄúÁ¬Ã¦ÁªÏµ尊龙凯时人生就是博ʵʱÐÞÕý»òɾ³ý¡£

Ïà¹ØÐÂÎÅ

ÁªÏµ尊龙凯时人生就是博

13452372176

¿É΢ÐÅÔÚÏß×Éѯ

ÊÂÇéʱ¼ä£ºÖÜÒ»ÖÁÖÜÎ壬9:30-18:30£¬½ÚãåÈÕÐÝÏ¢

QR code
sitemap¡¢ÍøÕ¾µØͼ