³õʶoracleÖеÄË÷Òý×éÖ¯±í
Ë÷Òý×éÖ¯±í£¨IOT£©ÓÐÒ»ÖÖÀàBÊ÷µÄ´æ´¢×éÖ¯·½·¨¡£ÆÕͨµÄ¶Ñ×éÖ¯±íÊÇÒÔÒ»ÖÖÎÞÐòµÄ¼¯ºÏ´æ´¢¡£¶øIOTÖеÄÊý¾ÝÊÇ°´Ö÷¼üÓÐÐòµÄ´æ´¢ÔÚBÊ÷Ë÷Òý½á¹¹ÖС£ÓëÒ»°ãBÊ÷Ë÷Òý²»Í¬µÄµÄÊÇ£¬ÔÚIOTÖÐÿ¸öÒ¶½áµã¼´ÓÐÿÐеÄÖ÷¼üÁÐÖµ£¬ÓÖÓÐÄÇЩ·ÇÖ÷¼üÁÐÖµ¡£
ÈçÏÂͼËùʾ£¬ÔÚIOTËù¶ÔÓ¦µÄBÊ÷½á¹¹ÖУ¬Ã¿¸öË÷ÒýÏî°üÀ¨<Ö÷¼üÁÐÖµ£¬·ÇÖ÷¼üÁÐÖµ>¶ø²»ÊÇROWID£¬¶ÔÓÚÆÕͨ¶Ñ×éÖ¯±í£¬oracle»áÓжÔÓ¦µÄË÷ÒýÓëÖ®¶ÔÓ¦£¬ÇÒ·Ö¿ª´æ´¢¡£»»¾ä»°Ëµ£¬IOT¼´ÊÇË÷Òý£¬ÓÖÊÇʵ¼ÊµÄÊý¾Ý¡£
ÆÕͨ±íË÷ÒýÓë±íÊý¾ÝµÄ¶ÔÓ¦¹Øϵ
IOTµÄË÷ÒýÏîºÍ±íÊý¾ÝµÄ¶ÔÓ¦¹Øϵ
IOTºÍÆÕͨ±í¶ÔÓÚÓ¦ÓóÌÐòÀ´Ëµ£¬ÀýÈçsql²éѯÓï¾ä£¬ÊÇûÓÐÇø±ðµÄ¡£Ò²¾ÍÊÇ˵oracleÖжԱíµÄ×éÖ¯ÐÎʽ¶ÔÓ¦ÓÃÀ´ËµÊÇ͸Ã÷µÄ¡£
ϱí×ܽáÁËIOTÓëÒ»°ã±íµÄÇø±ð£º
ÆÕͨ±í
IOT
ROWIDΨһȷ¶¨Ò»Ðм
Ö÷¼üΨһȷ¶¨Ò»ÐмǼ
¿ÉÒÔ²»Ö¸¶¨Ö÷¼ü
±ØÐëÖ¸¶¨Ö÷¼ü
ROWIDαÁÐÖб£´æÎïÀírowid£¬¿ÉÒÔ¹¹½¨¶þ¼¶Ë÷Òý
ROWIDαÁÐÖб£´æÂß¼rowid£¬¿ÉÒÔ¹¹½¨¶þ¼¶Ë÷Òý
»ùÓÚrowid½øÐзÃÎÊ
»ùÓÚÂß¼rowid½øÐзÃÎÊ
˳ÐòɨÃè²ÅÄܵõ½ËùÓÐÐÐ
Ö»ÐëɨÃèË÷Òý¼´¿É·µ»ØËùÓÐÐÐ
¿ÉÒÔºÍÆäËü±íÒ»Æð¾Û¼¯´æ´¢
²»Äܴ洢Ϊ¾Û¼¯±í
¿ÉÒÔ°üº¬longºÍlobÀàÐ͵ÄÁÐ
¿ÉÒÔ°üº¬lobÀàÐ͵«²»¿ÉÒÔ°üÀ¨longÀàÐ͵ÄÁÐ
ʹÓÃIOTµÄºÃ´¦£º
1¡¢ÓÉÓÚË÷ÒýÏîºÍÊý¾Ý´æ´¢ÔÚÒ»Æð£¬ËùÒÔÎÞÂÛÊÇ»ùÓÚÖ÷¼üµÄµÈÖµ²éѯ»¹ÊÇ·¶Î§²éѯ¶¼ÄÜ´ó´ó½ÚÊ¡´ÅÅÌ·ÃÎÊʱ¼ä¡£
2¡¢ÎªÁËÄܹ»¸ü¿ìµØ·ÃÎÊÄÇЩƵ·±·ÃÎʵÄÁУ¬¿ÉÒÔʹÓÃÒç³ö´æ´¢Ñ¡ÏÄÇЩ·ÃÎʲ»Æµ·±µÄÁзÅÔÚBÊ÷Ò¶½áµãÊý¾Ý¿éÖ®ÍâµÄÒç³ö¶Ñ¿Õ¼äÖС£ÕâÑùÒ»À´±ã¿ÉÒԵõ½¸üСµÄBÊ÷£¬ÒÔ¼°°üº¬¸ü¶àÐеÄÒ¶½áµã
3¡¢ºÍ¶Ñ×éÖ¯±íºÍË÷Òý²»Í¬£¬Ö÷¼ü²»ÐèÒª±»´æ´¢Á½´Î¡£
4¡¢ROWIDαÁÐÊÇ»ùÓÚÖ÷¼üÖµµÄÂß¼rowid£¬¶ø²»ÊÇÎïÀírowid£¬¼´Ê¹±í±»ÖØÐÂ×éÖ¯¹ý£¬Ôì³ÉÁË»ù±íÐеÄǨÒÆ£¬¶þ¼¶Ë÷ÒýÈÔÈ»¿ÉÓ㬲»ÐèÒªÖؽ¨¡£
×¢£º
1¡¢OracleʹÓÃrowidÊý¾ÝÀàÐÍ´æ´¢ÐеØÖ·,rowid¿ÉÒÔ·Ö³ÉÁ½ÖÖ£¬·Ö±ðÊÊÓÚ²»Í¬µ
Ïà¹ØÎĵµ£º
SQL SERVERÁÙʱ±í
Ò²¿ÉÒÔ´´½¨ÁÙʱ±í¡£ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬µ«ÁÙʱ±í´æ´¢ÔÚ tempdb ÖУ¬µ±²»ÔÙʹÓÃʱ»á×Ô¶¯É¾³ý¡£
Óб¾µØºÍÈ«¾ÖÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£¬¶þÕßÔÚÃû³Æ¡¢¿É¼ûÐԺͿÉÓÃÐÔÉϾù²»Ïàͬ¡£±¾µØÁÙʱ±íµÄÃû³ÆÒÔµ¥¸öÊý×Ö·ûºÅ (#) ´òÍ·£»
ËüÃǽö¶Ôµ±Ç°µÄÓû§Á¬½ÓÊǿɼûµÄ£»µ±Óû§´Ó Microsoft? SQL Server? 2000 ʵÀý¶Ï ......
Navicat for xxx ÊÇÒ»¸öÓÅÐãµÄÊý¾Ý¿â¹ÜÀí¿Í»§¶Ë£¬ÓÐ MySQL¡¢Oracle µÈ°æ±¾¡£½¨Òé´ó¼Ò×îºÃÓà Enterprise °æ±¾£¬¹¦ÄÜÈ«ÃæһЩ£¬µ«½ÏÖ®ÓÚÃâ·ÑµÄ Lite °æ£¬ÆóÒµ°æ¿ÉÊÇÒª»¨Òø×ÓÂòµÄ¡£
°²×° Navicat for Oracle ºó£¬Ê×ÏÈÐèÒª½¨Ò»¸ö“Á¬½Ó”£¬×÷Ϊij¸ö¹ÜÀíÈÎÎñµÄ±êʶ£¬ÒòΪ×÷Ϊ¿ ......
ÔÚOracle8i»òÒÔÉÏ°æ±¾ÖУ¬¿ÉÒÔ´´½¨ÒÔÏÂÁ½ÖÖÁÙʱ±í£º
1¡£»á»°ÌØÓеÄÁÙʱ±í
CREATE GLOBAL TEMPORARY <TABLE_NAME> (<column specification>)
ON COMMIT PRESERVE ROWS£»
2¡£ÊÂÎñÌØÓеÄÁÙʱ±í
CREATE GL ......
Oracle ´æ´¢¹ý³Ì·µ»Ø½á¹û¼¯Óà ref cursor ʵÏÖ¡£
ÊÔÑé²½ÖèÈçÏ£º
1. ½¨Á¢ ref cursor ÀàÐͺ͹ý³Ì
CREATE OR REPLACE PACKAGE types
AS
TYPE ref_cursor IS REF CURSOR;
END;
/
CREATE TABLE STOCK_PRICES(
RIC VARCHAR(6) PRIMARY KEY,
PRICE NUMBER(7 ......
±í½á¹¹ºÍÊý¾ÝÈçÏ£¨±íÃûTest£©£º
NO VALUE NAME
1 a ²âÊÔ1
1 b ²âÊÔ2
1 c ......