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¡£
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ÔÚ¿ª·¢Ó¦ÓõÄʱºò£¬°ÑÊý¾Ý°´ÕÕÒ»¶¨µÄ¹æÔòÅÅÐòºóÔÙÈ¡Ç°¼¸ÌõÊý¾ÝÕâÖÖ²Ù×÷ÊǺÜƽ³£µÄÊÂÇé¡£ÎÒÃÇÔÚOracleÖг£ÓõľÍÊÇorder by£¬È»ºóÈ¡µÃrownumСÓÚ¶àÉÙµÄÊý¾ÝÕâÖÖ·½·¨¡£²»¹ýÈç¹û¶ÔOracle²»ÊìϤ£¬Ò²Ðí¾Í»á·¢ÏÖÄãдµÄSQLÓï¾ä¼ìË÷³öÀ´µÄÖµ²»ÕýÈ·£¬Õâ¸öÊÇΪʲôÄØ¡£ ÒòΪOracleÔÚ¼ìË÷µÄʱºò£¬»áÊ×ÏÈ°ÑÊý¾Ý¶¼¼ìË÷³öÀ´£¬È»ºóÔÚÅÅÐò¶Î ......
ÎÒÃÇÔÚ´´½¨±í½á¹¹µÄ¹ý³ÌÖУ¬¿ÉÄÜ»áÓÉÓÚʧÎó£¬Ôì³É±íÖÐÁÐÃû´íÎó£¬ÈçºÎ¸ü¸ÄÄØ£¬Äã¿ÉÄÜ»á»Ø´ð£¬Ê¹ÓÃOEM»òÕßPL/SQL£¬³ýÁËÕâÁ½ÖÖ·½·¨£¬ÎÒÃÇ¿ÉÒÔʹÓÃÃüÁ
ALTER TABLE ±íÃû rename column ÁÐÃû to ÐÂÁÐÃû ×¢ÒâcolumnÊǹؼü×Ö /*ÖØÃüÃûÁÐÃû*/
ALTE ......
¶ÔÓÚÎÒÃǸÕÈëÃŵÄoracle³õѧÕßÀ´Ëµ£¬Ñ§Ï°sqlÓïÑÔÊÇÈëÃŵĵÚÒ»²½£¬Ãæ¶Ôµ¥ÒýºÅºÍË«ÒýºÅ£¬ÎÒÃÇ¿ÉÄÜ»áÀ§»ó£¬Ê²Ã´Ê±ºòÓõ¥ÒýºÅ£¬Ê²Ã´Ê±ºòÓÃË«ÒýºÅÄØ£¿
µ¥ÒýºÅ------ ֵΪ×Ö·ûºÍÈÕÆÚµÄʱºò Èç 'you' '06-june' »¹ÓÐʹÓÃÁ¬½Ó·û||£¬²åÈë¿Õ¸ñ||' ......
select sysdate µ±Ç°Ê±¼ä,
sys.login_user Êý¾Ý¿âÓû§,
machine µÇ¼»úÆ÷Ãû,
SYS_CONTEXT('USERENV', 'IP_ADDRESS') 怬IP,
&n ......