OracleµÄÔ¼ÊøÊÇ·ñ¿ÉÒÔ¸´ÓÃ
Oracle µÄ Ô¼ÊøÊÇÊÇ·ñ¿ÉÒÔ¸´Óã¿£¨µ÷ÓÃÔ¼ÊøÃû³Æ¾Í¿ÉÒÔÖ±½ÓʹÓøÃÔ¼Êø£©ÔÚÄÄÀï¿ÉÒÔ¹ÜÀíÔ¼Êø¡£ plsqlÓÐÕâ¸ö¹¦ÄÜô£¿
SQL code: Ö±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraintsÒýÓà SQL codeÖ±½ÓÓÃPL/SQL DEVELOPER µã»÷TABLES ÖÐcheck constraints ÕÒµ½ÁË ºÇºÇ ÇëÎÊÈçºÎÔÚдÓï¾äµÄʱºò ÊÇ·ñ¿ÉÒÔÖ±½ÓʹÓÃÔ¼ÊøÃû À´ÒýÓøÃÔ¼Êø ¡£ ÊÇ´´½¨µÄ±íÓµÓиÃÔ¼ÊøÃ´£¬Ô¼ÊøÊǹéÊôÓÚ±íµÄ´æÔÚ Ëæ±í´æÔÚ¶ø´æÔÚ Ëæ±íɾ³ý¶øÏûʧ¡£»òÕßËµÔ¼ÊøÊǶÀÁ¢µÄ´æÔÚ£¬ÈκαíʹÓõÄÖ»ÊǶÔËüµÄÒýÓÃÄØ£¿ ´ÓÔ¼ÊøµÄ¶¨ÒåÀ´¿´ÊDz»ÄÜÖØÓõġ£ Oracle Database enables you to apply constraints both at the table and column level. A constraint specified as part of the definition of a column or attribute is called an inline specification. A constraint specified as part of the table definition is called an out-of-line specification. http://download.oracle.com/docs/cd/E11882_01/server.112/e10713/datainte.htm#CNCPT322 ÍÛÈû~Òý³öÀÏ»¢ÁË~~~Á˽â~~¼ÈÈ»ÊÇtable £¬column,attribute µÄÒ»²¿·Ö ÄÇ×ÔÈ»ÊDz»¿ÉÒýÓã¬Ò²²»¿ÉÖØÓõÄÁË¡£ ÄÜÖØÓöàºÃ£¬²»¹ýÕⲿ·ÖºÍÒµÎñÁªÏµÌ«¹ý½ôÃÜµÄ Êý¾ÝÔ¼Êø»¹ÊǷŵ½ ´úÂëÖÐ×öºÃÁË~~±Ï¾¹Êý¾Ý¿â²»ÊÇ´¦ÀíÒµÎñµÄµØ·½ºÇºÇ¡£µ±Ê±Éè¼ÆplsqlµÄ¹¤³ÌʦÃÇ´ó¸ÅÒ²ÊÇÄÇôÏëµÄ°É~ºÙºÙ
Ïà¹ØÎÊ´ð£º
»·¾³£º1.win2003server+oracle9i 2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1 3.oracle sql developer°æ±¾ 1.5.5 ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
ÎÒ¶ÔSQL SERVERºÍACCESS±È½ÏÊ죬ËùÒÔÊý¾Ý¿âµÄͨÓûù´¡¶«Î÷¿ÉÒÔ˵¶¼ÕÆÎյIJ¶àÁË£¬ÎÒÏÖÔÚÏëÒªµÄ¾ÍÊÇÒÔÉÏÁ½Êý¾Ý¿âµÄ¶ÀÌØÖ®´¦µÄ½éÉܺÍÓ¦ÓýéÉÜ¡£ ÁíÍâÊé×îºÃ¶ÔÓ¦×îа汾 oracleÊÇ11g°É 10µÄÒ²ÐУ»mysqlÊÇ5.1°É л ......
1.OracleÖÐÃèÊöµÄ¿Í»§¶ËÓ¦Óõ½µ×Ö¸µÄʲô? 2.OracleתÂëʱ,Èç¹û¿Í»§¶ËΪ×Ó¼¯(UASCII)·þÎñ¶ËΪ³¬¼¯(AL32UTF8). ÄÇÑϸñµÄ½²ÊÇ×Ó¼¯×ª³¬¼¯, ¿ÉÒÔתµÄͨ. ²éѯµÄʱºò³¬¼¯×ª×Ó¼¯ÄDz»¾Í³öÎÊÌâÁËô? Äĸö»Ø¸öÌ ......
ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡ ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ End_rbody_60301247//--> ¸Ã»Ø¸´ÓÚ2009-1 ......
ÏÂÃæÊÇÎÒÔÚÍøÉÏÕÒµÄBLOB¶Áд³ÌÐò£¬µ«ÊÇÒ»Ö±ÔËÐв»³öÀ´£¬ÓÐÒ»ÐÐ blob = (BLOB)rst.getBlob(1); Ò»Ö±±¨´í£¬Exception in thread "main" java.lang.UnsupportedOperationException at sun.jdbc.odb ......