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

±±´óÇàÄñoracleѧϰ±Ê¼Ç19 20 21 22

Óαê
Ö¸ÏòÉÏÏÂÎÄÇøÓòµÄ¾ä±ú»òÖ¸Õë
ÓαêÔÚ·þÎñÆ÷¶Î´æ´¢
ÊôÐÔ
    %NOTFOUND  ûÓÐÕÒµ½½á¹û»òûÓвÙ×÷³É¹¦
    %FOUND  ÕÒµ½½á¹û»ò²Ù×÷³É¹¦
    %ROWCOUNT  ÓαêÓ°ÏìµÄÐÐÊý
    %ISOPEN  ÓαêÊÇ·ñ´ò¿ª ÒþʽÓαêϵͳ×Ô¶¯Î¬»¤£¬ÓÀԶΪ¼Ù

ÀàÐÍ£º
¾²Ì¬Óαê

-ÒþʽÓαê
    ÔÚoracleÄÚ²¿ÉùÃ÷
    ÓÃÓÚ´¦ÀíDMLÓï¾äºÍ·µ»Øµ¥ÐеIJéѯ 
   
    SQLΪÒþʽÓαêĬÈÏÃû³Æ£¬Àý£º
begin
  insert into student values('3','test','m',sysdate);
  dbms_output.put_line('ÓαêÓ°ÏìµÄÐÐÊý£º'||SQL%ROWCOUNT);
end;

-ÏÔʽÓαê
ÓÉÓû§ÏÔʾÉùÃ÷
ÓαêÖ¸Ïò»î¶¯¼¯µÄµ±Ç°ÐÐ
¿ØÖÆÏÔʾÓαê
Open ´ò¿ªÓαê
Fetch … into …
Close ¹Ø±ÕÓαê

declare
  cursor stuCur is select * from student;
  stuRow student%rowtype;
begin
  open stuCur;
  loop
    fetch stuCur into sturow;
    exit when stuCur%NotFound;
    dbms_output.put_line(sturow.stu_name);
    dbms_output.put_line(stuCur%RowCount);
  end loop;
  close stuCur;
end;

REFÓαê(¶¯Ì¬Óαê)
ÔÚÔËÐÐʱʹ²»Í¬µÄÓï¾äÓëÖ®¹ØÁª
REFÓαêʹÓÃÓαê±äÁ¿
    Óαê±äÁ¿£ºÒ»ÖÖÒýÓÃÀàÐÍ£¬¿ÉÒÔÔÚÔËÐÐʱָÏò²»Í¬µÄ´æ´¢Î»Öã¬closeÓï¾ä¹Ø±ÕÓα겢ÊÍ·ÅÓÃÓÚ²éѯµÄ×ÊÔ´¡£
ÀàÐÍ£º
ÓÐÔ¼ÊøµÄÓαê±äÁ¿£º¾ßÓзµ»ØÀàÐÍ ¶¨ÒåÓαêʱ¼ÓÉÏreturn ÓαêÀàÐÍ
declare
  type RefstuCur is ref cursor return stu%rowtype;
  stuCur RefstuCur;
  sturow student%rowtype;
  flag int :=0;
begin
  flag := &flag;
  if flag = 0 then
    open stucur for select * from student where stu_id <= '2';
  else
    open st


Ïà¹ØÎĵµ£º

Oracle³£¼ûÎÊÌâ

´ó¼ÒÔÚÓ¦ÓÃORACLEµÄʱºò¿ÉÄÜ»áÓöµ½ºÜ¶à¿´ÆðÀ´²»ÄѵÄÎÊÌâ, ÌØ±ð¶ÔÐÂÊÖÀ´Ëµ, ½ñÌìÎÒ¼òµ¥°ÑËü×ܽáÒ»ÏÂ, ·¢²¼¸ø´ó¼Ò, Ï£Íû¶Ô´ó¼ÒÓаïÖú! ºÍ´ó¼ÒÒ»Æð̽ÌÖ, ¹²Í¬½ø²½!
¶ÔORACLE¸ßÊÖÀ´ËµÊDz»Óÿ´µÄ¡£
1. Oracle°²×°Íê³ÉºóµÄ³õʼ¿ÚÁî?
¡¡¡¡internal/oracle
¡¡¡¡sys/change_on_install
¡¡¡¡system/manager
¡¡¡¡scott/tiger
¡ ......

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   --  ......

oracle Set ÃüÁî½éÉÜ

oracle Set ÃüÁî½éÉÜ
http://luoke920.javaeye.com/blog/323743
1). ÉèÖõ±Ç°sessionÊÇ·ñ¶ÔÐ޸ĵÄÊý¾Ý½øÐÐ×Ô¶¯Ìá½»
SQL>SET AUTO[COMMIT] {ON|OFF|IMM[EDIATE]| n}
2)£®ÔÚÓÃstartÃüÁîÖ´ÐÐÒ»¸ösql½Å±¾Ê±£¬ÊÇ·ñÏÔʾ½Å±¾ÖÐÕýÔÚÖ´ÐеÄSQLÓï¾ä
SQL> SET ECHO {ON|OFF}
3).ÊÇ·ñÏÔʾµ±Ç°sqlÓï¾ä²éѯ»òÐ޸ĵÄÐÐÊý ......

OracleµÄPackageµÄ×÷ÓÃÒÔ¼°Ê¹ÓÃʲô¹¤¾ß±àд

1¡¢OracleµÄPackage³ýÁ˰Ѵ洢¹ý³Ì·Åµ½Ò»¶Ñ¶ùÒÔÍ⻹ÓÐûÓÐÆäËûµÄ×÷Ó㨺ô¦£©£¿
2¡¢ÈçºÎ°ÑÏÖÓеĴ洢¹ý³Ì¼ÓÈëµ½PackageÖУ¿
3¡¢³ýÁËʹÓÃSQL Plus£¬»¹ÓÐûÓÐʲô¹¤¾ß×öPackage?
4¡¢Ê¹ÓÃSQL Plus±àÒëPackage£¬ÊÇ·ñÿ´Î¶¼ÊDZàÒëPackageÖÐËùÓеĴ洢¹ý³Ì£¿
1¡¢Äã²»¾õµÃ°Ñ´æ´¢¹ý³Ì·ÖÃűðÀàÊǺÜÖØÒªµÄô£¬¶øÇÒ²»Í¬µÄpackageµÄ ......

oracle cast() º¯ÊýÎÊÌâ

¹Ø¼ü×Ö: oracle cast() º¯ÊýÎÊÌâ
SQL> create table t1(a varchar(10));
Table created.
SQL> insert into t1 values ('12.3456');
1 row created.
SQL> select round(a) from t1;
  ROUND(A)
----------
        12
SQL> select round(a,3) from t1;
ROUN ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ