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

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µÄ¹¤³ÌʦÃÇ´ó¸ÅÒ²ÊÇÄÇôÏëµÄ°É~ºÙºÙ


Ïà¹ØÎÊ´ð£º

PHP Á¬½ÓOracle ³ö´í

<?php
  getenv("ORACLE_HOME");
  $conn=ocilogon("test","test","test_db");
  if($conn)  
  echo success;  
&nb ......

ORACLEÊý¾Ý¿âÖÐµÄ group by Óï¾ä£¿

  with adod_dict do
    begin
    close;
    commandtext:='select bgqxcode,count(*) wjsl from wscl_wsda_file where wjnd=:tnd group by bgqxcode'; ......

ÓÐʲôÊéÊǽ²¹ØÓÚOracleµÄЧÂʵÄ

´ó¼ÒÍƼöÒ»ÏÂ
Oracle Database 10g Performance Tuning Tips & Techniques
ÎÒÂòµÄ£¬¸Õ¿ªÊ¼¿´

Database Performance Tuning Guide and Reference

oracle¹«Ë¾×Ô¼ºµÄdocument£¬Ã¿¸ö´ó°æ±¾¶¼ÓÐ×Ô¼ºÒ»Ì ......

oracle cartridge¿ª·¢

ÄÄλÐÖµÜÓÐoracle cartradge¿ª·¢×ÊÁÏ£¬Äܲ»Äܹ²Ïíһϣ¿Ð»Ð»£¡

ûÓÐÌý˵¹ý£¬OracleÌ«ÅÓ´óÁË

ÎÒÒ²ÊǸսӴ¥£¬²»Çå³þÔõô×ö£¬Ö»ÖªµÀÕâ¸ö¼¼ÊõÊÇÓÃÀ´¿ª·¢Öмä¼þµÄ



End_rbody_60301247//-->
¸Ã»Ø¸´ÓÚ2009-1 ......

oracle BLOB´ó×ֶζÁд³öÏÖÎÊÌâ

ÏÂÃæÊÇÎÒÔÚÍøÉÏÕÒµÄBLOB¶Áд³ÌÐò£¬µ«ÊÇÒ»Ö±ÔËÐв»³öÀ´£¬ÓÐÒ»ÐÐ
blob = (BLOB)rst.getBlob(1);
Ò»Ö±±¨´í£¬Exception in thread "main" java.lang.UnsupportedOperationException
at sun.jdbc.odb ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ