³õʶ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¿ÉÒÔ·Ö³ÉÁ½ÖÖ£¬·Ö±ðÊÊÓÚ²»Í¬µ
Ïà¹ØÎĵµ£º
1.ASCII
·µ»ØÓëÖ¸¶¨µÄ×Ö·û¶ÔÓ¦µÄÊ®½øÖÆÊý;
SQL> select ascii(’A’) A,ascii(’a’) a,ascii(’0’) zero,ascii(’ ’) space from dual;
A A ZERO SPACE
--------- --------- --------- ---------
65 97 48 32
2.CHR
¸ø³öÕ ......
SQL SERVERÁÙʱ±í
Ò²¿ÉÒÔ´´½¨ÁÙʱ±í¡£ÁÙʱ±íÓëÓÀ¾Ã±íÏàËÆ£¬µ«ÁÙʱ±í´æ´¢ÔÚ tempdb ÖУ¬µ±²»ÔÙʹÓÃʱ»á×Ô¶¯É¾³ý¡£
Óб¾µØºÍÈ«¾ÖÁ½ÖÖÀàÐ͵ÄÁÙʱ±í£¬¶þÕßÔÚÃû³Æ¡¢¿É¼ûÐԺͿÉÓÃÐÔÉϾù²»Ïàͬ¡£±¾µØÁÙʱ±íµÄÃû³ÆÒÔµ¥¸öÊý×Ö·ûºÅ (#) ´òÍ·£»
ËüÃǽö¶Ôµ±Ç°µÄÓû§Á¬½ÓÊǿɼûµÄ£»µ±Óû§´Ó Microsoft? SQL Server? 2000 ʵÀý¶Ï ......
OracleÊý¾Ý¿âÌṩÁ˼¸ÖÖ²»Í¬µÄÊý¾Ý¿âÆô¶¯ºÍ¹Ø±Õ·½Ê½£¬±¾ÎĽ«Ïêϸ½éÉÜÕâЩÆô¶¯ºÍ¹Ø±Õ·½Ê½Ö®¼äµÄÇø±ðÒÔ¼°ËüÃǸ÷×Ô²»Í¬µÄ¹¦ÄÜ¡£
Ò»¡¢Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â
¡¡¡¡¶ÔÓÚ´ó¶àÊýOracle DBAÀ´Ëµ£¬Æô¶¯ºÍ¹Ø±ÕOracleÊý¾Ý¿â×î³£Óõķ½Ê½¾ÍÊÇÔÚÃüÁîÐз½Ê½ÏµÄServer Manager¡£´ÓOracle 8iÒÔºó£¬ÏµÍ³½«Server ManagerµÄËùÓй¦Äܶ¼¼¯Öе ......
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 ......
Ëæ×ÅÈ«ÇòÐÅÏ¢»¯Ê±´úµÄµ½À´£¬ÐÅÏ¢Êý¾ÝÔ½À´Ô½³ÉΪÆóÒµ¹Ø×¢µÄ½¹µã£¬¼´ÔÚ¸÷ÖÖ×ÔÈ»ÔÖº¦»òÕßÈËΪÆÆ»µµÄÇé¿öÏ£¬ÈçºÎ±£Ö¤Éú²úÊý¾ÝµÄ°²È«ºÍ¹Ø¼üÒµÎñµÄ²»ÖжÏÔËÐС£
´«Í³µÄ±£»¤·½·¨ÀëÏß±¸·Ý¡¢±¸·Ý½éÖÊÒìµØ±£´æÔÚÒ»¶¨³Ì¶ÈÉÏ¿ÉÒÔ½â¾öÉÏÊöÎÊÌ⣬µ«ÎªÁËÄܹ»¶ÔÒµÎñϵͳÌṩ¸ü¸ßµÄʵʱÐԺͿɿ¿ÐÔ£¬±£Ö¤¹Ø¼üÒµÎñ7x24²» ......