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

С²ËÄñÎÊ£ºoracleÖеÄÒ»¸ö´¥·¢Æ÷ÎÊÌâ

ÎÊÌâ
£¨1£©±íemployeesºÍdepartment´æÔÚ²ÎÕÕÍêÕûÐÔÔ¼Êø£¬ÔÚ±íemployeesÖвåÈë¼Ç¼£¨‘70’£¬‘999’£©department_idΪ‘999’ʱ£¬department±íÖл¹²»´æÔÚdepartment_idΪ‘999’µÄ¼Ç¼£¬ËùÒÔÎ¥±³Á˲ÎÕÕÍêÕûÐÔÔ¼Êø,³öÏÖ“Integrity constraint violation error”ÌáʾÐÅÏ¢¡£
 UPDATE employees  SET department_id = 999  WHERE employee_id = 170;
-- Integrity constraint violation error
£¨2£©
CREATE OR REPLACE TRIGGER constr_emp_trig
AFTER UPDATE ON employees
FOR EACH ROW
BEGIN
INSERT INTO departments
VALUES (999, 'dept999', 140, 2400);
END;
/
½á¹û£ºInsert²Ù×÷ËäȻΥ·´Á˲ÎÕÕÍêÕûÐÔÔ¼Êø£¬µ«employees±íÖÐÒÀÈ»³É¹¦²åÈëÁËÒ»ÌõмǼ¡£


Ïà¹ØÎĵµ£º

oracle ±í¿Õ¼ä²Ù×÷

oracle±í¿Õ¼ä²Ù×÷Ïê½â
  1
  2
  3×÷Õߣº   À´Ô´£º    ¸üÐÂÈÕÆÚ£º2006-01-04 
  5
  6 
  7½¨Á¢±í¿Õ¼ä
  8
  9CREATE TABLESPACE data01
 10DATAFILE '/ora ......

ORACLE³£ÓÃÊýÖµº¯Êý¡¢×ª»»º¯Êý¡¢×Ö·û´®º¯Êý½éÉÜ

 
    ±¾ÎIJ¢²»×¼±¸½éÉÜÈ«²¿µÄoracleº¯Êý£¬µ±Ç°ÇéÊÆÏ£¬°³Ò²»¹Ã»Õâ¸öʱ¼ä£¬ÐèҪѧϰµÄ¶«Î÷Ì«¶àÁË£¬Òª°Ñ¶àÊýʱ¼ä»¨ÔÚѧϰ¾­³£ÄÜÓÃÉϵļ¼Êõ·½Ãæ:)£¬ËùÒÔÈç¹ûÊÇ×¼±¸ÉîÈëÁ˽âËùÓÐoracleº¯ÊýµÄÅóÓÑ£¬»¹ÊÇÈ¥¹Ø×¢£ºOracle SQL Reference¹Ù·½Îĵµ¸ü¿¿Æ×һЩ¡£
¡¡¡¡±¾Îĸü¶à½«»á½éÉÜÈý˼ÔÚÈÕ³£Öо­³£»áÓõ½µÄ ......

ORACLE ²é¿´Óû§ÃÜÂëÐÞ¸Äʱ¼ä

SQL> show user
USER is "SYS"
SQL> create user t1 identified by t1;
create user t1 identified by t1
*
ERROR at line 1:
ORA-01920: user name 'T1' conflicts with another user or role name
SQL> drop user t1 cascade;
User dropped.
SQL> create user t1 identified by t1;
Us ......

oracleÖбéÀúÊ÷ÐνṹµÄ·½·¨

 start with....connect by prior....×Ó¾ä
ÀýÈ磺employee±íÖеÄÊý¾ÝÈçÏ£º
employee_id     name    manager_id
       1                    ......

OracleÀ䱸·Ýʱ³öÏÖµÄÇé¿ö

      ÏÈÀ´¼òµ¥µÄ˵һÏÂORACLEµÄ±¸·Ý·½Ê½£¬Ïêϸ¹¦ÄÜ¿ÉÒÔËÑË÷һϡ£
      Ò»ÖÖÊÇÂß¼­±¸·Ý£¬¼´ËùνµÄµ¼³ö(Export)ºÍµ¼Èë(Import)ÃüÁÕâÖÖ·½Ê½µÄÓŵãÊÇ£¬Äܹ»¶ÔÊý¾Ý¿âÖеÄÿ¸ö¶ÔÏó½øÐб¸·Ý£¬²¢ÇÒʵÏÖ²»Í¬Æ½Ì¨ÏµÄÊý¾ÝǨÒÆ£¬µ«±¸·ÝµÄʱºòÊý¾Ý¿â²»ÄÜÊǹرյģ¬´ÓCMDÃüÁî½ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ