Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

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 ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

oracle¸´Ï°£¨Ò»£© Ö®OracleÌåϵ½á¹¹

      ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬Ô­À´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·­Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
      µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......

ORACLE·ÖÎöº¯ÊýµÄÓ÷¨

¿ª´°º¯ÊýµÄµÄÀí½â£º
¿ª´°º¯ÊýÖ¸¶¨ÁË·ÖÎöº¯Êý¹¤×÷µÄÊý¾Ý´°¿Ú´óС£¬Õâ¸öÊý¾Ý´°¿Ú´óС¿ÉÄÜ»áËæ×ÅÐеı仯¶ø±ä»¯£¬¾ÙÀýÈçÏ£º
over£¨order   by   salary£© °´ÕÕsalaryÅÅÐò½øÐÐÀۼƣ¬order   byÊǸöĬÈϵĿª´°º¯Êý
over£¨partition   by   deptno£©°´ÕÕ²¿ÃÅ·ÖÇø
ove ......

Oracle 10.1 Statistics

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 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ