oracle clob ºÍblobÎÊÌâµÄ½â¾ö
oracle clob ºÍblobÎÊÌâµÄ½â¾ö
ÕûÀíÁËoracle clob ºÍblobÎÊÌâµÄ½â¾ö°ì·¨£º
1£º½¨ÒéʹÓÃoracle 10µÄojdbc14.jar,·ñÔòµ±±£´æclobµÄʱºò¿ÉÄÜ»á³öÏÖÌ×½Ó×Ö´íÎó£»
2£ºspringÅäÖÃÈçÏ£º
java´úÂë:
<bean id="sessionFactory" >
<property name="hibernateProperties">
<props>
<prop key="hibernate.dialect">org.hibernate.dialect.Oracle9Dialect</prop>
</props>
</property>
<property name="dataSource">
<ref bean="dataSource" />
</property>
<property name="configLocation">
<value>classpath:hibernate.cfg
Ïà¹ØÎĵµ£º
ÏÂÃæÎÒÃÇÀ´Ñ§Ï°ÔõôÔÚLinux»·¾³Ï´´½¨Ò»¸öÐÂÊý¾Ý¿â¡£
Ò»¡¢Database Configuration Assistant£¨DBCA£©´´½¨Êý¾Ý¿â
1¡¢ÒÔOracleÓû§µÇ¼µ½Linuxϵͳ¡£
2¡¢¸ÄÏÂÏÔʾ±àÂë°É£¬Òª²»È»³öÏÖµÄÌáʾ¿ò½çÃæ»áºÍOracle°²×°Ê±ºòÒ»Ñù¡£¸Ä±àÂëÃüÁ
?[Copy to clipboard]View Code BASH
$ LANG="en_US"
3¡¢ÓÉÓÚÏÈǰÎÒÃÇÒѾ°Ñ»·¾³±ä ......
Ò»¡¢SQLµÄʹÓÃ
CREATE¡¢ALTERºÍDROPÊÇÖ÷ÒªµÄ3ÖÖDDLÓï¾ä£¬ÕâЩÓï¾ä±»ÓÃÓÚÔÚÊý¾Ý¿âÖÐÌí¼Ó¡¢Ð޸Ļòɾ³ý¶ÔÏó¡£
DCLÓï¾ä°üÀ¨GRANTºÍREVOKEÃüÁËüÃÇ¿ÉÒÔ±»ÓÃÓÚΪÓû§»ò½ÇÉ«ÊÚÓè»òÈ¡ÏûȨÏÞ£¬¿ÉÒÔ±»ÊÚÓèºÍÈ¡ÏûµÄÁ½ÖÖȨÏÞÊÇϵͳȨÏ޺ͶÔÏóȨÏÞ¡£È¡¾öÓÚ²»Í¬µÄ¶ÔÏóÀàÐÍ£¬¶ÔÏóȨÏÞ¿ÉÄܲ»Í¬¡£
²Ù×Ý»ò¼ìË÷Êý¾Ý¶¼ÐèҪʹÓÃDMLÓï¾ä¡£D ......
´´½¨±íµÄÓï·¨
-´´½¨±í¸ñÓï·¨:
create table ±íÃû(
×Ö¶ÎÃû1 ×Ö¶ÎÀàÐÍ(³¤¶È) ÊÇ·ñΪ¿Õ,
×Ö¶ÎÃû2 ×Ö¶ÎÀàÐÍ ÊÇ·ñΪ¿Õ
);
-Ôö¼ÓÖ÷¼ü
alter table ±íÃû add constraint Ö÷¼üÃû primary key (×Ö¶ÎÃû1);
-Ôö¼ÓÍâ¼ü:
alter table ±íÃû
  ......
1¡¢Oracle NetÓëͨÐÅÐÒé¼ò½é
OracleµÄÍøÂçÖ§³Ö±»ÏÞÖÆÓÚTCP¡¢ÃüÃû¹ÜµÀ£¨Named Pipes£¬¼òдSDP£©¡£ËùÓеIJÙ×÷ϵͳ¶¼¾ßÓÐÒ»¸ö±¾²Ù×÷ϵͳרÓеĽø³Ì¼äͨÐÅ£¨Inter-Process Communication£¬¼òдIPC£©ÐÒé¡£
2¡¢½¨Á¢»á»°
ͨ¹ýÓû§½ø³Ì½¨Á¢Õë¶ÔʵÀýµÄ»á»°£¬¿ÉÒÔÖ´ÐУº
?[Copy to clipboard]View Code SQL
SQL> connect s ......
1¡¢»Ö¸´½á¹¹Óë½ø³Ì
ÔÚ½éÖÊʧ°Üºó£¬¸ù¾ÝÊÜËðÎļþµÄÀàÐÍ£¬´æÔÚ²»Í¬µÄ»Ö¸´·½·¨¡£Êý¾Ý¿âÓÉ¿ØÖÆÎļþ¡¢Áª»úÖØ×öÈÕÖ¾ÎļþÒÔ¼°Êý¾ÝÎļþ×é³É¡£Èç¹û¸´ÓÃÁË¿ØÖÆÎļþ»òÁª»úÖØ×öÈÕÖ¾Îļþ£¬ÄÇô»Ö¸´ÊÜËðµÄÕâЩÎļþÊ®·ÖÈÝÒס£
¶ÔÓÚÊÜËðµÄ¿ØÖÆÎļþ£¬¿ÉÒÔ½«ÆäÌæ»»ÎªÄ³¸ö¸´Óø±±¾£¬Ò²¿ÉÒÔʹÓÃCREATE CONTROLFILEÃüÁîÖØ½¨¡£
ÊÜËðµÄÁª»úÖØ×öÈ ......