Oracle LongÐÍ
Oracle LongÐÍ
1¡¢LONG Êý¾ÝÀàÐÍÖд洢µÄÊǿɱ䳤×Ö·û´®£¬×î´ó³¤¶ÈÏÞÖÆÊÇ2GB¡£
2¡¢¶ÔÓÚ³¬³öÒ»¶¨³¤¶ÈµÄÎı¾£¬»ù±¾Ö»ÄÜÓÃLONGÀàÐÍÀ´´æ´¢£¬Êý¾Ý×ÖµäÖкܶà¶ÔÏóµÄ¶¨Òå¾ÍÊÇÓÃLONGÀ´´æ´¢µÄ¡£
3¡¢LONGÀàÐÍÖ÷ÒªÓÃÓÚ²»ÐèÒª×÷×Ö·û´®ËÑË÷µÄ³¤´®Êý¾Ý£¬Èç¹ûÒª½øÐÐ×Ö·ûËÑË÷¾ÍÒªÓÃvarchar2ÀàÐÍ¡£
4¡¢ºÜ¶à¹¤¾ß£¬°üÀ¨SQL*Plus£¬´¦ÀíLONG Êý¾ÝÀàÐͶ¼ÊǺÜÀ§Äѵġ£
5¡¢LONG Êý¾ÝÀàÐ͵ÄʹÓÃÖУ¬ÒªÊÜÏÞÓÚ´ÅÅ̵ĴóС¡£
Äܹ»²Ù×÷ LONG µÄ SQL Óï¾ä£º
1¡¢SelectÓï¾ä
2¡¢UpdateÓï¾äÖеÄSETÓï¾ä
3¡¢InsertÓï¾äÖеÄVALUESÓï¾ä
ÏÞÖÆ£º
1¡¢Ò»¸ö±íÖÐÖ»ÄÜ°üº¬Ò»¸ö LONG ÀàÐ͵ÄÁС£
2¡¢²»ÄÜË÷ÒýLONGÀàÐÍÁС£
3¡¢²»Äܽ«º¬ÓÐLONGÀàÐÍÁеıí×÷¾Û´Ø¡£
4¡¢²»ÄÜÔÚSQL*PlusÖн«LONGÀàÐÍÁеÄÊýÖµ²åÈëµ½ÁíÒ»¸ö±í¸ñÖÐ,Èçinsert into ...select¡£
5¡¢²»ÄÜÔÚSQL*PlusÖÐͨ¹ý²éѯÆäËû±íµÄ·½Ê½À´´´½¨LONGÀàÐÍÁÐ,Èçcreate table as select¡£
6¡¢²»ÄܶÔLONGÀàÐÍÁмÓÔ¼ÊøÌõ¼þ£¨NULL¡¢NOT NULL¡¢DEFAULT³ýÍ⣩£¬È磺¹Ø¼ü×ÖÁÐ(PRIMARY KEY)²»ÄÜÊÇ LONG Êý¾ÝÀàÐÍ¡£
7¡¢LONGÀàÐÍÁв»ÄÜÓÃÔÚSelectµÄÒÔÏÂ×Ó¾äÖУºwhere¡¢group by¡¢order by£¬ÒÔ¼°´øÓÐdistinctµÄselectÓï¾äÖС£
8¡¢LONGÀàÐÍÁв»ÄÜÓÃÓÚ·Ö²¼²éѯ¡£
9¡¢PL/SQL¹ý³Ì¿éµÄ±äÁ¿²»Äܶ¨ÒåΪLONGÀàÐÍ¡£
10¡¢LONGÀàÐÍÁв»Äܱ»SQLº¯ÊýËù¸Ä±ä£¬È磺substr¡¢instr¡£
Ïà¹ØÎĵµ£º
ϵͳ·Ö²½Öè²úÉúµÄ·Ö¼£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº £¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
2£©¿â´æÄ£¿é×÷¼ìÑéÈë¿âʱ²úÉúµÄ·Ö¼Ϊ£º
ϵͳ²úÉúµÄ·Ö¼·Ö±ðΪ£º
1£©¿â´æÄ£¿é×÷½ÓÊÕʱ²úÉúµÄ·Ö¼Ϊ£º
½è£º²ÄÁϲɹº
£¨²É¹ºµ¥¼ÛX¶©µ¥ÊýÁ¿£©
´û£ºÓ¦¼Æ¸ºÕ®
£¨²É¹ºµ¥¼ÛX¶©µ¥Ê ......
Oracle ×ÜÕÊÄ£¿éµÄÒ»¸ö»á¼ÆÒµÎñÖÜÆÚÈçÏÂ:
1.´ò¿ª×ÜÕÊ»á¼ÆÆÚ
2.¼ÈëÊÖ¹¤Æ¾Ö¤,°üÀ¨:· ÊÖ¹¤±ê׼ƾ֤
  ......
ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
ALTER TABLE ±íÃû rename column ÁÐÃû to ÐÂÁÐÃû ×¢ÒâcolumnÊǹؼü×Ö /*ÖØÃüÃûÁÐÃû*/
ALTE ......
select sysdate µ±Ç°Ê±¼ä,
sys.login_user Êý¾Ý¿âÓû§,
machine µÇ¼»úÆ÷Ãû,
SYS_CONTEXT('USERENV', 'IP_ADDRESS') 怬IP,
&n ......