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±í¿Õ¼ä²Ù×÷Ïê½â
1
2
3×÷Õߣº À´Ô´£º ¸üÐÂÈÕÆÚ£º2006-01-04
5
6
7½¨Á¢±í¿Õ¼ä
8
9CREATE TABLESPACE data01
10DATAFILE '/ora ......
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order by salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition by deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......
Oracle 10.1 Statistics£º
In Oracle 9.2 there were 264 statistics; in Oracle 10.1 there are 332 statistics
The following table shows the 106 statistics that were added in Oracle 10.1:
Name
application wait time
cluster wait time
concurrency wait time
consistent gets direct
consistent ......