oracle constraints(2)
oracle Ô¼ÊøµÄ״̬
oracleÔÚ´´½¨Ô¼ÊøºóĬÈÏ״̬ÊÇenabled VALIDATED
SQL> create table T2
2 (
3 VID NUMBER,
4 VNAME VARCHAR2(10) not null,
5 VSEX VARCHAR2(10) not null
6 )
7 /
Table created
SQL> alter table t2 add constraints PK_T primary key (vid);
Table altered
SQL> select t.constraint_name, t.status, t.validated from user_constraints t;
CONSTRAINT_NAME STATUS VALIDATED
------------------------------ -------- -------------
SYS_C003762 ENABLED VALIDATED
SYS_C003763 ENABLED VALIDATED
PK_T ENABLED VALIDATED
oracleÔ¼ÊøÒ»¹²ÓÐ4ÖÖ״̬:enabled validated, enabled novalidated, disadble validated, disable novalidated¡£
enabled validated ÊÇĬÈÏ״̬£¬±íʾÊý¾ÝÔÚÔ¼Êø´´½¨Ê±Òª¶ÔÊý¾Ý¿âÄÚµÄÊý¾Ý½øÐÐУÑé²¢ÇÒͬʱԼÊøºóÀ´²åÈëµÄÊý¾ÝÂú×ãÔ¼ÊøÌõ¼þ¡£
enabled novalidated ±íʾ²»¶ÔÊý¾Ý¿âÄÚµÄÊý¾Ý½øÐÐУÑé¶øÖ»ÊÇÒªÇóºóÀ´²åÈëµÄÊý¾ÝÂú×ãÔ¼ÊøÌõ¼þ¡£
SQL> select * from t2;
VID VNAME VSEX
---------- ---------- ----------
1 a y
2 b
3 c x
SQL> alter table t2 modify VSEX not null enable novalidate;
Table altered
SQL> select * from t2;
VID VNAME VSEX
---------- ---------- ----------
1 a y
2 b
3 c x
SQL> insert into t2 values ('4','d','');
insert into t2 values ('4','d','')
ORA-01400: ÎÞ·¨½« NULL ²åÈë ("PORTALDB"."T2"."VSEX")
SQL>
SQL> select t.constraint_name, t.status, t.validated from user_constraints t;
CONSTRAINT_NAME STATUS VALIDATED
------------------------------ -------- -------------
SYS_C003765 ENABLED VALIDATED
PK_T ENABLED VALIDATED
SYS_C003768 ENABLED NOT VALIDATED
¶ÔÓÚΨһԼÊøºÍÖ÷¼üÔ¼ÊøÓÉÓÚÔÚ´´½¨Ê±ºòÒª´´½¨Î¨Ò»Ë÷Òý£¬ËùÒÔÔÚÆÕͨ±íÖÐÈç¹û±íÖÐÊý¾ÝÓÐÎ¥·´Ô¼Êøµ
Ïà¹ØÎĵµ£º
ѧϰOracle DBAÒ²°ë¸ö¶àѧÆÚÁË£¬½ñÌìÃÍÈ»²Å·¢ÏÖ£¬ÔÀ´ÎÒµÄÊ黹ÊǺÜеģ¬ÉϿβÙ×÷ʱºòÒ²Ö»ÊÇÖªµÀ´ó¸ÅÔõô×ö£¬µ«ÊÇÒªÕæµÄÈ«²¿×Ô¼º×ö£¬¶ø²»È¥·Ê黹ÊÇÓÐÒ»¶¨µÄÄѶȵģ¬ËùÒÔÄØ£¬½ñÌ쿪ʼ½«DBA´ÓÍ·¸´Ï°Ò»±é£¬Í¬Ê±ÔÙ²Ù×÷Ò»±é¡£
µÚÒ»Õ£¬Ñ§µÄÊÇOracleµÄÌåϵ½á¹¹£ ......
ʹÓÃCodeSmithÉú³ÉoracleÊý¾Ý¿â±íµÄʵÌå²ã(Model)
http://blog.csdn.net/dacong/archive/2009/01/27/3853663.aspx
×Ô¼ºÐ´µÄ£¬CodeSimthÖеÄÀý×Ó¶¼ÊÇmsSQL serverµÄ£¬ËùÒÔ×Ô¼ºÐ´Á˸öÖ§³ÖOracleÊý¾Ý¿â±íµÄ£¬²»Ò»¶¨ºÜÍêÉÆ£¬ÊÊÓþͺã¬Êý¾ÝÀàÐÍûÓÐÖÜÈ«¿¼ÂÇ£¬Ö»¿¼ÂÇÁ˳£ÓõÄһЩÀàÐÍ£¬Ôö¼ÓÁ˸ö±íÃû×ÖÊôÐÔ£¬²ÉÓõÄ.net2.0ÎÒ½á ......
ÔÚCenotOS 5.3ÖÐÎÄ»·¾³Ï°²×°Oracle 10g R2ʱ£¬½øÈëͼÐλ¯½çÃæºó£¬·¢ÏÖÖÐÎÄÂÒÂë¡£
ÔÚÍøÉÏËÑË÷ºó£¬·¢ÏÖÊÇÓÉÓÚLinuxÉÏûÓа²×°Oracle°²×°Ê±Ê¹ÓõÄ×ÖÌå¿âÔì³ÉµÄ¡£
´ÓÒÔÏÂÍøÕ¾ÏÂÔØ×ÖÌå¿â
http://download.csdn.net/source/1073202
È»ºóÔÚLinuxÏÂÖ´ÐÐÒÔÏÂÃüÁ°Ñ×ÖÌå¿â°²×°µ½ÏàӦλÖü´¿É
mkdir -p /usr/share/fonts/zh_CN ......
connect by Êǽṹ»¯²éѯÖÐÓõ½µÄ£¬Æä»ù±¾Óï·¨ÊÇ£º
select ... from tablename start with Ìõ¼þ1
connect by Ìõ¼þ2
where Ìõ¼þ3;
Àý£º
select * from table
start with org_id = 'HBHqfWGWPy'
connect by prior org_id = parent_id;
¼òµ¥ËµÀ´Êǽ«Ò»¸öÊ÷×´½á¹¹´æ´¢ÔÚÒ»ÕűíÀ±ÈÈçÒ»¸ö±íÖдæÔÚÁ½¸ö×Ö¶ ......
1¡¢×ª»»º¯Êý
Óëdate²Ù×÷¹Øϵ×î´óµÄ¾ÍÊÇÁ½¸öת»»º¯Êý£ºto_date(),to_char()
to_date() ×÷Óý«×Ö·ûÀàÐÍ°´Ò»¶¨¸ñʽת»¯ÎªÈÕÆÚÀàÐÍ£º
¾ßÌåÓ÷¨:to_date(''2004-11-27'',''yyyy-mm-dd''),Ç°ÕßΪ×Ö·û´®£¬ºóÕßΪת»»ÈÕÆÚ¸ñʽ£¬×¢Ò⣬ǰºóÁ½ÕßÒªÒÔÒ»¶ÔÓ¦¡£
Èç;to_date(''2004-11-27 13:34:43'', ''yyyy ......