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

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


Ïà¹ØÎĵµ£º

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨1£©£ºOracleµÄ»ù±¾¸ÅÄî

ÏÈÀ´Á˽âϼ¸¸öÓ¢Îĵļò³Æ£¬ÔÚÒÔºó¾­³£»á¼ûµ½¡£
¶ÔÏó¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨Object Relational Database Management System£¬¼ò³ÆORDBMS£©
¹ØÏµÊý¾Ý¿â¹ÜÀíϵͳ£¨Relational Database Management System£¬¼ò³ÆRDBMS£©
Êý¾Ý¿â¹ÜÀíϵͳ£¨Database Management System£¬¼ò³ÆDBMS£©
½á¹¹»¯²éѯÓïÑÔ£¨Structured Query Langua ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨3£©£º´´½¨OracleÊý¾Ý¿â£¨2£©

ÏÂÃæÎÒÃÇÀ´Ñ§Ï°ÔõôÔÚLinux»·¾³Ï´´½¨Ò»¸öÐÂÊý¾Ý¿â¡£
Ò»¡¢Database Configuration Assistant£¨DBCA£©´´½¨Êý¾Ý¿â
1¡¢ÒÔOracleÓû§µÇ¼µ½Linuxϵͳ¡£
2¡¢¸ÄÏÂÏÔʾ±àÂë°É£¬Òª²»È»³öÏÖµÄÌáʾ¿ò½çÃæ»áºÍOracle°²×°Ê±ºòÒ»Ñù¡£¸Ä±àÂëÃüÁ
?[Copy to clipboard]View Code BASH
$ LANG="en_US"
3¡¢ÓÉÓÚÏÈǰÎÒÃÇÒѾ­°Ñ»·¾³±ä ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨11£©£º±£»¤OracleÊý¾Ý¿âµÄ°²È«£¨1£©

1¡¢µ÷ÕûĬÈϵݲȫÉèÖÃ
1.1¡¢Ä¬ÈϵÄÓû§
²é¿´Êý¾Ý¿âµÄÓû§ºÍ״̬£¬¿ÉÒÔ²éѯDBA_USERSÊÓͼ¡£
?[Copy to clipboard]View Code SQL
SQL> select username,account_status from dba_users;
1.2¡¢PUBLICȨÏÞ
OracleÖдæÔÚÒ»¸öÃûΪPUBLICµÄαÓû§¡£Ö»ÒªÓÃPUBLICÊÚÓèij¸öȨÏÞ£¬ÄÇôËùÓÐÓû§¶¼»á±»ÊÚÓèÕâ¸öȨÏÞ¡£
?[Copy ......

OCPÈÏÖ¤¿¼ÊÔÖ¸ÄÏ£¨20£©£º»Ö¸´OracleÊý¾Ý¿â

1¡¢»Ö¸´½á¹¹Óë½ø³Ì
ÔÚ½éÖÊʧ°Üºó£¬¸ù¾ÝÊÜËðÎļþµÄÀàÐÍ£¬´æÔÚ²»Í¬µÄ»Ö¸´·½·¨¡£Êý¾Ý¿âÓÉ¿ØÖÆÎļþ¡¢Áª»úÖØ×öÈÕÖ¾ÎļþÒÔ¼°Êý¾ÝÎļþ×é³É¡£Èç¹û¸´ÓÃÁË¿ØÖÆÎļþ»òÁª»úÖØ×öÈÕÖ¾Îļþ£¬ÄÇô»Ö¸´ÊÜËðµÄÕâЩÎļþÊ®·ÖÈÝÒס£
¶ÔÓÚÊÜËðµÄ¿ØÖÆÎļþ£¬¿ÉÒÔ½«ÆäÌæ»»ÎªÄ³¸ö¸´Óø±±¾£¬Ò²¿ÉÒÔʹÓÃCREATE CONTROLFILEÃüÁîÖØ½¨¡£
ÊÜËðµÄÁª»úÖØ×öÈ ......

ÔÚoracleÖÐ,ÈçºÎ¸øÒÑ´æÔڵıíÌí¼ÓÒ»ÁÐ?

alter table Tablename add(column1 varchar2(20),column2 number(7,2)...)
±ÈÈ磺
ÒÑÓбíA£¬½á¹¹ÈçÏÂ
×Ö¶ÎÃû ÀàÐÍ
------------ -------------
A VARCHAR2(10)
B NUMBER
ÏÖÔÚÒªÔö¼Ó ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ