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

oracle Óαê

oracle Óαê
¹Ø¼ü×Ö: oracle Óαê
1.       Óαê: ÈÝÆ÷£¬´æ´¢SQLÓï¾äÓ°ÏìÐÐÊý¡£
2.       ÓαêÀàÐÍ: ÒþʽÓα꣬ÏÔʾÓα꣬REFÓαꡣÆäÖУ¬ÒþʽÓαêºÍÏÔʾÓαêÊôÓÚ¾²Ì¬Óα꣨ÔËÐÐÇ°½«ÓαêÓëSQLÓï¾ä¹ØÁª£©,REFÓαêÊôÓÚ¶¯Ì¬Óαê(ÔËÐÐʱ½«ÓαêÓëSQLÓï¾ä¹ØÁª)¡£
3.       ÒþʽÓαê: DMLÓï¾ä¶ÔÓ¦µÄÓα꣬ÓÉOracle×Ô¶¯¹ÜÀí£¬Ò²³ÆSQLÓαꡣ£¨ËùÓеÄDML²Ù×÷¶¼±»OracleÄÚ²¿½âÎöΪһ¸öcursorÃûΪSQLµÄÒþʽÓα꣩
q      ÒþʽÓαêµÄÊôÐÔÓУº
q      %FOUND – SQL Óï¾äÓ°ÏìÁËÒ»Ðлò¶àÐÐʱΪ TRUE
q      %NOTFOUND – SQL Óï¾äûÓÐÓ°ÏìÈκÎÐÐʱΪTRUE
q      %ROWCOUNT – SQL Óï¾äÓ°ÏìµÄÐÐÊý
q      %ISOPEN - ÓαêÊÇ·ñ´ò¿ª£¬Ê¼ÖÕΪFALSE
¾ÙÀý˵Ã÷£º
Sql´úÂë
declare  
  
v_empno emp.empno %type:=7000;   
  
begin  
  
   update emp set ename='fxe' where empno=v_empno;   
  
   if SQl%found then  
  
      dbms_output.put_line(SQL%rowcount||'Delete Ok!');   
  
   end if;   
  
   if SQL%notfound then -- Ò»ÌõSQL¾Í±íʾÊÇÒ»¸öÒþʽÓÎ±ê   
  
      dbms_output.put_line('¹ÍÔ±±àºÅ'||v_empno||'²»´æÔÚ');   
  
   end if;   
  
end;  
declare
v_empno emp.empno %type:=7000;
begin
update emp set ename='fxe' where empno=v_empno;
if SQl%found then
dbms_output.put_line(SQL%rowcount||'Delete Ok!');
end if;
if SQL%notfound then -- Ò»ÌõSQL¾Í±íʾÊÇÒ»¸öÒþʽÓαê
dbms_output.put_line('¹ÍÔ±±àºÅ'||v_empno||'²»´æÔÚ');
end if;
end;
4. ÏÔʾÓαê


Ïà¹ØÎĵµ£º

Oracle ÈçºÎ¶¨Òå×Ô¶¯ÔöÁ¿autocreamentµÄÖ÷¼üID?

MySQLµÄID·Ç³£·½±ã¶¨Ò壬ֻҪָ¶¨Æä×ֶεÄ×Ô¶¯ÔöÁ¿ÊôÐÔ¼´¿É¡£
µ«ÊÇOracle²»ÐУ¬ÐèÒª¶¨ÒåsequenceºÍtriggedr£¬µ±È»trigger¿ÉÒÔ²»¶¨Ò壬µ«ÊDz»·½±ã¡£
±í¶¨ÒåÈçÏ£º
CREATE TABLE GAME
(
  ID           
INTEGER      ......

oracle index type

Âß¼­ÉÏ£º
Single column µ¥ÐÐË÷Òý
Concatenated ¶àÐÐË÷Òý
Unique ΨһË÷Òý
NonUnique ·ÇΨһË÷Òý
Function-basedº¯ÊýË÷Òý
Domain ÓòË÷Òý
ÎïÀíÉÏ£º
Partitioned ·ÖÇøË÷Òý
NonPartitioned ·Ç·ÖÇøË÷Òý
B-tree£º
Normal Õý³£ÐÍBÊ÷
Rever Key ·´×ªÐÍBÊ÷
Bitmap λͼË÷Òý
Ë÷Òý½á¹¹£º
B-tree£º
ÊʺÏÓë´óÁ¿µÄÔö¡¢É ......

ORACLE 10 (¸¶Ê×ê¿)ѧϰ±Ê¼Ç µÚ2½Ú ÃüÁî¡£

ORACLE 10 ѧϰ±Ê¼Ç-µÚ2½Ú-ÃüÁî¡£
1. inner join / left join/ right join / full join
select a.dname, b.ename from dept a, emp b where a.deptno=b.deptno and a.deptno=10;
select a.dname, b.ename from dept a inner join emp b
on a.deptno=b.deptno and a.deptno=10;
select dname,ename from dept natural ......

Oracle RAC ÐÞ¸Ä IP µØÖ·


 
IP µØÖ·×öÈçÏÂÐ޸ģº
Public IP 10.85.10.119/121    -- >  10.85.10.219/221
Privite IP 192.168.1.119/121   -- >  192.168.1.219/221
Virtual IP 10.85.10.122/123   --  ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ